Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo Search Deletes Last Record
Message
From
02/07/2000 23:13:12
 
 
To
02/07/2000 22:48:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00387629
Message ID:
00387631
Views:
13
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
Map
View

Click here to load this message in the networking platform