Thank you for your reply.

"mo" and "phones" both are table.

After prepare and describe, I found the sqltype of mo_id is 361, But
after looking ibase.h , I can't find any data type is 361 or 360.
Actually, ths mod_id should be SQL_LONG (integer).



--- In firebird-support@yahoogroups.com, Jason Dodson <jasond@...>
wrote:

>
> 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.

>