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