IBO's script parser is much more solid that IBX's so that's a good start. I
also have features which should make it more easy to customize your
behavior. I have a set ignoreerror (spelling?) that allows you to have the
script ignore exceptions on statements so the process isn't interrupted. You
can also tap into the existing SET <token>=<value> parsing to customize
things. This should make the parsing faster if you are allowing IBO to use
its native parsing.

IB_Script.pas is pretty friendly code so feel free to have a look in there
for more information.

HTH,
Jason Wharton
www.ibobjects.com

----- Original Message -----
From: "Lee Jenkins" <lee@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, November 21, 2003 2:25 PM
Subject: [IBO] Using IBOScrpt to update databases remotely?


>
> Hey all,
>
> I've been using IBX to update remote database when updates are required.
> I don't know if its me or the component, but sometimes the update
> process just flakes out and we end up having to roll back everything and
> the update can't happend until we remote in and fix everything manually.
> Its a real pain.
>
> So, I'm thinking of taking a whack at it with IBOScript to see if I have
> any better luck.
>
> We have a field in the database that is a numeric which indicates the
> database's current version such as 6.6. The software downloads a script
> from us that is modified with header info so that the software can parse
> through. For instance:
>
> #5.5%
> // Statements
> #5.6%
> // Statements
> #5.7%
> // Statements
> #5.8%
> // Statements
>
> The software loops through and tests when it comes to a "#", parses the
> line to see if the numeric value is greater than the current database
> version. If it is, then we read in everything past that, updating an
> internal variable as lines with "#" are encountered. Finally, we run
> the script and if everything goes ok, we update the current dataabase
> version with the internal variable that was tracking the "#" lines with
> the version.
>
> Anyone done anything like this?
>
> We have over 500 customers and it important that as updates to the
> software are made that require metadata changes, we can successfully
> update the database so that the operation does not require user invention.
>
> Any tips, advise, suggestions are appreciated.
> --
>
> Warm Regards,
>
> Lee
>