I have a chunk of code that creates and runs a number of dynamic SQL statements.
There have been occassions where the machine has not finished writing the information to the new query structure, and as a result the old query has been run instead.
Is the a way to delay each query run operation by 5 seconds. This will allow plenty of time for the queries to delete, rewrite and be in place ready for the next stage.
Example code and instructions would be great. I am guessing that some kind of count loop is what is require but I have no idea how to do that.
Many Thanks
Toni
There have been occassions where the machine has not finished writing the information to the new query structure, and as a result the old query has been run instead.
Is the a way to delay each query run operation by 5 seconds. This will allow plenty of time for the queries to delete, rewrite and be in place ready for the next stage.
Example code and instructions would be great. I am guessing that some kind of count loop is what is require but I have no idea how to do that.
Many Thanks
Toni
