Home > Bde Error > Bde Error Creating Cursor Handle

Bde Error Creating Cursor Handle

Thanks for any help. >>Huang >Delphi tries to set a cursorhandle when using a query or even stored >procedure. Try to use the ExecProc method. var sp:TStoredProc; begin if sp.active then sp.active:=false; // make sure the sp is not active sp.unprepare; sp.prepare; // Leaving this prepare out gives But in Query it's a little different.

Join our community for more solutions or to ask questions. Error creating cursor handle Наши проекты: Журнал · Discuz!ML · Алгоритмы · Естественные науки · Wiki · DRKB · Помощьпроекту ПРАВИЛА FAQ Помощь Поиск Участники Календарь Избранное DigiMania RSS Здравствуйте, Гость Another tip ... "error creating cursor handle" is one of those blitheringly-generic messages that Delphi uses for everything. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.

Join the community of 500,000 technology professionals and ask your questions. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. Juliano Morona Thanh Quac Delphi Developer Wed, 18 Jun 1902 08:00:00 GMT Re:StoredProc: "Error creating cursor handle" BDE is unable to create a cursor because it needs a cursor to What is this error message means?

This error occurs, because the application tried to execute an SQL statement and retrieve a result set that did not exist. Which the solution of this problem? >Juliano Morona Other Threads 1. "Error Creating Cursor Handle" 2. "Error creating cursor handle" 3. "Error Creating Cursor Handle" 4. "Error Creating Cursor Handle" 5. Here is my query: INSERT INTO EQHistory(Eq_job_nbr, Eq_id_nbr, Eq_date, Eq_hours, Eq_phase, Eq_technician, Eq_task_code, Eq_month, Eq_comments, Eq_paperwork, Eq_nopaperwork, [User], Webtrans) VALUES(:contract, :id, :date, :hours, :phase, :tech, :task, :month, :comments, :paperwork, :nopaperwork, :username, 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; Data.DataModule1.Query.SQL.Add('DROP TABLE Payroll'); try Data.DataModule1.Query.Prepare;

Delphi 3.02 C/S, BDE 4.51, MS SQL 6.5 SP4 on WinNT 4.0 SP4 using SQL Links (whew). Which the solution of this problem? >Juliano Morona Eric Owe Delphi Developer Wed, 18 Jun 1902 08:00:00 GMT Re:StoredProc: "Error creating cursor handle" I recieve this error if I forget to Error creating cursor handle 10. The following code generates "Error creating cursor handle".

sandrews Delphi Developer Wed, 18 Jun 1902 08:00:00 GMT SHOOT: Error creating cursor handle! Also returns same error in IDE when setting active in the Object Inspector. "Bill Todd" wrote in message news:[email protected] > > > On Thu, 1 May 2003 13:31:59 -0500, "Greg Updating does not give a cursorhandle. Delphi is usually handling an exception at that point, and what you do is to change the call to "FmtLoadStr" with the resource-string and "E.Message." Bingo... "Error creating cursor handle ..

Close Box Join Tek-Tips Today! This field will contain the returned value from the Stored procedure. A very simple modification that I made to Delphi here is to change the message to "Error creating cursor handle: %s." then rebuild the resource-file, then go through DBxxx.PAS looking for Regards, Viktor Ivanov 0 LVL 2 Overall: Level 2 Delphi 1 Message Expert Comment by:3331998-08-14 Viktor, I just say that when you call Query.Open, Delphi automaticaly executes SQL, posted in

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 If you are use TTable, then yes, you must first open table and then do what you want. SQL Cursor error handle message 6. 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

You are using the Open method for your > TQuery components when you should be using the ExecSQL method. > If the TQuery uses a SELECT statement (and thus creates a Error creating cursor handle using StoredProc 10. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. When you execute UPDATE, INSERT, DELETE, etc., you must use Query1.ExecSql.

There is no such component (at least not supplied by Borland). John Pierc Delphi Developer Sat, 03 Jan 2004 23:42:43 GMT Re:ENoResultSet error message with error creating cursor handle QuoteDwaine Horton wrote: > Updating does not give a cursorhandle.

Already a member?

Usua… Delphi An example of Operator Overloading in Delphi XE2 Article by: developmentguru In my programming career I have only very rarely run into situations where operator overloading would be of BTW, I am using SQL7.0, D4, BDE 5.11 -- Dwaine Horton York Strategic Accounts Programmer [email protected] 800-438-4447x2318 704-357-3434(f) Russell Smit Delphi Developer Sat, 03 Jan 2004 21:20:47 GMT Re:ENoResultSet error Error creating cursor handle using StoredProc 8. What is this error message means?

any ideas? If your stored procedure returns any values, you should see params (Output) which will contain the returned values. 3. Site Map Developer Tools Blackfish SQL C++Builder Delphi FireMonkey Prism InterBase JBuilder J Optimizer HTML5 Builder 3rdRail & TurboRuby Database Tools Change Manager DBArtisan DB Optimizer ER/Studio Performance Center Rapid SQL Error creating cursor handle 9.

© Copyright 2017 gatoisland.com. All rights reserved.