Insert Query: ENoResultSet -- Error Creating Cursor Handle

John C. Bell III

Delphi Developer

Thu, 21 Aug 2003 08:41:01 GMT

Insert Query: ENoResultSet -- Error Creating Cursor Handle

Whenever I try to run the following query:

sql.add('Insert into ":alias1:table1.db" (cid)');
sql.add('Select distinct d1.cid from ":alias1:orders.db" d,');
sql.add(' ":alias1:main.db" d1');
sql.add('where (d.Code = "PAY")');
sql.add(' and (d.ID = d1.ID)');

I get the error ENoResultSet -- Error Creating Cursor Handle. I have
split the query up and I have about 85 values to insert. What am I doing
wrong.

John C. Bell II

Delphi Developer

Thu, 21 Aug 2003 09:05:27 GMT

Re:Insert Query: ENoResultSet -- Error Creating Cursor Handle

Sorry--I needed to use ExecSQL and not Open; haven't made that
mistake in so long I forgot about it.

"John C. Bell III" <jcb...@us.net> wrote in message
news:97s2in$aat$1@bob.news.rcn.net...

Quote

> Whenever I try to run the following query:

> sql.add('Insert into ":alias1:table1.db" (cid)');
> sql.add('Select distinct d1.cid from ":alias1:orders.db" d,');
> sql.add(' ":alias1:main.db" d1');
> sql.add('where (d.Code = "PAY")');
> sql.add(' and (d.ID = d1.ID)');

> I get the error ENoResultSet -- Error Creating Cursor Handle. I have
> split the query up and I have about 85 values to insert. What am I doing
> wrong.

Other Threads

1. ENoResultSet error message with error creating cursor handle

2. ENoResultSet: Error Creating Cursor Handle

3. Error creating cursor handle with an INSERT SQL query

4. error creating cursor handling for TQuery component with Insert SQL command

5. Multi-statement query (error creating cursor handle)

6. Error creating handle with a SQL INSERT query

7. ERROR : 'error creating cursor handle'

8. Error Creating Cursor Handle Error!

9. error creating cursor handle

10. "Error Creating Cursor Handle"