SQL problem (error creating cursor handle)

David Pate

Delphi Developer

Fri, 18 Jul 2003 03:22:21 GMT

SQL problem (error creating cursor handle)

Using the object inspector--When trying to make Query.Active = true I get
the error "error creating cursor handle" The SQL code is

insert into phonelst
(chartno, number, place, relation)
VALUES (:1, :2, :3, :4);

???
Thanks,
David

David Pat

Delphi Developer

Fri, 18 Jul 2003 03:32:05 GMT

Re:SQL problem (error creating cursor handle)

Never mind. I found the answer above (must use ExecSQL and cannot set
Query.Active=true using the object inspector)

Quote

"David Pate" <dnp...@mobis.com> wrote in message

news:951rmt$smq1@bornews.inprise.com...

Quote

> Using the object inspector--When trying to make Query.Active = true I get
> the error "error creating cursor handle" The SQL code is

> insert into phonelst
> (chartno, number, place, relation)
> VALUES (:1, :2, :3, :4);

> ???
> Thanks,
> David

Other Threads

1. Error creating cursor handle with an INSERT SQL query

2. SQL: "Error creating cursor handle"

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

4. Error creating cursor handle, in a Local SQL statement

5. Stored Procedure Problem - Error Creating Cursor Handle

6. ENoResultSet error message with error creating cursor handle

7. ERROR : 'error creating cursor handle'

8. Error Creating Cursor Handle Error!

9. SQL 6.5, TStoredProc - cannot create cursor handle

10. error creating cursor handle