Hi,

> When i connect my application to the interbase , my application works
> fine without any error message.Now i installed Firebird 1.0 and tried to
> connect the same application with the firebird 1.0, (same database) i am
> getting the error message.
>
> Sql error code - 204
> Ambiguous Fieldname Between Table USERACCESS and table
> SUBMENUITEMS MENUITEMINDEX
>
>
> What could be the problem and how to solve this problem?

As the error messages reads - your query is ambiguous. There's
a column in the resultset that has no table in front of it
(table[alias].column)
and both tables have a column named that way.

Firebird cannot determine what value (from table A or B) to output,
therefor returns an error.

How to solve? :: fix your query.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."