Catching multiple errors with async execution
- From: "Leonid Zeitlin" <lz@xxxxxxxxxxxx>
- Date: Fri, 26 Jan 2007 16:46:09 +0200
Hi all,
I am using a TADOCommand to run SQL commands against an SQL Server. I have
set ExecuteOptions to [eoAsyncExecute,eoExecuteNoRecords] for async
execution. I am trying to handle errors that the SQL command may generate by
adding handler to TADOConnection's OnExecuteComplete error. I am having
problems executing a command like this:
print "Creating table..."
create table XXX ...
If my "create table" statement fails, my OnExecuteComplete event handler
receives one error, and it is not the "create table" error but rather the
message from the "print" statement. Also ADOConnection.Errors collection is
empty.
Is there any way to find out about the real error in the second statement?
Thanks,
Leonid
.
- Prev by Date: Re: DAO to ADO and stored procs
- Next by Date: Re: sql question
- Previous by thread: Adding records is very slow.
- Next by thread: SQL and Scientific Notation
- Index(es):