Ambiguous field name between table...

eduardosic · Post by **eduardosic** » Tue 09 Dec 2008 01:26

Hi DevArt!!

I found a problem in UniDAC Master-Detail relation ship.

the project to reproduce the problem can be downloaded in http://www.drdsistemas.com.br/UniDac.7z

information

Unidac 2.00 or 1.20 Last Build, some problem.
FireBird 2.0
Delphi 7 Enterprise

Best regard's

Plash · Post by **Plash** » Tue 09 Dec 2008 12:44

You should not set the MasterFields and DetailFields properties. If you assign CODPRO to these properties, this field name is automatically added to the SQL. In your case this is not allowed because field with such name exits in two tables.

eduardosic · Post by **eduardosic** » Tue 09 Dec 2008 12:48

Plash wrote:You should not set the MasterFields and DetailFields properties. If you assign CODPRO to these properties, this field name is automatically added to the SQL. In your case this is not allowed because field with such name exits in two tables.

Ok, i can keep property DetailFilds empty in this case?

eduardosic · Post by **eduardosic** » Tue 09 Dec 2008 14:18

eduardosic wrote:
Plash wrote:You should not set the MasterFields and DetailFields properties. If you assign CODPRO to these properties, this field name is automatically added to the SQL. In your case this is not allowed because field with such name exits in two tables.
Ok, i can keep property DetailFilds empty in this case?

Ok Plash, using DetailFields unidac add field used in where ..

thank's for Fast Support!

Plash · Post by **Plash** » Wed 10 Dec 2008 08:18

Yes, you should keep the DetailFields property empty.