It appears you're developing on an older version of Firebird, and most
likely, you've got a query that has an identical field name in more than one
table, but the table name is not explicitly specified in the query.

...gosh, what a horrible explanation...hang on, here's an example:

select int_digasset from tbl_digasset DAS
LEFT JOIN tlnk_altasset ALT
ON DAS.int_digasset = ALT.int_digasset

-- This query returns your error: "Ambiguous field name between table
TBL_DIGASSET and table TLNK_ALTASSET"

If you specifiy the table name on the field that's common to both tables,
you're ok!

select DAS.int_digasset from tbl_digasset DAS
LEFT JOIN tlnk_altasset ALT
ON DAS.int_digasset = ALT.int_digasset

You'll be ok!

Nige.

> -----Original Message-----
> From: Pablo [mailto:fuelsoft@...]
> Sent: Friday, 26 November 2004 3:53 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Problems installing my application (with
> firebird)
>
>
>
>
> I've installed firebird (Firebird-1.5.1.4481-Win32.exe)
> I've installed my application.
>
> In my test PC , gives me this error:
>
> Dynamic SQL Error
> SQL error code = -204
> Ambiguous field name between table CUSTOMER and table HUMANS IDHUMAN
>
> My customer table has a FK IDHUMAN, and my HUMAN table has
> IDHUMAN as PK.
> What is happening?
>
> (In my development PC it runs Ok!)
>
> --
> Saludos
> Lic. Pablo Zagni
> www.FuelSoftware.com.ar
> Buenos Aires, Argentina
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>