From: "Peter Theobald" <[EMAIL PROTECTED]>
> I have a SQL update. When it tries to update data a row that doesn't exist I
don't get an error, I don't get 0 rows, I get the query variable itself doesn't
exist!?
>
A query can exist and contain no rows.
RecordCount counts existing rows.
If query has no rows - RecordCount is meaningless and
will throw an error. Works every time. :)
In your case - no rows were updated so RecordCount has nothing
to count and nothing != zero.
There was a discussion here recently about how to count updated
rows ... if your rdbms has a fucntion like @@rows (MSSQL) you're
in business easily - if not you have to make monkeys jump through
flaming hoops to get an answer.
Pan
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
