Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integer Arrays?
Message
From
07/01/2002 22:43:37
Steve Summers
Pima County Superior Court
Tucson, Arizona, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00601324
Message ID:
00601787
Views:
33
>>>Steve,
>
>What is the combo's Controlsource set to? Are you refreshing the combo after moving the pointer in its controlsource?


Hi Jim. Thanks again for your response. The problem seems to be the way VFP converts integer values. When I use rowsourcetype=3-SQL, controlsource=Orders.custid, boundcolumn=2 and rowsource="Select name, custid from customers into cursor ccustomers" the value of the combo is in numeric format -2.1474E+9. The accual table value (orders.custid) is -2147483646. The displayvalue of the combo is "".

I guess the integer value is too large for vfp to correctly convert to numeric? Because -2.1474E+9 is not equal to -2147483646.
Thanks in advance or I hope this helps!

[STS]
:>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform