s updating multiple rows
-
Actually i have to update some multiple rows at a time in the following code. constr=Application("ConStr") set con_adm=CreateObject("ADODB.Connection") con_adm.open constr This is the connection to the database and then the query which is not executin sql_upd="update csd_order_item set ref_no="&ref_no(i)&",item_desc='"&description(i)&"',unit_price="&price(i)&" where oredr_no="&orderno here orderno is the primary key and against that particular refno all the items will be updated, that means refno and orderno are the candidate key when i am executing set rs=con_adm.execute(sql_upd) it is showing incorrect syntax. please it will be very kind of u if somebody could help me.
skd
-
Actually i have to update some multiple rows at a time in the following code. constr=Application("ConStr") set con_adm=CreateObject("ADODB.Connection") con_adm.open constr This is the connection to the database and then the query which is not executin sql_upd="update csd_order_item set ref_no="&ref_no(i)&",item_desc='"&description(i)&"',unit_price="&price(i)&" where oredr_no="&orderno here orderno is the primary key and against that particular refno all the items will be updated, that means refno and orderno are the candidate key when i am executing set rs=con_adm.execute(sql_upd) it is showing incorrect syntax. please it will be very kind of u if somebody could help me.
skd
neoghy wrote:
when i am executing set rs=con_adm.execute(sql_upd) it is showing incorrect syntax.
So dump the generated query and run it manually against your DB. Look for typos, missing spaces, misquoted strings, etc. Then figure out which part of your long string of concatenations broke it.
----
...the wind blows over it and it is gone, and its place remembers it no more...