Using Update SQL 1

[jags22]

I am working with a DB2 database and ASP for a little web app. The problem is on an update, is there anyway to know if an update worked. I have to go and select on the new criteria to check right now but there has to be another way. DB2 will have a return code of 1 if it updated and 0 if it didn't but How do you capture it? Or is there another way? Thanks...

 

[jags22]

Actually, the return code will be 0 if updated and a -100 if it did not update and some other sql code if the sql is not valid.

 

[Sheco]

is the return code perhaps in a format such that it can be a row in an ADO recordset or an output parameter for an ADO command object??

 

[gmmastros]

This link is for a thread in the VB6 forum. If you are using ADO to connect to DB2, this method may work for you. It returns the number of records affected by a sql statement.

thread222-1222967



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jags22]

Sheco, the return code is the output returned from the sql. Errors can be narrowed down by the return code.

Thanks George, I will give it a shot.

 

[jags22]

Thanks, worked like a charm.