I assume you mean TStoredProc. Error Creating Cursor Handle Error! 4. SQL: "Error creating cursor handle" 9. "Error creating cursor handle" error ? 10. Problem: When using TStoredProc and try to execute an InterBase stored procedure the error 'Error creating cursor handle' is generated.
All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. But the ability to create custom scanning profiles al… Document Imaging Document Management OCR Images and Photos Photos / Graphics Software Xpdf - PDFtoPNG - Command Line Utility to Convert a Hope this help, have fun.
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 Register now while it's still free! More social media choices: Delphi on Google+ @RADTools on Twitter Server Response from: ETNASC01 Copyright© 1994 - 2013 Embarcadero Technologies, Inc. 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
Featured Post Java Android Coding Bundle Promoted by Experts Exchange Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. 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 ENoResultSet error message with error creating cursor handle 2. 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.
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 .. 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 Maybe you should put it >into a stored procedure and in the procedure give a record back. If your stored procedure receives any params, you must either set the value of the params property (Input) in design or run time to contain the values required by the stored
Execute with Open. 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, Already a member? This field will contain the returned value from the Stored procedure.
Red Flag This Post Please let us know here why this post is inappropriate. 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. D3 C/S Sybase Stored Proc: "Error creating cursor handle." Board index » delphi » ENoResultSet error message with error creating cursor handle Dwaine Horton Delphi Developer Sat, 03 Jan 2004 Check It Out Suggested Solutions Title # Comments Views Activity TTimer no longer functioning 7 60 258d Delphi Seattle: Project Options : Version info for all platforms, all releases? 2 44
There is no such component (at least not supplied by Borland). My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages MEGA Search 20.3 Million Sign Up From: Greg Rowland Subject: Error creating cursor handle NewsGroup: borland.public.delphi.database.sqlservers Date Posted: 1-May-2003 Close Box Join Tek-Tips Today! 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.
Maybe you should put it into a stored procedure and in the procedure give a record back. Thanks for any help. > >Huang Don't Active := True or Open the Query Use ExecSQL for SQL Statements that don't return a cursor INSERT,UPDATE,DELETE,CREATE,DROP etc... John Pierc Delphi Developer Sat, 03 Jan 2004 23:42:43 GMT Re:ENoResultSet error message with error creating cursor handle QuoteDwaine Horton wrote: >
When you execute UPDATE, INSERT, DELETE, etc., you must use Query1.ExecSql. But I am getting this message when I try to call .Active := true on my TDataSet NOT a TQuerry and NOT a... When I >>active this query, >>It always bring up this message "Error creating cursor handle.", >>although the data is updated >>correctly. Thanks for any help. >Huang Delphi tries to set a cursorhandle when using a query or even stored procedure.
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. What is this error message means? The following code generates "Error creating cursor handle". Huang Robert van Hoorna Delphi Developer Wed, 18 Jun 1902 08:00:00 GMT Re:"Error creating cursor handle" In article <[email protected]>, CIMTEK
Which the solution of this problem? >Juliano Morona Michal Motali Delphi Developer Wed, 18 Jun 1902 08:00:00 GMT Re:StoredProc: "Error creating cursor handle" Propably your stored procedure doesn't return cursor. Does any one have a clue why? I > assume you mean TStoredProc. > > Does the stored procedure return a result set? > Did you execute the procedure by calling Open or by calling ExecProc? > > Error creating cursor handle 7.
and here's why." Richard Jenkin Delphi Developer Wed, 18 Jun 1902 08:00:00 GMT Re:"Error creating cursor handle" In article <[email protected]>, CIMTEK Quote
Insert Query: ENoResultSet -- Error Creating Cursor Handle 2. Connect with top rated Experts 8 Experts available now in Live! Michal Motalik [email protected] QuoteJuliano Morona wrote in message <[email protected]>... >I connected a procedure of Oracle with component StoredProc and when >altering the property Active for True I received the mistake message win2k/XP "error creating cursor handle" 6. "Error creating cursor handle" 7. "Error creating cursor handle" 8.
I always test to see if my stored proc is already active because I may call the same stored proc from more than one place. When I >active this query, >It always bring up this message "Error creating cursor handle.", >although the data is updated >correctly.