 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Antonio Felix
Guest
|
 Posted: Fri Dec 12, 2003 2:49 pm Post subject: Re: "Error creating cursor handle" |
 |
|
"Carlos Aguero" <carlos986 (AT) hotmail (DOT) com> wrote:
| Quote: | Hi,
I am running a query from a c++builder6 application that connect to sql
server9.
my query is "insert into tablename values ('blah','blah')
as soon as I open the TQuery component I have this error
"Error creating cursor handle" Does anyone know what this is?
I have searched in the net but people don't say anything that is valuable
for me.
Please help.
Carlos
|
Hi Carlos,
You must use ExecSql instead of Open().
Insert Statements cannot create a cursor like Select Ones.
From the Help File
Call ExecSQL to execute the SQL statement currently assigned to the SQL property. Use ExecSQL to execute queries that do not return a cursor to data (such as INSERT, UPDATE, DELETE, and CREATE TABLE).
Note: For SELECT statements, call Open instead of ExecSQL.
HTH
Antonio
|
|
| Back to top |
|
 |
Carlos Aguero
Guest
|
| Posted: Fri Dec 12, 2003 3:17 pm Post subject: "Error creating cursor handle" |
|
|
Hi,
I am running a query from a c++builder6 application that connect to sql
server9.
my query is "insert into tablename values ('blah','blah')
as soon as I open the TQuery component I have this error
"Error creating cursor handle" Does anyone know what this is?
I have searched in the net but people don't say anything that is valuable
for me.
Please help.
Carlos
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
