Hallo Martijn,

Even when I only paste the create table without the if statement it generates the same error. The problem is : I have to send a script to a customer to check if a table exists and in case not, it has to be created.

Any idea for a better command ?

Thanks, Nico

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, March 31, 2004 3:14 PM
Subject: Re: [firebird-support] SCRIPT ERROR


> Hi Nico,
>
> > I don't know what's wrong with this script, but it generates a "Invalid
> CREATE, CONNECT or DROP DATABASE syntax" :
> >
> > IF (SELECT RDB$RELATION_NAME
>
> "IF" isn't supported in script.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------------------------------------
> Tekst ingevoegd door Panda Client Shield:
>
> Als het hier gaat om een ongevraagde e-mail (SPAM), klik dan op de volgende link om de e-mail te herclasseren: http://127.0.0.1:6083/Panda?ID=pav_112&SPAM=true
> ---------------------------------------------------------------------------------------------------
>