> I get the error message "Invalid CREATE, CONNECT or DROP Database
> syntax".

Is the script component linked to a TIB_Connection and if so, is it
connected?

>That's why I copied the SQL to IBExpert to try if it's working.
> And there I had this strange behaviour due of th semicolon in the SQL
> Statement.

Then try it in the script-execution thingy, not in the SQL Editor.

There should be no difference between InterBase and Firebird for this
particular
problem.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com

>
> > I try it also with T_IBScript from IBObjects... with the same result.
> It
> > worked well with Interbase.
>
> What result? You didn't tell us any. For now, I see no reason why
> the script-component from IBO shouldn't work.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
> SQL
> Server
> Upscene Productions
> http://www.upscene.com
>
> > > This is a real silly question...
> > >
> > > How can I execute more than one SQL...
> > >
> > > I try following:
> > >
> > > DROP VIEW V_NEWORDERHEADER;
> > > DROP VIEW V_NEWORDER;
> > >
> > > But IBExpert seems not to like the second drop command.
> >
> > So your actual question is "Script execution with IBExpert"? :-)
> >
> > Try it's "Script Executive" tool instead of its SQL Editor.
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>