Use the Cursor tab or Query Forms.
TIB_DSQL isn't intended for result sets greater than a single record.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "jmartine3" <joe@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 03, 2002 11:33 AM
Subject: [IBO] IB_SQL: Multiple rows in singleton select


> Hi. I'm brand new to this group. I'm just getting started with IBO.
>
> I just downloaded IB_SQL, because my plan is to use it as a front end
> to Firebird 1.0.
>
> I just installed FB1, and am able to connect to my database through
> my
> BDE app. I then started IB_SQL and tried to do a query against my
> database. I connected via the Connection tab, which was successful.
> I then went to the DSQL tab and entered the following simple query:
>
> select * from cities
>
> When I tried to execute it, I got the following error:
>
> ISC ERROR CODE:335544652
>
> ISC ERROR MESSAGE:
> multiple rows in singleton select
>
> STATEMENT:
> TIB_DSQL: "<TApplication>.frmSQL.dsqlEdit."
>
> This is a simple 2-column table, one of which is the primary key. My
> database is dialect 1 if that makes any difference.
>
> Does anyone know what's wrong?
>
> Thanks,
> Joe