Error Creating Cursor Handle Delphi 7
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
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://www.delphigroups.info/2/54/42535.html 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:47 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 Help Receive Real-Time Help Create a Freelance Project Hire for a https://www.experts-exchange.com/questions/10098853/Error-Creating-Cursor-Handle.html 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 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 error creating stored procedure "sp_addlogin" by using Delphi Query Component, I got error message like "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. error creating cursor Do I have to do something thati don't know..? I am beginner of SQL Server.. Please Help me... It's in a huryy. 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 sin