akebee Messages: 90 Registered: August 2011 Location: China
Member
By the way, the stored procedure will generated a table,i found that it execute sucess in fact, when i wait for some seconds
suc as:
TimeStop tm;
while(true)
{
if(tm.Elapsed() > 10*1000)
break;
}
// now the table has generated i can fetch it
sql.Execute("select date('now')");
while(sql.Fetch())
{
}
so the problem is how to know the procedure has completed, has any idea?