dkingsf
asked on
Getting return codes (update verification) from Oracle, SQL Server and Sybase
Making calls to update tables with VB program. Need to verify updates via return code/completion code. This is done for Oracle, SQL Serve and Sybase databases.
How do I accomplish this?
How do I accomplish this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Also, if using ADO, you can use the following syntax :
con.Execute sSQL, lAffected
lAffected returns the number of records affected by the sSQL statement executed. If lAffected = 0 then no records were affected ie. no update was actually done.
HTH,
Alon
Also, if using ADO, you can use the following syntax :
con.Execute sSQL, lAffected
lAffected returns the number of records affected by the sSQL statement executed. If lAffected = 0 then no records were affected ie. no update was actually done.
HTH,
Alon
Hi dkingsf,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Split points between: marper@idg and AlonHirsch
dkingsf, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Split points between: marper@idg and AlonHirsch
dkingsf, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
Per recommendation split points.
Points reduced from 100 to 50.
This Q awarded to marper.
AlonHirsch,
Points for you here: https://www.experts-exchange.com/questions/20560314/Points-for-AlonHirsch-re-20333563.html
Thank you,
RotaredoM
CS Mod @ EE
Points reduced from 100 to 50.
This Q awarded to marper.
AlonHirsch,
Points for you here: https://www.experts-exchange.com/questions/20560314/Points-for-AlonHirsch-re-20333563.html
Thank you,
RotaredoM
CS Mod @ EE
C-shell script to kill process(s) Date: 10/16/2001 12:26PM PST
https://www.experts-exchange.com/questions/20194007/C-shell-script-to-kill-process-s.html
Thanks,
Anthony