Now I really feel stupid, not seeing the obvious

thanks for yor time and patience,

Daniel

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 11:22 AM 11/03/2007, you wrote:
> >Hi,
> >You are right the script scTireMan tries to execute twice!! but
how is
> >this possible with this code?What is wrong with my code?
> >start2 never gets executed
> >
> >with TireServer do
> > Showmessage('start');
> > if not FileExists('tireman.FDB') then
> > begin
> > Showmessage('start1');
> > scTireMan.Execute;
> > Showmessage('start2');
> > end;
> >
> >when is executes scTireMan goes back to start and tries to execute
the
> >script a 2nd time
> >
> >I'm really confused with this can someone help
>
> Yes, because I think your code is confused and your script is
> confused. (And your code sure confuses me!)
>
> In your BeforeConnect, you are doing this test:
>
> with TireServer do
> if not FileExists('tireman.FDB') then
> begin
> scTireMan.Execute;
>
> But your script is creating this database:
>
> CREATE DATABASE 'c:\TIRE-MAN-NEW\TireMan.FDB'
> USER 'SYSDBA'
> PASSWORD 'newgen'
> page_size = 4096;
>
> Why not change your FileExists call to look for the database file
in
> the place where your script would have created it?
>
> if not FileExists('c:\TIRE-MAN-NEW\TireMan.FDB') then
>
> Helen
>