SQL parse error

Article View: borland.public.delphi.database

Article #12

Back to borland.public.delphi.database Previous Next

#12

From: Johan
Date: Wed, 23 Jul 2003 20:14

48 lines
2514 bytes

Thx for your reply,

I have the following now,

*****

  try
    IBDatabase1.DatabaseName := dmDB.UseIniFile(True,'Data','DB','');
    IBDatabase1.LoginPrompt  := False;
    IBDatabase1.Params.Values['user_name'] := 'SYSDBA';
    IBDatabase1.Params.Values['password']  := 'masterkey';
    IBDatabase1.DefaultTransaction := IBTransaction1;
    IBDatabase1.Connected := True;
    if not IBTransaction1.InTransaction then
    Begin
      IBTransaction1.StartTransaction;
    End;
    IBSQL1.Database := IBDatabase1;
    IBSQL1.SQL.Text := 'Create table Employee (naam : char(20))';
    IBSQL1.ExecQuery;
    if IBTransaction1.InTransaction then
    Begin
      IBTransaction1.Commit;
    end;
  finally
    IBDatabase1.Connected := False;
  end;

*******

When it reaches the line "IBSQL1.ExecQuery;" i get an error .

Don't see what the problem might be, any suggestions?

thx in advance

Johan



"heiko Luettge" <luettge@boerde.de> wrote in message
news:bfj7s8$bf1$1@news.boerde.de...
>
> and additional to this use ExecSQL instead of Open
>
> Heiko
>
>

Technical Details

Message-ID: <3f1eec9a$0$49107$e4fe514c@news.xs4all.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!diablo.theplanet.net!kibo.news.demon.net!demon!transit.news.xs4all.nl!newsfeed.xs4all.nl!xs4all!not-for-mail

References: <3f194299$0$49110$e4fe514c@news.xs4all.nl> <3f19f873$0$8307$4d4ebb8e@news.nl.uu.net> <bfj7s8$bf1$1@news.boerde.de>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff75c,7a329eac3d9933a8
X-Google-Attributes: gidff75c,public
X-Google-Thread: f6386,7a329eac3d9933a8
X-Google-Attributes: gidf6386,public
X-Google-Thread: 115d96,7a329eac3d9933a8
X-Google-Attributes: gid115d96,public
X-Google-Thread: 10de66,7a329eac3d9933a8
X-Google-Attributes: gid10de66,public
X-Google-ArrivalTime: 2003-07-23 13:14:23 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!diablo.theplanet.net!kibo.news.demon.net!demon!transit.news.xs4all.nl!newsfeed.xs4all.nl!xs4all!not-for-mail
From: "Johan" <lijffijt@xs4all.nl>
Newsgroups: borland.public.delphi.database,borland.public.delphi.database.desktop,borland.public.delphi.database.multi-tier,borland.public.delphi.database.sqlservers
References: <3f194299$0$49110$e4fe514c@news.xs4all.nl> <3f19f873$0$8307$4d4ebb8e@news.nl.uu.net> <bfj7s8$bf1$1@news.boerde.de>
Subject: SQL parse error
Date: Wed, 23 Jul 2003 22:14:20 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Lines: 50
Message-ID: <3f1eec9a$0$49107$e4fe514c@news.xs4all.nl>
NNTP-Posting-Date: 23 Jul 2003 22:14:18 CEST
NNTP-Posting-Host: 213.84.249.41
X-Trace: 1058991258 news.xs4all.nl 49107 213.84.249.41:27994
X-Complaints-To: abuse@xs4all.nl

Reply to Parent Message