I'm not sure this has anything to do with your query directly. Are any of these tables actually views/stored procedures?

Jason

tailuo2002 wrote:

> Hi,
>
> I'm working on a linux box running FB 1.5.2 , I'm using C language.
>
> The SQL is:
>
> char *sql="select a.phone,a.smscontent,a.mo_id
> from mo a inner join phones b on (a.phone=b.phone)
> where b.corp_id=? ";
>
> When app running, prepare is ok , but at isc_dsql_execute2, it reports:
> --> multiple rows in singleton select <--
>
> The sql is so simple , why it reports "multiple rows in singleton
> select"?
>
> I want to know if it is caused by wrong XSQLDA ?
>
>
>
>
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.