Re: SQL parse error

Article View: borland.public.delphi.database

Article #13

Back to borland.public.delphi.database Previous Next

#13

From: Alfred ten Hoeve
Date: Wed, 23 Jul 2003 22:53

61 lines
3044 bytes

IBSQL1.Transaction := IBTransaction1
should be added.

Begin .. end is not functional when you start or commit the transaction. But
it doesn't harm either.

Alfred.


"Johan" <lijffijt@xs4all.nl> schreef in bericht
news:3f1eec9a$0$49107$e4fe514c@news.xs4all.nl...
> 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: <3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsinpeer00.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!news.nl.uu.net!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>

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: 10de66,7a329eac3d9933a8
X-Google-Attributes: gid10de66,public
X-Google-Thread: f6386,7a329eac3d9933a8
X-Google-Attributes: gidf6386,public
X-Google-Thread: 115d96,7a329eac3d9933a8
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-07-23 16:12:03 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsinpeer00.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!news.nl.uu.net!not-for-mail
From: "Alfred ten Hoeve" <Alfred.NoSpam@SimpelProg.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>
Subject: Re: SQL parse error
Date: Thu, 24 Jul 2003 00:53:00 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Lines: 63
Message-ID: <3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net>
NNTP-Posting-Host: 1Cust45.tnt38.rtm1.nld.da.uu.net
X-Trace: 1059001844 news.nl.uu.net 8304 213.116.170.45
X-Complaints-To: abuse@nl.uu.net

Reply to Parent Message