Subject Re: [firebird-support] FB 1.5 back compatibility
Author Helen Borrie
At 11:04 PM 6/03/2004 +0000, you wrote:
>today I
>- downloaded the FB 1.5 windows installer
>- read carefully the realese notes
>- removed the old FB 1.0 installation
>- installed the new version into an old W95 PC
>- run
>instclient i -f g
>Done that,
>1. I launch my beloved Interbase Windows SQL and click on
>"File"/"Connect to database"
>I can choose a remote database only (the "local engine" checkbox is
>Is there a way to connect to a local database using this tool ?
>2. I launch the old IB_SQL that came with IBO3 and this time I can
>open a local database.
>If I write "select * from any_table" I get the error message
>"multiple rows in singleton select"
>What's wrong ?

My guess is you are using the DSQL page of IB_SQL. You need to use the
Cursor page for multi-row selects.

btw, that version of IB_SQL is too old for Fb 1.5. You need to download
the latest one. (, click button at top right)