Information générale
Titre:
Using For loop values to an update query
Could you please help me out on this. I want to use the two column values which is in the list box into an update query until the last record from the list box.
following is the list box values with two columns listbox name is list1.
I | AT
O | CT
I | OP
I | CP
O | PC
O | TC
I want to use the above records values of two columns, one after the other until finished into an update query
for 1 to cnt
col1 = list1.column1
col2 = list2.column2
update docindex set i_o = col1 where tofrm = col2
ENDfor
Thank you very much.
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