Hello,
I'm testing multithread capabilities of SDAC and currently found out, that calling breakexec during query execution time generates some EOLEDBError in executing thread (nice), but calling breakexec during fetch does not, just silently stops fetching. Why? The one thread, that is opening the query, should know, that the results are not complete and stop operation... Is there some option that would generate some exception in the thread, that opens such broken query?
Thanks, Ludek.
Breakexec during fetch does not generate any exception?
Re: Breakexec during fetch does not generate any exception?
Hello,
When you execute a query and then break it, SQL Server generates an error. When you fetch data and then break fetching, SQL Server does not generate any errors. That is why you do not get any error when you break fetching. We will investigate this question.
As a workaround, you can use a boolean variable indicating that fetching is not complete. Here is an example:
When you execute a query and then break it, SQL Server generates an error. When you fetch data and then break fetching, SQL Server does not generate any errors. That is why you do not get any error when you break fetching. We will investigate this question.
As a workaround, you can use a boolean variable indicating that fetching is not complete. Here is an example:
Code: Select all
MSQuery1.BreakExec;
FullyFetched := False;