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

Hi ! Joe,

I think that IB_SQL are expecting a single row, is there others place
where you can type the query ? Maybe there is a special place where a
result set is expected.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.7 - Release Date: 01/03/2005