[All]
Getting 'Error creating cursor handle' when using TStoredProc
By: Borland Staff
Abstract: This error occurs, because the application tried to execute an SQL statement and retrieve a to execute an SQL statement and retrieve a result set that did not exist.
Problem:
When using TStoredProc and try to execute an InterBase
stored procedure the error 'Error creating cursor handle'
is generated.
Solution:
This error is the message that accompanies an
ENoResultSet exeception thrown by the BDE.
This error occurs, because the application tried
to execute an SQL statement and retrieve a
result set that did not exist.
When using TStoredProcs with InterBase execute
procedures the application must use the
TStoredProc.ExecProc method instead of the
TStoredProc.Open method (or setting active property
to true).
(See Data Definition Guide for more information on
execute stored procedures)
Connect with Us