Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: SET NEAR and integer seek
Message
From
12/06/2005 16:29:09
 
 
To
12/06/2005 09:51:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01021240
Message ID:
01022616
Views:
9
>>PMFJI. The behavior you describe has nothing to do with the range of the numeric data type.
>
>Thanks for the info.
>
>Just a side question:
>From the help I see the numeric field type is stored as 1 to 20 bytes in a table. In memory numeric values are stored as 8 Bytes, I assume then it's simply a double, isn't it?
>
>Bye, Olaf.

You can see this here:
CREATE CURSOR mycursor (vv N(18,6))
INSERT INTO mycursor VALUES (9999999999.999999)
? mycursor.vv , mycursor.vv+0.000001
Previous
Reply
Map
View

Click here to load this message in the networking platform