Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change combobox caused index problem
Message
 
To
27/12/2002 17:17:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00736196
Message ID:
00736504
Views:
9
Was a zero value being placed into the field? I recently found that to be a problem with the combo box. It shifted records around, as displayed in the combo on the form. The actual values in the table were not changed in the other records, but the combo displayed incorrectly. When I changed the record with the zero, everything was good in the world again. :) I don't know why this happens, maybe it's a bug...or undocumented feature!

Dana

>I have a field "serial_no" in my form.
>This field is also a regular tag in the table.
>In the form there is a command button which allows
>the user to change the value of the serial_no for
>the current displayed record. My problem is when
>the user input a new serial no to replace that
>for the current record, i found that the serial_no
>of the last record in the table got changed instead
>of the current record. The order of the table is
>also out of sequence. I'd suppose my way to handle
>an indexed field as a combobox is not correct. I
>would appreciate any help to get me back to the
>right track.
>
>My table "table1 has serialNo" as tag and buffer_
>mode_override is 1.
>
>The following is the codes in my command
>button click():
>
>DO FORM TakeSerialNo TO sNo
>IF !EMPTY(sNo)
> THISFORM.cbSerialNo.value = ALLTRIM(sNo)
> THISFORM.refresh
>ENDIF
>
>Thank you
>JW
Where's the damned Any Key?...too late
Previous
Reply
Map
View

Click here to load this message in the networking platform