Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem to extract Numeric Field
Message
From
29/10/2001 12:25:20
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
29/10/2001 04:04:03
Amit Abhangrao
Charmi Software Exports
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00574348
Message ID:
00574592
Views:
29
>Hi All,
> I have win 95 (belgian dutch) o/s on my m/c.
>when i extract data from oracle, all numeric field which have fraction (decimal) value are not extracted properly
>
>Eg. When i do browse such Temporary table, when my cursor is not on numeric field it shows value as 13245.45 but when i put my cursor on numeric field
>it shows 13245.00.
> even when i put this value to any variable it just take 13245.00.
>i dont know how to get the proper value.
> please help me.

Check for Set("Point"). It could be your data are coming with a decimal comma, and your app has a decimal point, or vice versa. Try a different setting and reimport.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform