Page 1 of 1
Ambiguous field name between table...
Posted: Tue 09 Dec 2008 01:26
by eduardosic
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
Posted: Tue 09 Dec 2008 12:44
by Plash
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.
Posted: Tue 09 Dec 2008 12:48
by eduardosic
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?
Posted: Tue 09 Dec 2008 14:18
by eduardosic
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!
Posted: Wed 10 Dec 2008 08:18
by Plash
Yes, you should keep the DetailFields property empty.