Thanks Helen, I knew it would be simple.

I'm just surprised that I have not read before now how DSQL's are
for singleton selects (or DML's).
Or maybe I have and have just missed it or forgotten.
Not now though. This info is embedded in my head now!

Rgds,
-Ryan

> Yes, your problem is the choice of TIB_DSQL: it is not a dataset
> component, so it cannot accept more than a single row. It's

designed for

> EXECUTING stuff. Use an IB_Query if you want a scrollable

dataset, or

> IB_Cursor if you don't need scrolling.
>
> cheers,
> Helen