IBOBjects and Queries with duplicate fieldnames
Hello,
I was using ADO with Fast-Reports and I had a report with 2 group headers. The condition for the headers was a field called "docketid". There are fields from two tables, which I have used a join on and thus there is :
datamodule.query."workingdocket.docketid" AND
datamodule.query."disbursements.docketid"
one changing made the first group flip, the other the second. Here's the problem - with IBObjects the query no long has the tablename.docketid it only has 2 fields named docketid. And since theres no way to distinguish them, one of the group headers doesn't work.
IS there a way to make explicit refrence? I am using IB_Query components, and I have checked - the query contains the full name, but fastreport gives an error when I reference tablename.docketid.
Please help.
Jason S. Gagnon
I was using ADO with Fast-Reports and I had a report with 2 group headers. The condition for the headers was a field called "docketid". There are fields from two tables, which I have used a join on and thus there is :
datamodule.query."workingdocket.docketid" AND
datamodule.query."disbursements.docketid"
one changing made the first group flip, the other the second. Here's the problem - with IBObjects the query no long has the tablename.docketid it only has 2 fields named docketid. And since theres no way to distinguish them, one of the group headers doesn't work.
IS there a way to make explicit refrence? I am using IB_Query components, and I have checked - the query contains the full name, but fastreport gives an error when I reference tablename.docketid.
Please help.
Jason S. Gagnon
Comments
regards