akebee Messages: 90 Registered: August 2011 Location: China
Member
The database is MSSQL.
i use blew code to call a stored procedure:
SQL.Execute("StoredProcedure");
if the database has BIG data,this code will execute not sucess!
i debug and step over this code,found that it has no delay!
but in fact this stored procedure execute at least cost 1 second,
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?