Liquid Fire Posted September 10, 2007 Share Posted September 10, 2007 I was think that sometimes when i am added or modifying a query, i some times mess up and it fail but the queries above have processed and then entered in junk data that i don't want because the last query failed. I was wondering if there was a way to check to see if a query will fail without really insert and data? That way i could test all the queries and if they pass then insert them into a "queue"(basically a string with a semi colon at the end fo the query) and then if all will pass i run the entire batch and if not it will fail out but not run any of the above queries. is this possible? Quote Link to comment Share on other sites More sharing options...
fenway Posted September 11, 2007 Share Posted September 11, 2007 Sounds like you need transactions. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.