| Subject | Re: [IBO] Calculate how many rows updated by an UPDATE TABLE SET A=B WHERE C=D? |
|---|---|
| Author | Jason Wharton |
| Post date | 2001-09-19T16:20:06Z |
If you run the update in a TIB_DSQL component you can subsequently check the
RowsAffected property.
If you are in a stored procedure then you need to use the select as
supposed. I would also recommend that you be in a snapshot transaction as
well. Otherwise, I would deem it potentially inaccurate.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
RowsAffected property.
If you are in a stored procedure then you need to use the select as
supposed. I would also recommend that you be in a snapshot transaction as
well. Otherwise, I would deem it potentially inaccurate.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
----- Original Message -----
From: "Warren Postma" <warren-postma@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, September 13, 2001 12:05 PM
Subject: [IBO] Calculate how many rows updated by an UPDATE TABLE SET A=B
WHERE C=D?
> Do I have to do a separate SELECT FROM TABLE WHERE C=D and then do the
> UPDATE? Or can the UPDATE somehow return the count of rows modified?
>
> Warren