Error Creating Cursor Handle Delphi 5
Swedish Traditional Chinese Turkish | Location All Other RegionsASEANAustralia/New ZealandBeneluxD-A-CHGreater ChinaLatin AmericaNordicTaiwanUK and IrelandUS and CaribbeanCountriesBrazilCanadaFranceIndiaItalyJapanKorea (South)Russian FederationSpain Embarcadero Home Watch, Follow, & Connect with Us Share This Communities Articles Blogs Resources Downloads Help Submit Translation Printer-friendly EDN » Delphi » Database Show All [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) Latest Comments View AllAdd NewRSSATOM Move mouse over comment to see the full text Reply Posted by Stephen Schaff on May 25 2004Getting 'Error creating cursor handle' when using TStoredProcI admit to small amounts of knowlege when it comes to stored procedures and TDataSets. But I am getting this message when I try to call .Active := true on my TDataSet NOT a TQuerry and NOT a... Rating Average rating: 2.5 Votes: 0 1 1 0 0 Rating: 1 2 3 4 5 1=Poor, 5=Excellent Download Trial Buy Now Download Delphi10 now! Webinars on demand! More social media choices: Delphi on Google+ @RADTools on Twitter Server Response from: ETNASC01 Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved. Site Map Developer Tools Blackfish SQL C++Builder Delphi FireMonkey Prism InterBase JBuilder J Optimizer HTML5 Builder 3rdRail & TurboRuby Database Tools Change Manager DBArtisan DB Optimizer ER/Studio Performance Center Rapid SQL Technical Articles Tutorials White Papers Press Releases Newsletters Add Content (GetPublished) Audio Audio & Video Video Bugs & Suggestions (QualityCentral) Discussion Forums Examples (CodeCentral) Tags Technology Partners Downloads Free
Show Posts Tag Search Advanced Search Go to Page... Thread Tools Display Modes #1 09-28-2000, 01:06 PM N/A Guest Posts: n/a Error Creating Cursor Handle Why is happening this error in my application: Alex.EXE raised excpetion class enoresult set with message Error Creating Cursor Handle How can I correct this error? Thanks since now Heros #2 09-28-2000, 01:59 PM N/A Guest Posts: n/a RE: Error Creating Cursor Handle Reading the help file for D5 I found this: ENoResultSet is the exception class for unsuccessful attempts to open a dataset query. Unit-dbtables Description: ENoResultSet is raised http://edn.embarcadero.com/article/25392 by TQuery when an attempt is made to open the query without a SELECT statement. I would guess that you either called Query1.Open or set Query1.active to true when the statement you used in the Query1.SQL property was empty or will not return a live result set (INSERT, DELETE, UPDATE). Use Query1.ExecSQL; instead of Query1.Open or Query1.Activate. #3 03-30-2004, 05:14 AM rage_against Junior Member Join Date: http://www.delphipages.com/forum/showthread.php?p=14596 Mar 2004 Posts: 23 RE: Error Creating Cursor Handle In my program worked.. the error was caused by the "first" an "next" so I type before "query1.SQL.text:='select * from doc_tur';". try..... "They kill Kenny!!" rage_against View Public Profile Send a private message to rage_against Visit rage_against's homepage! Find all posts by rage_against « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is On Forum Rules Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Delphi Forum VCL DB-Aware Tools DB Tools Apps Samples .NET .NET DB-Aware .NET Tools .NET Samples Kylix General All times are GMT. The time now is 04:25 AM. Delphi Pages - Archive - Top - Contact Us Powered by vBulletin Version 3.8.8Copyright ©2000 - 2016, vBulletin Solutions, Inc.
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 https://www.experts-exchange.com/questions/10072099/Error-creating-cursor-handle.html Help Receive Real-Time Help Create a Freelance Project Hire for a http://computer-programming-forum.com/30-delphi&databases/ffe768fd37d42f0d.htm 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 error creating 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 error creating cursor to 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 Accepte
following SQL statements I get the message Error Creating Cursor Handle. 1) Insert into ItemsSold Select Items.* From Items Where Status = "Sold"; 2) Delete From Items Where Status = "Sold"; Both statements are in separate queries that run in an onclose event of a form. I then cannot close the form. If I view the tables afterwards the data has been inserted/deleted many thanks Andy Law Wed, 18 Jun 1902 08:00:00 GMT Jan Oon#2 / 4 Error Creating Cursor Handle-----Please Help Quote:>Whenever I try run the following SQL statements I get the message >Error Creating Cursor Handle. >1) >Insert into ItemsSold >Select Items.* >From Items >Where Status = "Sold"; >2) >Delete From Items >Where Status = "Sold"; >Both statements are in separate queries that run in an onclose event >of a form. I then cannot close the form. >If I view the tables afterwards the data has been inserted/deleted I also experienced this but it's nothing serious I think. Just put the SQL.Open around a Try .. Except block. I think this error is because no resultset is returned because you it's an insert/delete SQL so no cursor can be created... Greetings Jan Oonk Codim BV The Netherlands Wed, 18 Jun 1902 08:00:00 GMT Marcai#3 / 4 Error Creating Cursor Handle-----Please Help Quote:>Insert into ItemsSold >Select Items.* >From Items >Where Status = "Sold"; >2) >Delete From Items >Where Status = "Sold"; Try ExecSQL instead of Open / Close Query.SQL.Add('Insert into ItemsSold Select Items.*'); Query.SQL.Add('From Items Where Status = ''Sold'''): Query.ExecSQL; Wed, 18 Jun 1902 08:00:00 GMT Kirk Gra#4 / 4 Error Creating Cursor Handle-----Please Help I assumne U R opening the query using the open statment. This expects SQl that will return a recordset. Use execsql instead, this is provided for insert, delete and update statments. Cheers, Kirk. Quote: > >Whenever I try run the following SQL statements I get the message > >Error Creating Cursor Handle. > >1) > >Insert into ItemsSold >