Check deleting records in SQL database
-
- Posts: 4
- Joined: Tue Aug 01, 2006 10:47 pm
- Location: Netherlands
Check deleting records in SQL database
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
-
- Posts: 4
- Joined: Tue Aug 01, 2006 10:47 pm
- Location: Netherlands
Check deleting records in SQL database
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
Check deleting records in SQL database
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.
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.