Re: SQL parse error

Article View: borland.public.delphi.database

Article #15

Back to borland.public.delphi.database Previous Next

#15

From: Alfred ten Hoeve
Date: Thu, 24 Jul 2003 11:31

27 lines
2474 bytes

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: <3f1fc46c$0$13797$4d4ebb8e@news.nl.uu.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!newshosting.com!news-xfer2.atl.newshosting.com!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> <3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net> <3f1f66de$0$49106$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: 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-24 04:35:15 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!newshosting.com!news-xfer2.atl.newshosting.com!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> <3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net> <3f1f66de$0$49106$e4fe514c@news.xs4all.nl>
Subject: Re: SQL parse error
Date: Thu, 24 Jul 2003 13:31:52 +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: 29
Message-ID: <3f1fc46c$0$13797$4d4ebb8e@news.nl.uu.net>
NNTP-Posting-Host: 1Cust27.tnt34.rtm1.nld.da.uu.net
X-Trace: 1059046509 news.nl.uu.net 13797 213.116.162.27
X-Complaints-To: abuse@nl.uu.net

Reply to Parent Message