Subject Re: [IBO] TIB_Script - Capacity - Limitations - etc
Author Geoff Worboys
> 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( ... )

> B) What is the capacity of an IB_Script.

How much memory do you have :-)

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.

> 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?

Geoff Worboys
Telesis Computing