comesailing@... schrieb:

>
> Silly question.
> What is the best way (in a program using ib_connection) of finding
> whether a table exists and if so whether it is empty ?
> I do it by trying to read a record and if the table does not exist or
> is empty then of course there is an error. But this is clumsy, I
> would rather do a test of each.
> regards Dave.

The easisest should be:

TableExists :=
IB_Connection.SchemaCache.TableNames.IndexOf(RequiredTable) >= 0;

HTH

Luc.

>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/