🚀 go-pugleaf

thx,

I have added this line as you suggested after the line "IBSQL1.Database :=
IBDatabase1" but still i get the message

SQL Parse error: parameter name expected when i execute execquery



"Alfred ten Hoeve" <Alfred.NoSpam@SimpelProg.nl> wrote in message
news:3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net...
> 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
> > >
> > >
> >
> >
>
>