Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement