retreve number of records updated

[theAgencyMan]

is there a variable that can be accessed from a query that tells the number of records updated?
Thanks
KES

[TurboMini]

the query won't report back

you can keep track on your end, but you will only know how many you EXPECTED
to update, not how many you actually updated

if you trap the update statement(s) for errors, and do them one at a time
while keeping a counter, then you can keep track

otherwise, you could do a stored procedure that keeps count of the updated
records and returns a total

[Sojovi]

In SQL server you have the variable @@ROWCOUNT, that returns the number of rows
affected by the last SQL instruction. If you are running other DB, surely
there's a variable for that purpose.

UPDATE table SET column = value
WHERE column = value1

IF @@ROWCOUNT = 0
print 'Warning: No rows were updated'
ELSE
print str(@@ROWCOUNT)

REgards

[Dan Bracuk]

Run a select count(something) before your update. As long as the where clauses are the same, you will get your answer.

[theAgencyMan]

THanks , that's what i was looking for