Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combo Search Deletes Last Record
Message
De
02/07/2000 23:13:12
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
 
 
À
02/07/2000 22:48:58
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00387629
Message ID:
00387631
Vues:
14
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
Fil
Voir

Click here to load this message in the networking platform