Joe Martinez wrote:

> I typed the following query into the DSQL tab of IB_SQL:
>
> select customerid from enrolls A where A.sectionid in (select B.sectionid
> from sections B where sectionstartdate >= '1/1/03' and sectionstartdate <=
> '1/1/04') and enrollwaiting <> 'T'
>
> I get an error back, saying "multiple rows in singleton select". I don't
> understand. I don't see a singleton select anywhere in that query.
>
> Anyone understand why I'm getting this error?

Because the DSQL tab only expects a single result. Try using the Cursor tab.
IBObjects questions are best directed to the IBObjects list
http://groups.yahoo.com/group/IBObjects

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services