Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement