Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo Search Deletes Last Record
Message
From
06/07/2000 01:03:34
 
 
To
03/07/2000 09:06:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00387629
Message ID:
00388705
Views:
7
>>A Combo has this method in it's interactive change event. Everything's fine until the selection in the combo corresponding to the FIRST 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.
>>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