--- In IBObjects@y..., "Geoff Worboys" <geoff@t...> wrote:

> > I have a couple of quickies concerning this wonderful item.
> >
> > A) Can I feed a TIB_Script with a file
> >
> > as in IB_Script1.loadfromfile('filename'); or similar.
>
> SQL is a TStrings property. As such you can load-from/save-to file
> using that property.
>
> IB_Script1.SQL.LoadFromFile( ... )

Thank you - I'll try this

>
>
> > B) What is the capacity of an IB_Script.
>
> How much memory do you have :-)

128MB

>
> I've run scripts over 3Mb (more than 80000 lines) without a problem.
> Where you can run into system limitations and performance issues is

if

> you log results into a memo control.

No - I'm not logging results

>
>
> > I've got large numbers of scripts and I'd like to reduce
> > the number a little. On the other hand I've found that I
> > cannot load 3000 rows into an IB_Script hence the queries.
>
> Cannot? How are you trying to load it?

1) Place TIB_Script on a Form
2) Double click TIB_Script
3) "Load" a file (97K)

This fails with "Too many lines for memo" error.

I'll experiment with "Load from file" and see what happens.

Thanks

>
>
> Geoff Worboys
> Telesis Computing

John