Error Creating Cursor Handle Sql Server
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 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 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 Solution by:3331998-08-14 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: Query1.Sql.Clear; Query1.Sql.Add('update brukertb set Def_signatur=False'); Query1.ExecSql; AP 0 LVL 2 Overall: Level 2 Delphi 1 Message Expert Comment by:3331998-08-14 P.S. Viktor, Query.Open executes Sql statement. If Sql property is emty, Query.Open fails. AP 0 LVL 10 Overall: Level 10 Delphi 6 Message Expert Comment by:viktornet1998-08-14 As I said I still don't know much abouy DBase, but doesn't a person have to open first a quer
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 Handle Posted on https://www.experts-exchange.com/questions/10072099/Error-creating-cursor-handle.html 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 cursor Handle". I don't what is wrong.. I just loginned as sa who contorl all database in SQL SERVER. After that I just https://www.experts-exchange.com/questions/10098853/Error-Creating-Cursor-Handle.html 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. 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
It always bring up this message "Error creating cursor handle.", although the data is updated correctly. What is this error http://www.delphigroups.info/2/54/42535.html 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
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen