Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric added field into query
Message
From
05/07/2002 10:33:58
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00675394
Message ID:
00675618
Views:
8
Hi Sergey


You're right, the field keeps its structure but my problem is that if I create a view or store the sql statement. Next time I open it, it appears with one single cero on the integer side. Then truncating the integer part next time it is executed.

Oscar

>>Hi Daniel
>>
>>
>>Somehow it is not working on the integer part of the number the field. It is getting truncated to a one single cero.
>>
>>Could it be a VFP SETing?
>>
>
>It's not truncated. That's the way numberic fileds are displayed in VFP. Run LIST STRUCTURE to see that field created has format N(12,8).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform