Re: SQL parse error

Article View: borland.public.delphi.database

Article #16

Back to borland.public.delphi.database Previous Next

#16

From: Johan
Date: Thu, 24 Jul 2003 07:49

40 lines
2733 bytes

Yes finally!!

Thank you very much for your big help Alfred!!

Greetings,

Johan Lijffijt
The Netherlands

"Alfred ten Hoeve" <Alfred.NoSpam@SimpelProg.nl> wrote in message
news:3f1fc46c$0$13797$4d4ebb8e@news.nl.uu.net...
> Give this a try
>
> 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;
>     IBTransaction1.Database := IBDatabase1;
>
> =>    IBSQL1.Database := IBDatabase1;
> =>    IBSQL1.Transaction := IBTransaction1;
>
>     IBDatabase1.Connected := True;
>     if not IBTransaction1.InTransaction then
> IBTransaction1.StartTransaction;
>
> =>    IBSQL1.SQL.Text := 'Create table Employee (naam char(20))'; //no :
>
>     IBSQL1.ExecQuery;
>     if IBTransaction1.InTransaction then IBTransaction1.Commit;
>     finally
>     IBDatabase1.Connected := False;
>   end;
>
>
> Alfred.
>
>

Technical Details

Message-ID: <3f1ff898$0$49105$e4fe514c@news.xs4all.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!213.51.129.3.MISMATCH!newshub1.home.nl!home.nl!news2.euro.net!transit.news.xs4all.nl!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> <3f1eec9a$0$49107$e4fe514c@news.xs4all.nl> <3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net> <3f1f66de$0$49106$e4fe514c@news.xs4all.nl> <3f1fc46c$0$13797$4d4ebb8e@news.nl.uu.net>

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: 10de66,7a329eac3d9933a8
X-Google-Attributes: gid10de66,public
X-Google-Thread: 115d96,7a329eac3d9933a8
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-07-24 08:17:46 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!213.51.129.3.MISMATCH!newshub1.home.nl!home.nl!news2.euro.net!transit.news.xs4all.nl!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> <3f1eec9a$0$49107$e4fe514c@news.xs4all.nl> <3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net> <3f1f66de$0$49106$e4fe514c@news.xs4all.nl> <3f1fc46c$0$13797$4d4ebb8e@news.nl.uu.net>
Subject: Re: SQL parse error
Date: Thu, 24 Jul 2003 09:49:44 +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: 42
Message-ID: <3f1ff898$0$49105$e4fe514c@news.xs4all.nl>
NNTP-Posting-Date: 24 Jul 2003 17:17:44 CEST
NNTP-Posting-Host: 213.84.249.41
X-Trace: 1059059864 news.xs4all.nl 49105 213.84.249.41:28318
X-Complaints-To: abuse@xs4all.nl

Reply to Parent Message