Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change combobox caused index problem
Message
From
27/12/2002 17:17:50
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Change combobox caused index problem
Miscellaneous
Thread ID:
00736196
Message ID:
00736196
Views:
39
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
Next
Reply
Map
View

Click here to load this message in the networking platform