Check deleting records in SQL database

Discuss RoboTask here
Post Reply
robertbense
Posts: 4
Joined: Tue Aug 01, 2006 10:47 pm
Location: Netherlands

Check deleting records in SQL database

Post by robertbense »

Hi,With a dataloop I'am doing some SQL statements.E.g. deleting records in a database.This works all fine.However I have to go to the database to check whether the records indeed have been deleted.How can I check this directly via a returncode in RoboTask what the result was of the SQL statement?Robert
robertbense
Posts: 4
Joined: Tue Aug 01, 2006 10:47 pm
Location: Netherlands

Check deleting records in SQL database

Post by robertbense »

Of course I can try to read next time a database record in MySQL and then I will automatically see whether it exists or not.But I hope there is a way that I can do this smarter by let RoboTask return a parameter. Based upon he returned value you can see whether it was successful.Oleg is this possible?Robert
Oleg
Site Admin
Posts: 3014
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Check deleting records in SQL database

Post by Oleg »

Thank you for your remark.
ADO engine returns amount of affected records as result of query executing. But RoboTask ignores this value.
I wrote this into our ToDo list and we shall add this feature in next release.
Post Reply