Page 1 of 1

dbpExecSQL Update. How to know number of item updated

PostPosted: Sun Aug 03, 2014 8:18 am
by michi
Hi all, I use dbpExecSQL to update some records in a table. Is there a way to know the number of item updated? (if I use this command in Microsoft Access a window tell me how records will be updated).

Thanks all in advance

Michi

Re: dbpExecSQL Update. How to know number of item updated

PostPosted: Mon Aug 04, 2014 2:56 pm
by Neosoft Support
If it's a query, you can check the table's [$RecCount] variable. For example:

AlertBox "Result" "Number of records processed: [MyDB.MyTable.$RecCount]"