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 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
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