Board index » delphi » execute SQL statement

John Gunnarssin

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

execute SQL statement

Hi !

If i should execute a SQL statment like create table, crate database
etc.
i could use TQuery, but i get this error message:
"Error creating cursor handle", probably becouse tquery expects a
dataset as result, witch create operations dont return.
so my question is: Witch component should i use instead of tquery, or is
there a way to
manipulate tquery so i can use it for sql statement like create table,
create database etc.

very greatful for help
    --- John Gunnarsson, Imperia

ps. please send a copy to my mailbox
i...@jamtway.se

 
Christophe Cerbour

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:execute SQL statement


use ExecSQL method instead of OPEN...

BlueG

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:execute SQL statement


Are you using Query.Open or Query.ExecSQL?  And are you setting the
databasename property?
Quote
John Gunnarssin wrote in message <366806BD.492DB...@jamtway.se>...
>Hi !

>If i should execute a SQL statment like create table, crate database
>etc.
>i could use TQuery, but i get this error message:
>"Error creating cursor handle", probably becouse tquery expects a
>dataset as result, witch create operations dont return.
>so my question is: Witch component should i use instead of tquery, or is
>there a way to
>manipulate tquery so i can use it for sql statement like create table,
>create database etc.

>very greatful for help
>    --- John Gunnarsson, Imperia

>ps. please send a copy to my mailbox
>i...@jamtway.se

Krzysztof Borys (Ba

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:execute SQL statement


Quote
On Fri, 04 Dec 1998 16:58:53 +0100, John Gunnarssin <i...@jamtway.se> wrote:
>Hi !

>If i should execute a SQL statment like create table, crate database
>etc.
>i could use TQuery, but i get this error message:
>"Error creating cursor handle", probably becouse tquery expects a
>dataset as result, witch create operations dont return.
>so my question is: Witch component should i use instead of tquery, or is
>there a way to
>manipulate tquery so i can use it for sql statement like create table,
>create database etc.

Try using TQuery.ExecSQL
UIN:3620584                                            Bask
mailto:b...@kis.p.lodz.pl
Giovanni Ferrar

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:execute SQL statement


Quote
John Gunnarssin wrote:
> Hi !

> If i should execute a SQL statment like create table, crate database
> etc.
> i could use TQuery, but i get this error message:
> "Error creating cursor handle", probably becouse tquery expects a
> dataset as result, witch create operations dont return.
> so my question is: Witch component should i use instead of tquery, or is
> there a way to
> manipulate tquery so i can use it for sql statement like create table,
> create database etc.

> very greatful for help
>     --- John Gunnarsson, Imperia

> ps. please send a copy to my mailbox
> i...@jamtway.se

  The Query component has theese two methods to execute SQL statements::

Query.Open ( here you place statements like SELECT * from table
where..........)

Query.ExecuteSQL ( here you place statements like CREATE TABLE, INSERT INTO,
UPDATE TABLE and so on).

Now it is most likely that you are getting that error message because you
are trying to issue you "CREATE TABLE"
using "Query.Open".

Use Query.ExecuteSQL instead!

Med v?nlig h?lsning

Giovanni Ferrari

Other Threads

1. Executing SQL-Statements serial

2. How do you execute SQL statement without TQuery component?

3. [dbx][interbase] Can not execute SQL statements with SET TERM...

4. Execute SQL statement when a client is connect to the server?

5. SQL statement vs Delphi Code: Which is executes fastest

6. Several SQL Statements In one TADOConnection.Execute

7. Access violation executing a Sql statement

8. re-executing the sql-statement

9. Retrieve SQL Statement after execute

10. Building and executing a SQL Statement