Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with decimals in remote views with Oracle
Message
From
09/11/2000 04:27:58
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00438691
Message ID:
00439562
Views:
25
No success.
I've created a native fox cursor, then appended data from the view and i lose all the decimals.


>>>You might try copying the field down to a native Currency field.
>>
>>Thanks for answering Ed. ¿In oracle or in VFP? I've tried in VFP without success. In Oracle is not possible cause data is used from other external applications.
>>
>
>In VFP - create a writable cursor matching the structure coming in from Oracle, append the data retrieve from the view into the local cursor, work with the cursor, and move the data back to the view after modifications are done, or if it's being used for reporting, just trash the data when complete. APPEND FROM will at least try to move data from identically names fields during the copy/append operation.
>
>Another possibility would be to use NTOM() against the field for display purposes when working with the data in a Grid - again, youy'd need to add code to get the results back, but you could probably create a custom textbox subclass to handle the process in a transparent fashion.
Saludos,
A.G.P.
---------
Previous
Reply
Map
View

Click here to load this message in the networking platform