General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
A Combo has this method in it's interactive change event. Everything's fine until the key corresponding to the last record is selected. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SEEK Thisform.Combo4.value
IF FOUND( )
Thisform.Text2.value = RECNO( )
Thisform.CHARGEPERKARAT1.VALUE = chgperkt
Thisform.MEASUREMENTS1.VALUE = measure
Thisform.Combo3.VALUE = cut
Thisform.Combo2.VALUE = colors
Thisform.Combo1.VALUE = clarity
Thisform.PRODUCTDESCRIPTION1.VALUE = p_descript
Thisform.Text1.VALUE = entered
Thisform.Text3.VALUE = invoiced
Thisform.Text4.VALUE = total_chg
Thisform.Text5.VALUE = karatwt
Thisform.trans_descript.VALUE = transdesc
Thisform.Text7.VALUE = company
Thisform.Text8.VALUE = track_num
ELSE
&& GOTO RECNO(0)
Thisform.refresh
? 'Closest matching listing is ' + stocknum
? 'Record number: ' + ALLTRIM(STR(RECNO( )))
ENDIF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
It deletes everything in the record except in the key field.
Then anything goes...records copied on top of others.
This is a search method...no updating should be going on.
Has anyone run into this problem?
Thanks
JD
Previous
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