Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Update View, Help me!
Hi all,
I tried this coding to update a field on my view:
***
scan
if lookup(view1.field1, thisform.txtText1.value,;
view1.field1) = thisform.txtText1.value
replace view1.field2 with thisform.txtText2.value
endif
endscan
***
The problem I have is only 1 record(on the view) got updated. I would like to update all records on the view that match the condition I gave(= thisform.txtText1.value). I don't know how to have this coding inside a loop so it could be executed as many times as there are records in the view.
Please help me, any ideas, suggestions or advice would be great help!
Thanks.
Thanya.
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