Record count of db.execute result

[Samantha]

Hi,
How can I know the record count of the result from sql:
db.Execute str1, dbFailOnError

I want to execute an INSERT query in a loop, as long as there is result.
Is this possible?
Thanks in advance.

 

[Dirk Goldgar]

Hi,
How can I know the record count of the result from sql:
db.Execute str1, dbFailOnError

I want to execute an INSERT query in a loop, as long as there is
result. Is this possible?
Thanks in advance.

Interrogate the RecordsAffected property of the database object you used
to execute the SQL statement; e.g,

Do
str1 = ...
db.Execute str1, dbFailOnError
Loop Until db.RecordsAffected = 0

 

[Van T. Dinh]

Check Access VB Help on the RecordsAffected Property