creating a delay during execution

[jcostanz]

I have a program that setups several tables in MySQL.
when I tell it to create a new table or add a column to a table, I have to follow it with this code:

for (int x = 0; x < 10; x++)
{
;
}

to delay execution of the next command other wise it errors out at runtime, the previous command is still running on the server.

Is there a better way of delaying execution for about 1-3 seconds, then using this loop?

Thanks
Jeff

 

[dalchri]

Try:

System.Threading.Thread.CurrentThread.Sleep(1000);

 

[jcostanz]

thanks