Error Creating Cursor Handle Query
It always bring up this message "Error creating cursor handle.", although the data is updated correctly. What is this error 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 Posts Tag Search Advanced Search Go to Page... Thread Tools Display Modes #1 09-28-2000, 01:06 PM N/A Guest Posts: n/a Error Creating Cursor Handle Why is happening this error in my application: Alex.EXE raised excpetion class enoresult set with message Error Creating Cursor Handle How can I correct this error? Thanks since now Heros #2 09-28-2000, 01:59 PM N/A Guest Posts: n/a RE: Error Creating Cursor Handle Reading the help http://www.delphigroups.info/2/54/42535.html file for D5 I found this: ENoResultSet is the exception class for unsuccessful attempts to open a dataset query. Unit-dbtables Description: ENoResultSet is raised by TQuery when an attempt is made to open the query without a SELECT statement. I would guess that you either called Query1.Open or set Query1.active to true when the statement you http://www.delphipages.com/forum/showthread.php?p=14596 used in the Query1.SQL property was empty or will not return a live result set (INSERT, DELETE, UPDATE). Use Query1.ExecSQL; instead of Query1.Open or Query1.Activate. #3 03-30-2004, 05:14 AM rage_against Junior Member Join Date: Mar 2004 Posts: 23 RE: Error Creating Cursor Handle In my program worked.. the error was caused by the "first" an "next" so I type before "query1.SQL.text:='select * from doc_tur';". try..... "They kill Kenny!!" rage_against View Public Profile Send a private message to rage_against Visit rage_against's homepage! Find all posts by rage_against « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is On Forum Rules Forum Jump User Control Panel Private Messages Subscriptions Who's Online 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 http://www.tek-tips.com/viewthread.cfm?qid=1015 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 https://www.clubdelphi.com/foros/showthread.php?t=9027 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 error creating 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 error creating cursor 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 to create a cursor on the result set from the query, in this case, because there was no result set returned. RE: 'Error Creating Cursor Handle' speak (Programmer) 17 Jun 99 17:30 I seem to get this error periodically. Usually it's because I have forgotton to place the DataBase Name on the TQuery object. Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red Fla Herramientas Buscar en Tema Desplegado #1 11-04-2004 miguel_fr Miembro Registrado: Mar 2004 Ubicación: Santiago del estero, Capital Posts: 73 Error creating cursor handle Ese mensaje me da el compilador en el siguiente codigo Código: query1.Close; query1.SQL.Clear; query1.SQL.Add('Select * FROM tabla1 WHERE nombre = ' + QuotedStr(texto)); query1.Open; if Query1.IsEmpty then begin query1.Close; query1.SQL.Clear; query1.SQL.Add('Insert INTO tabla1 (nombre) Values (' + QuotedStr(texto)+')'); query1.Open; end; yo primero verifico que mi variable no este almacenada en la BD, hasta hay todo bien, al querer insertar dicho dato en la BD en el "Query1.open " me da el error Estoy poniendo mal el INSERT ? o estoy intentando de una manera erronea ingresar los datos? muchas gracias desde ya miguel_fr Ver Perfil Encontrar Todos los Mensajes de miguel_fr #2 11-04-2004 Julią T. Miembro Registrado: May 2003 Ubicación: en el teclado Posts: 314 el codigo es correcto, lo que pasa es que un insert no genera ningun cursor con resultado de datos por lo que lo correcto en este caso no es abrir una consulta sino ejecutar una sentencia SQL es decir: Código: Query1.ExecSql; //en vez de Query1.Open; Julią T. Ver Perfil ”Visita mi Sitio! Encontrar Todos los Mensajes de Julią T. #3 11-04-2004 miguel_fr Miembro Registrado: Mar 2004 Ubicación: Santiago del estero, Capital Posts: 73 Cita: Empezado por Julią T. el codigo es correcto, lo que pasa es que un insert no genera ningun cursor con resultado de datos por lo que lo correcto en este caso no es abrir una consulta sino ejecutar una sentencia SQL es decir: Código: Query1.ExecSql; //en vez de Query1.Open; guau muchas gracias no tenia niiiiii idea de todo lo que me acabas de decir muchisimas gracias, ya mismo comienzo a experimentar lo que me dijiste miguel_fr Ver Perfil Encontrar Todos los Mensajes de miguel_fr #4 19-12-2006 rodocucea Registrado Registrado: Dec 2006 Posts: 2 error creating cursor handle con update hola a todos, este es el codigo query1.Active:=false; query2.Close; Query2.SQL.Clear; Query2.SQL.Add('UPDATE dbprovee SET Activo=false where codigo='+#39+dbedit1.text+#39); showmessage(query2.SQL.Text); // para mostrar la consulta try begin query2.open; {Query2.ExecSQL;} Query2.Active:=true; end; except showmessage('no sirvio'); end; El problema es que me marca el error creating cursor handle en el open o en ExecSQL; que puedo hacer para que me realice el update. ?? rodocucea Ver