Page 1 of 1
Check deleting records in SQL database
Posted: Wed Aug 16, 2006 4:28 am
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
Check deleting records in SQL database
Posted: Sat Aug 19, 2006 4:03 pm
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
Check deleting records in SQL database
Posted: Sat Aug 26, 2006 2:03 am
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.