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
>disabled).
>
>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"
>
>GULP
>
>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. (www.ibobjects.com, click button at top right)

Helen