Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

'Error Creating Cursor Handle' 1

Status
Not open for further replies.

igc

MIS
Mar 28, 1999
1
GB
'Error Creating Cursor Handle'<br>
Does anybody know what this means. Ihave a project with around 15 TQuery or TTable comps on it. everything was fine, then i added one more TQuery to do an INSERT and i getthe above error every time i try to activate it, the INSERT still works, i just get the error after. TQuerys doing insert that were added before this one still work ok and if a add a TQuery and do a SELECT that is ok. any ideas?
 
When you execute an SQL query that returns a result set, such as a SELECT statement, use TQuery.Open. <br>
<br>
An INSERT statement (and UPDATE, DELETE, etc.) which doesn't return a result set, should be executed with the TQuery.ExecSQL method. <br>
<br>
The error you are receiving indicates that the BDE is not able to create a cursor on the result set from the query, in this case, because there was no result set returned.
 
I seem to get this error periodically. Usually it's because I have forgotton to place the DataBase Name on the TQuery object.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top