Hi, please help me .
When display " -1 " in rowsAffected , whats mean?
Let>SQL=DELETE * FROM CUSTOMERS
DBExec>dbH,SQL,rowsAffected
rowsAffected = 1 ok
rowsAffected = 0 ok
rowsAffected = -1 ????
Thanks by answer
When display " -1 " in rowsAffected , whats mean?
Moderators: Dorian (MJT support), JRL
-
- Newbie
- Posts: 1
- Joined: Wed Aug 02, 2017 7:07 pm
- Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: When display " -1 " in rowsAffected , whats mean?
Probably means it failed. But it's going to depend on what kind of database you are using and what driver you are using. DBExec and DBQuery are simply dumb conduits. All they do is pass the sql string on to your driver and return the result that the driver returns to it. So the answer lies in the documentation of your database or the connection driver.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?