I have done that with some comments in the script that my program can
understand but I don't understand why the TIB_script object can work
just like the ISQL window in IBCONSOLE and just run the script
properly.

--- In IBObjects@yahoogroups.com, "Enrico Raviglione"
<e.raviglione@i...> wrote:

> For make the same operation with a TIB_Script i have slipt my

script in

> some different sessions.
> Any of this session have an identifier and a numeric version number

and

> are executed as a single script.
> Then i make the connection, read a session of my script and run it,

then

> i disconnect to my DB and re-do all the job for the next session.
>
> Regards,
> Enrico Raviglione.
>
> -----Messaggio originale-----
> Da: Matt Nielsen [mailto:mnielsen@c...]
> Inviato: martedì 13 aprile 2004 20.29
> A: 'IBObjects@yahoogroups.com'
> Oggetto: Re: [IBO] Update Script
>
>
> Yes I did add it during the same session. This is not an issue

with

> IBConsole. Why is is a problem with TIB_Script. This places

serious

> limitations on my scripts.
>
> Thanks for the response.
> --- In IBObjects@yahoogroups.com, Lucas Franzen <luc@r...> wrote:
> >
> >
> > Matt Nielsen schrieb:
> > > Hello all. I have a poblem with the TIB_Script component. I
> send
> > > out updates to my database and have a utility that the user
> executes
> > > to update the database.
> > >
> > > Basically it just loads a physical file (update100.sql) into the
> SQL
> > > of the Script component and executes it using Script.Execute.
> > > However, I have found that the script is not being executed

the

> same
> > > as it is in IBConsole. Sometimes lines like:
> > >
> > > UPDATE APCREDIT SET DATATYPEID = 1, OVERRIDE = 1; give a string
> > > conversion error and lines like:
> > >
> > > UPDATE APCREDIT SET DATATYPEID = 1, OVERRIDE = 1 WHERE

DATATYPEID

> IS
> > > NULL; don't even execute at all.
> > >
> > > What is strange is that if I run this exact script in IBConsole
> on
> > > the same database everything works exactly the way it should.
> > >
> > > I've tried everything I can think of and it fails everytime.
> > >
> > > Any ideas?
> >
> > Did you just add the fields APCREDIT / OVERRIDE to your table
> within the
> > same session of IBO?
> >
> > If so, you have to disconnect and reconnect to the database before
> > trying to update new created fields.
> >
> > Luc.
>
>
>
>
>

______________________________________________________________________
__

> ___
> 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 !
>
> Yahoo! Groups Links