General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Change combobox caused index problem
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only