I have a rather urgent issue.
I have a join in a customer Delphi server using IbDac.
The join works perfectly well in the schema modeler.
When opening the table on the client, everything is working perfectly also.
Problem is when I try to use a dynamicwhere on the table.
The join consists of 3 tables, each containing a field removed to indicate that the record is removed.
So I have query with the main table files that contains the required fields and the field removed. It also contains the fields needed from the 2 other tables with without the field removed.
When I try to use dynamicwhere on the field removed, it gives me ambigious field.
I’ve tried with an alias for the field but then the table gives me unknown field removed when trying to use dynamicwhere.