I'm work with MSSQL Server 2000, ADO 2.6,  Delphi5 Ent.

For example:
with ADODataSet1 do begin
 CommandType:=cmdText;
 CommandTimeout:=600;
 CommandText:='select * into #temp1 from dbo.Account select * from #temp1';
 Connection:=ADOConnection1;
 CursorLocation:=clUseClient;
 CursorType:=ctStatic;
 ExecuteOptions:=[eoAsyncExecute,eoAsyncFetch, eoAsyncFetchNonBlocking];
 LockType:=ltReadOnly;
 Open; //after open RecordCount = nothing
end;

Why ADODataSet with AsyncExecute and few SQL statements in CommandText don't
return results?

Best regards,
Andrey
tul...@amk.al.lg.ua