if you've extracted via IBExpert, it may have IBExpert only commands e/g set
description...
it will not run in another script component without error
Alan

> -----Original Message-----
> From: guido.klapperich@... [mailto:guido.klapperich@...]
> Sent: Wednesday, 9 October 2002 8:20
> To: IBObjects
> Subject: [IBO] Problems with a long script
>
>
> I'm using IBExpert for the metadata-extract of my DB. Such a script has
> about 11.000 lines and when I use IBExpert to execute this script, it
> takes about 1 minute. When I use IBAccess for executing the script, it
> takes a minute as well. Now I run the script with IB_SQL and it takes 10
> seconds and the script completed without exceptions. Now I want to
> commit the transaction, again it takes 10 seconds and then I get the
> error: connection lost to database. Then I have no chance to commit
> anymore and in the result all I get is a empty DB without any tables.
> The same, when I use the TIP_Script-Component within a app. The script
> executes without any exceptions and then the connection gets lost while
> commiting.
> I have done some test with smaller scripts and then I have no problems
> with executing a script with IB_SQL only with my long script.
> Any ideas ?
>
>
> Guido
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>