Link to home
Start Free TrialLog in
Avatar of dkingsf
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?
ASKER CERTIFIED SOLUTION
Avatar of marper
marper
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anthony Perkins
Please maintain this open question:
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
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
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
Avatar of RotaredoM
RotaredoM

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