Error Creating Cursor Handle Insert
It always bring up this message "Error creating cursor handle.", although the data is updated correctly. What is this error message means? Thanks for any help. Huang Robert van Hoorna Delphi Developer Wed, 18 Jun 1902 08:00:00 GMT Re:"Error creating cursor handle" In article <34725214.DA48B...@pacific.net.sg>, CIMTEK
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 Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated 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 Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste http://www.delphigroups.info/2/54/42535.html 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' 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 http://www.tek-tips.com/viewthread.cfm?qid=1015 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 Creating Cursor Handle' speak (Programmer) 17 Jun 99 17:30 I seem to get this error periodically. Usually it's because I have forgotton to place the DataBase Name on the TQuery object. Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red F
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 http://www.delphipages.com/forum/showthread.php?p=14596 error in my application: Alex.EXE raised excpetion class enoresult set with message Error Creating http://computer-programming-forum.com/30-delphi&databases/ffe768fd37d42f0d.htm 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 error creating 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: error creating cursor 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:50 AM. Delphi Pages - Archive - Top - Contact Us Powered by vBulletin Version 3.8.8Copyright ©2000 - 2016, vBulletin Solutions, Inc.
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)