nageswaragunupudi wrote:does Function FWAdoStruct(objRS) work only on "active" Record
Please post a DBF Structure here so that we both work on the same structure
- Code: Select all Expand view
Local aStruct := { ;
{ "TEST_C" ,"C" , 10, 0 } ,;
{ "TEST_N" ,"N" , 10, 2 } ,;
{ "TEST_D" ,"D" , 8, 0 } ,;
{ "TEST_L" ,"L" , 1, 0 } }
DbCreate( "TESTTYPE.DBF", aStruct, "FOXCDX" )
---
- Code: Select all Expand view
cQuery = "CREATE TABLE testtype ( TEST_C TEXT ( 10) , TEST_N DOUBLE , TEST_D DATE , TEST_L BIT )"
var2char( aStruct ) =
"{{TEST_C, C, 255, 0, 202, .T., 255, 12, 255, 255},
{TEST_N, N, 17, 2, 5, .T., 8, 8, 15, 255},
{TEST_D, D, 8, 0, 7, .T., 8, 8, 255, 255},
{TEST_L, L, 1, 0, 11, .T., 2, 2, 255, 255}}"
- Code: Select all Expand view
cQuery = "CREATE TABLE testtype ( TEST_C TEXT ( 10) , TEST_N NUMBER , TEST_D DATE , TEST_L LOGICAL )"
var2char( aStruct ) =
"{{TEST_C, C, 255, 0, 202, .T., 255, 12, 255, 255},
{TEST_N, N, 17, 2, 5, .T., 8, 8, 15, 255},
{TEST_D, D, 8, 0, 7, .T., 8, 8, 255, 255},
{TEST_L, L, 1, 0, 11, .T., 2, 2, 255, 255}}"