Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with decimals in remote views with Oracle
Message
De
09/11/2000 04:27:58
 
 
À
08/11/2000 06:37:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00438691
Message ID:
00439562
Vues:
26
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.
---------
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform