Yves,
There have been significant chnages between FB 1.0x and 1.5 which mean that
ambiguous querys are not supported. Most SQL compliant DBs do not allow
ambiguous queries. Do not blame progress for the failure of the application
to supply correct SQL.
Try using IBExpert as this is very good and also free.
Rich P...

-----Original Message-----
From: Yves Glodt [mailto:yg@...]
Sent: 30 October 2003 10:58
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Can not browse indexes from IBConsole

> Yves,
>
>> I have 2 little problems:
>> (using FB1.03 on Red Hat 9)
>>
>> When I wanna browse the indexes of a db from this machine using
>> IBConsole from my win2k laptop (which has a full FB1.5-rc6 installed)
>> I get this error message:
>>
>> Dynamic SQL Error
>> SQL error code = -204
>> Ambiguous field name between table RDB$INDICES and table
> RDB$INDEX_SEGMENTS
>> RDB$INDEX_NAME
>
> IBConsole doesn't support Firebird.

I've had this working, but it suddently stopped. And I can perfectly browse
the indexes of dbs that are located on my FB1.02 server.
I guess I have a problem in the db itself...

> Get yourself another tool.

Is this the right way to convince people that they should buy
a product...? ;-)

> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird & MS SQL
> Server. Upscene Productions
> http://www.upscene.com
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/