Error Creating Cursor Handle Oracle
Swedish Traditional Chinese Turkish | Location All Other RegionsASEANAustralia/New ZealandBeneluxD-A-CHGreater ChinaLatin AmericaNordicTaiwanUK and IrelandUS and CaribbeanCountriesBrazilCanadaFranceIndiaItalyJapanKorea (South)Russian FederationSpain Embarcadero Home Home Support Offerings Submit Case Resources Downloads Contact Us Printer-friendly Support KB » InterBase » Drivers » BDE Show All [All] Getting 'Error creating cursor handle' when using TStoredProc Abstract: Getting 'Error creating cursor handle' when using TStoredProc 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) Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved. Site Map Installation & Registration Annual Agreements Single Incident Supported Versions Installation & Registration Product Support Single Incident Discussion Forums Documentation Developer Network Bugs & Suggestions Examples Audio Audio & Video Video Registered User Downloads Maintenance Portal Free Trials Beta Programs
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error creating cursor handle Want to Advertise Here? Solved Error creating cursor http://support.codegear.com/article/34863 handle Posted on 1998-08-13 Delphi 1 Verified Solution 6 Comments 1,673 Views Last Modified: 2012-08-13 Hi I have a query, which are supposed to update all the entries in a table. The tablename is brukertb and is a Paradox table. The field which I try to update, is a logical field which I try to https://www.experts-exchange.com/questions/10072099/Error-creating-cursor-handle.html set to be False. When I try running it, I get the message "Error creating cursor handle" Here's my code: query1.sql.Clear; query1.sql.Add ('update brukertb set Def_signatur=False'); query1.open; I've tried several things, but can't find out to solve this. Thanx for all help! 0 Question by:bear040497 Facebook Twitter LinkedIn Google LVL 2 Best Solution by333 bear, when you execute SELECT statement, you must use Query1.Open or Query1.Active=True. When you execute UPDATE, INSERT, DELETE, etc., you must use Query1.ExecSql. So your code must look like this: Go to Solution 6 Comments LVL 10 Overall: Level 10 Delphi 6 Message Expert Comment by:viktornet1998-08-13 I'm not sure, because I'm not much into DBase, but isn't your code suppose to look like this... query1.open; query1.sql.Clear; query1.sql.Add ('update brukertb set Def_signatur=False'); .instead of your way that is query1.sql.Clear; query1.sql.Add ('update brukertb set Def_signatur=False'); query1.open; ------------------- Regards, Viktor Ivanov 0 LVL 2 Overall: Level 2 Delphi 1 Message Accepted
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand https://www.experts-exchange.com/questions/10098853/Error-Creating-Cursor-Handle.html Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error Creating Cursor Handle Want to Advertise Here? Solved Error Creating Cursor Handle Posted on 1998-11-16 MS SQL Server 1 Verified Solution 5 Comments 969 Views Last Modified: 2010-05-18 Hello! When I use stored procedure "sp_addlogin" by using Delphi Query Component, I got error message like "Error creating error creating cursor Handle". I don't what is wrong.. I just loginned as sa who contorl all database in SQL SERVER. After that I just send query string "sp_addlogin a,a,'Disaster' " to SQL SERVER. then I got a error message. Something strange is when I tried this sql string at ISQL_W it worked. Do I have to do something thati don't know..? I am beginner of SQL Server.. Please Help me... It's in a huryy. error creating cursor Have a good day... 0 Question by:folktale Facebook Twitter LinkedIn Google LVL 2 Best Solution byaliciaam You must have "set double quotes off" and SQL does not understand double quotes. SQL Server version 6.5 does not always flag stored procedure parameters enclosed in double quotation marks if the SET Go to Solution 5 Comments LVL 2 Overall: Level 2 MS SQL Server 2 Message Accepted Solution by:aliciaam1998-11-16 You must have "set double quotes off" and SQL does not understand double quotes. SQL Server version 6.5 does not always flag stored procedure parameters enclosed in double quotation marks if the SET QUOTED_IDENTIFIER ON option has been issued. Use SET QUOTED_IDENTIFIER OFF right before the stored procedure 0 LVL 2 Overall: Level 2 MS SQL Server 2 Message Expert Comment by:aliciaam1998-11-16 do not use single quotes for the password. 0 LVL 2 Overall: Level 2 MS SQL Server 2 Message Expert Comment by:aliciaam1998-11-16 Your program will send as a variable what is inside the double quotes, don't need to use single quotes with SQL. It already knows is a string 0 Message Author Comment by:folktale1998-11-16 Thank for your help... AND I have found fault to write question. I didn't use double quotes in query string, that is I used just sp_addlogin a,a,'Disaster'. In above