Sergey, I have my program set to access local vfp tables, vfp tables through remote views and oracle tables through remote views.

All 3 are setup identically but when looking at the result from copy to filename type sdf it is only the oracle remote view that has this behavious. None of the local table, local view or remote view to vfp table exhibits this behaviour.

How can I get around this?

Jason

>Jason,
>
>In VFP table numeric data internaly is stored as a character string. Because of that VFP adds one position for a sign and one for decimal separator.
>
>>Hello all. I am using remote views to access an oracle database.
>>
>>What I found was that when I am populating the view and then do a copy to filename type sdf and review the resulting file, all numeric fields are off by 2.
>>
>>N2 in the file is N4, N5 is N7, N1 is N3, N7.2 is N8.2.
>>
>>With foxpro tables and foxpro tables accessed through remote views there is no problem.
>>
>>Does anyone have an idea of what is happening here?
>>
>>I even went and using the command window:
>>use database?
>>(opened the remote database)
>>use remote view
>>copy stru to test1
>>use test1
>>modi stru
>>
>>and this verified that the field sizes were incorrect.
>>
>>Help
>>