Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with copy to type sdf
Message
 
 
To
30/01/2004 17:04:48
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00872552
Message ID:
00872559
Views:
19
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
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform