Michel the data is fine. It the name of the field that get cut to 10 chr not the data. ( in the select I have MyLongNameFeild1 and in the cursor I have MyLongName)
>>We are doing a transfer of data from VFP database (DBC) via a remote view with ODBC. What we are doing is transfer data to an another table.
>>
>>Select ViewFld1 as MyLongNameField1 from ViewRemote into curosr MyTmpCursor
>>select MyTable
>>Append from dbf("MyTmpCursor")
>>
>>
>>The result of my cursor cut the field name to 10 chr. (MyLongName)?
>>Why? Is this normal?
>
>Is the ViewFld1 length of the first record 10 characters? If this is the case, you might want to force it to be the max length of the field.