Source language: Translate to:

dbpExecSQL Update. How to know number of item updated

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

dbpExecSQL Update. How to know number of item updated

Postby michi » Sun Aug 03, 2014 8:18 am

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
Michi

Started to use Neobook in 2003 when I was 12 to make interactive books. Coders saw me and smiled.
Nowadays I'm still using Neobook to create advanced and powerful softwares. Coders see me and say: «how did you make that?»
michi
 
Posts: 33
Joined: Wed Jun 25, 2014 3:01 am
Location: Italy

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

Postby Neosoft Support » Mon Aug 04, 2014 2:56 pm

If it's a query, you can check the table's [$RecCount] variable. For example:

AlertBox "Result" "Number of records processed: [MyDB.MyTable.$RecCount]"
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests