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@...]
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