Error Creating Cursor Handle Delphi
Contents |
Swedish Traditional Chinese Turkish | Location All Other RegionsASEANAustralia/New error creating cursor handle stored procedure ZealandBeneluxD-A-CHGreater ChinaLatin AmericaNordicTaiwanUK and IrelandUS and CaribbeanCountriesBrazilCanadaFranceIndiaItalyJapanKorea (South)Russian
Error Creating Cursor Handle Tquery
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
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://support.codegear.com/article/34863 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 03:48 AM. Delphi Pages - Archive - Top - Contact Us Powered by vBulletin Version 3.8.8Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified http://www.tek-tips.com/viewthread.cfm?qid=1015 Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated http://computer-programming-forum.com/30-delphi&databases/ffe768fd37d42f0d.htm SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by error creating Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Embarcadero: Delphi Forum at Tek-Tips HomeForumsProgrammersDevelopment ToolsEmbarcadero: Delphi Forum 'Error Creating Cursor Handle' thread102-1015 Forum Search FAQs Links MVPs 'Error Creating Cursor Handle' 'Error Creating Cursor Handle' error creating cursor igc (MIS) (OP) 29 Mar 99 02:20 'Error Creating Cursor Handle' 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? RE: 'Error Creating Cursor Handle' cmd (Programmer) 21 Apr 99 20:44 When you execute an SQL query that returns a result set, such as a SELECT statement, use TQuery.Open. An INSERT statement (and UPDATE, DELETE, etc.) which doesn't return a result set, should be executed with the TQuery.ExecSQL method. 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. RE: 'Error Creatin
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 > >Select Items.* > >From Items > >Where Status = "Sold"; > >2) > >Delete From Items > >Where Status = "Sold"; > >Both statements are in separate queries that