Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integer Arrays?
Message
From
06/01/2002 17:25:49
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
06/01/2002 17:17:41
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:
00601347
Views:
29
>>The weird behavior of your combo may come from other sources - are you sure the .boundcolumn=2, .boundto=.t. and that initially the value of the combo is a number? The third thing is important, because it'll convert your second column into strings if you leave the value to default (which is an empty string).
>
>Thank you for you response. I looked a the properties and .boundcolumn=2 and .boundto=.t. Not sure what you mean by "initially the value of the combo is a number?". I look at the array after form.load and the integers are converted to "Numeric". The problem is that the numeric value in the array -21474E+9 does not match the database value of -2147400000. I feel I need provide more information here. The data looks like this:
>Cust
>CUSTID(Integer) Name(Char)
>-2147400000 Fred
>-2147399999 Tom
>
>The ID is a foriegn key in orders
>ORDERID CUSTID(Integer) DESC
>1 -2147400000 Orginal Order
>2 -2147400000 Backup Order
>3 -2147399999 Orginal Order
>
>The form is the order form where the Customer is the combobox bound to Orders.custid field. The combobox array is loaded at the form.load

In the debugger, check what's the combo.value, is it 1 (as it would do if boundto=.f.), -2147400000 (as it should) or "-2147400000". In the latter case, find the .value in the PEM window and it probably has (none) there - just put a zero.

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