Subject | RowsAffected - Is it reliable? |
---|---|
Author | Michael L. Horne |
Post date | 2001-02-02T02:54:25Z |
Hello
I was just running some tests, using IB_DSQL to do
an update then checking RowsAffected to see if
it affected a row. If it didn't then I assume
that the row is not in the DB and I run a DSQL
to do an insert.
This technique seems to work well and is faster
than select and then update or insert.
So I just wanted to make sure that RowsAffected
is reliable?
Thanks
Michael L. Horne
I was just running some tests, using IB_DSQL to do
an update then checking RowsAffected to see if
it affected a row. If it didn't then I assume
that the row is not in the DB and I run a DSQL
to do an insert.
This technique seems to work well and is faster
than select and then update or insert.
So I just wanted to make sure that RowsAffected
is reliable?
Thanks
Michael L. Horne