Bde Error Creating Cursor Handle
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 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 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
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 http://www.tek-tips.com/viewthread.cfm?qid=1015 6 Comments 1,667 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 https://www.experts-exchange.com/questions/10072099/Error-creating-cursor-handle.html 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
C/S, BDE 4.51, MS SQL 6.5 SP4 on WinNT 4.0 SP4 using SQL Links (whew). The http://www.delphigroups.info/2/d7/246882.html dog gone thing doesn't give me an error code or I would have posted that too. The error occurs when the code to create http://www.devsuperpage.com/search/Articles.asp?ArtID=142609 the table runs (It DOES NOT occur at the drop table). Also it is not a BDE error because show_error in not called. Does any bde error one have a clue why? Also how do you search for a table then drop it if it exists (keeps the create table from complaining too loudly). procedure TDataModule1.make_table; begin // remove table Data.DataModule1.Query.Close; Data.DataModule1.Query.SessionName := Data.DataModule1.MySession.SessionName; Data.DataModule1.Query.DatabaseName := Data.DataModule1.MyDatabase.DatabaseName; Data.DataModule1.Query.Params.Clear; Data.DataModule1.Query.SQL.Clear; bde error creating Data.DataModule1.Query.SQL.Add('DROP TABLE Payroll'); try Data.DataModule1.Query.Prepare; Data.DataModule1.Query.Open; except on E: EDBEngineError do show_error(e); else raise; end; // make the table Data.DataModule1.Query.Close; Data.DataModule1.Query.SessionName := Data.DataModule1.MySession.SessionName; Data.DataModule1.Query.DatabaseName := Data.DataModule1.MyDatabase.DatabaseName; Data.DataModule1.Query.Params.Clear; Data.DataModule1.Query.SQL.Clear; Data.DataModule1.Query.SQL.Add('CREATE TABLE Payroll ('); Data.DataModule1.Query.SQL.Add('employeeid CHAR(10) NOT NULL,'); Data.DataModule1.Query.SQL.Add('applydate DATETIME,'); Data.DataModule1.Query.SQL.Add('amount INT,'); Data.DataModule1.Query.SQL.Add('paycategory INT,'); Data.DataModule1.Query.SQL.Add('occcode CHAR(3),'); Data.DataModule1.Query.SQL.Add('shift CHAR(1),'); Data.DataModule1.Query.SQL.Add('total INT,'); Data.DataModule1.Query.SQL.Add('fld1 INT,'); Data.DataModule1.Query.SQL.Add('fld2 INT,'); Data.DataModule1.Query.SQL.Add('fld3 INT,'); Data.DataModule1.Query.SQL.Add('cod1 INT,'); Data.DataModule1.Query.SQL.Add('cod2 INT,'); Data.DataModule1.Query.SQL.Add('cod3 INT,'); Data.DataModule1.Query.SQL.Add('workorder CHAR(9),'); Data.DataModule1.Query.SQL.Add('PRIMARY KEY (employeeid)'); Data.DataModule1.Query
error? Thanx in advance, Greg From: Greg Rowland Subject: Re: Error creating cursor handle NewsGroup: borland.public.delphi.database.sqlservers Date Posted: 1-May-2003 at 15:58:33 PST Oops, I did not return the OUTPUT correctly. From: Greg Rowland Subject: Re: Error creating cursor handle NewsGroup: borland.public.delphi.database.sqlservers Date Posted: 1-May-2003 at 14:28:6 PST Hi Bill, Yes, TStoredProc Yes, Returns a single result value. Execute with Open. Also returns same error in IDE when setting active in the Object Inspector. "Bill Todd"