Home > Bde Error > Bde Error Creating Cursor Handle

Bde Error Creating Cursor Handle

You can try this. { just trying to explain a little :) } AP 0 Message Author Comment by:bear0404971998-08-16 This example worked great! SQL: "Error creating cursor handle" 9. "Error creating cursor handle" error ? 10. WOW that worked......Thanks QuoteSteve Koterski wrote: > On Fri, 26 Feb 1999 13:06:20 -0500, sandrews wrote: > >The following code generates "Error creating cursor handle". > >Delphi 3.02 C/S, BDE All rights reserved.

If you are use TTable, then yes, you must first open table and then do what you want. The field which I try to update, is a logical field which I try to set to be False. Somewhere in your code, call the following methods to execute the stored procedure: StoredProc1.Prepare; StoredProc.ExecProc; Edit1.Text := StoredProc1.ParamsByName('Value').AsString; 'Value' is the field which Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re… Delphi How to create custom scanning profiles in PaperPort - Part 1 Video

Thanks for any help. >>Huang >Delphi tries to set a cursorhandle when using a query or even stored >procedure. The dog gone thing doesn't give me an error code or I would have posted that too. Error creating cursor handle using StoredProc 10. Other Threads 1. "Error Creating Cursor Handle" 2. "Error Creating Cursor Handle" 3. "Error Creating Cursor Handle" 4.

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, Red Flag This Post Please let us know here why this post is inappropriate. 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 Close Box Join Tek-Tips Today!

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 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 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. Solution: This error is the message that accompanies an ENoResultSet exeception thrown by the BDE.

Error creating cursor handle 10. Ihave a project with around 15 TQuery or TTable comps on it. Error creating cursor handle 7. SQL: "Error creating cursor handle" 9.

BTW, I am using SQL7.0, D4, BDE 5.11 -- Dwaine Horton York Strategic Accounts Programmer dwaine.hor...@york.com 800-438-4447x2318 704-357-3434(f) Russell Smit Delphi Developer Sat, 03 Jan 2004 21:20:47 GMT Re:ENoResultSet error I assume you mean TStoredProc. Delphi 3.02 C/S, BDE 4.51, MS SQL 6.5 SP4 on WinNT 4.0 SP4 using SQL Links (whew). Close this window and log in.

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 .. Does any one have a clue why? When I >active this query, >It always bring up this message "Error creating cursor handle.", >although the data is updated >correctly. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission.

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. If your stored procedure returns any values, you should see params (Output) which will contain the returned values. 3. error creating cursor handle 7. "Error Creating Cursor Handle" 8. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action.

Did you execute the procedure by calling Open or by calling ExecProc? -- Bill (TeamB) (TeamB cannot respond to questions received via email) What is this error message means? 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.

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

You are using the Open method for your TQuery components when you should be using the ExecSQL method. Updating does not give a cursorhandle. 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 It does this via a c… Document Imaging Document Management Adobe Acrobat Images and Photos Photos / Graphics Software Advertise Here 823 members asked questions and received personalized solutions in the

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. 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 The tablename is brukertb and is a Paradox table. 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!

Error creating cursor handle using StoredProc 10. Hope this help, have fun. Error Creating Cursor Handle Error! 5. Connect with top rated Experts 8 Experts available now in Live!

When using TStoredProcs with InterBase execute procedures the application must use the TStoredProc.ExecProc method instead of the TStoredProc.Open method (or setting active property to true). (See Data Definition Guide for more On Tue, 17 Mar 1998 16:45:29 -0300, "Juliano Morona" Quote wrote: >I connected a procedure of Oracle with component StoredProc and when >altering the property Active for True I received the Sundial Servic Delphi Developer Wed, 18 Jun 1902 08:00:00 GMT Re:"Error creating cursor handle" In article R...@KTIBV.NL (Robert van Hoornaar) writes: Quote>In article <34725214.DA48B...@pacific.net.sg>, > CIMTEK wrote: >>I Log On | English My default language Arabic Brazilian Portuguese Bulgarian Croatian Czech English Finnish French German Hebrew Hellenic (Greek) Hungarian Italian Japanese Korean Norwegian Polish Portuguese Russian Simplified Chinese Spanish

Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. 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 This field will contain the returned value from the Stored procedure. TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text.

Try to use the ExecProc method. Maybe you should put it into a stored procedure and in the procedure give a record back. win2k/XP "error creating cursor handle" 6. "Error creating cursor handle" 7. "Error creating cursor handle" 8. 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.

This error occurs, because the application tried to execute an SQL statement and retrieve a result set that did not exist. The error you are receiving indicates that the BDE is not able to create a cursor on the result set from the query, in this case, because there was no result Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Join our community for more solutions or to ask questions.

ERROR : 'error creating cursor handle' 4. Any other ideas?