FOR UPDATE using Sqlstringconnect RETURNING -1

Dear,

any one know why "for update" is returning -1 if using sqlconnect?

lcStringConn="Driver={MySQL ODBC 8.0 ANSI Driver};Port=3306;NOSSPS=1;Option=67108864"+; ";Server="+lcServer+; ";Database="+lcDatabase+; ";Uid="+usr+; ";Pwd="+pswd+; ";sslca="+SSLCA+; ";sslcert="+SSLCERT+; ";sslkey="+SSL_KEY+; ";sslverify=1"+; ";Option=3" ServerStrConn=Sqlstringconnect(lcStringConn)

SQLCommand="SELECT COUNTER FROM MSCOUNTER WHERE rowid=?nRowID "+; "FOR UPDATE; "+; "UPDATE MSCOUNTER SET COUNTER = COUNTER +1, USRUP=?lcUSP, DTUP=?lcDUP "+; "WHERE rowid=?nRowID "

SQLOK=SQLExec( ServerStrConn, SQLCommand, "vw_counter" )

this SQLOK always return -1, thou in mysql it works fine. any advise ? thanks.

0
edit delete
are you sure?
asked Harry Buana

3 answers

Things can change so fast with third party products,Not sure if you are interested in 3rd party product but here is the solution SSIS Postgresql Read

0
edit delete
are you sure?
answered Anjali Verma

Thanks Anjali,

I'm in a process of reviewing my codes, hope to find why this happened. thank you.

0
edit delete
are you sure?
answered Harry Buana

Hello Harry,

i think that problem is in SQLCommand. Try write like this:

SQLCommand=" SELECT COUNTER FROM MSCOUNTER WHERE rowid=?nRowI FOR UPDATE; UPDATE MSCOUNTER SET COUNTER = COUNTER +1, USRUP=?lcUSP, DTUP=?lcDUP WHERE rowid=?nRowID"

SQLCommand=replace(SQLCommand,"?nRowID",?nRowID)

SQLCommand=replace(SQLCommand,"?lcUSP",?lcUSP)

SQLCommand=replace(SQLCommand,"?lcDUP ",?lcDUP )

Maybe this help solve your problem.

0
edit delete
are you sure?
answered Krysztof Spaliński

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions

This page is the archive of this page:https://www.connectionstrings.com/questions/54209/for-update-using-sqlstringconnect-returning-1/, the copyright belongs to the original page!
aspxhtmlmobile0898kendouidemosaspxhtml docs