Master Details , what is going on?

roberto · Post by **roberto** » Fri 21 Jul 2006 14:18

Hi,
I have been using you tools now for some time, and until this last update everything was going more or less ok, but I have update to today version and Hi,
I have been using you tools now for some time, and until this last update everything was going more or less ok, but I have update to today version and all my application are going bananas…
After having a close look at the problems I found out that all this error are coming from tables or queries that have master details assigned.
I have never used the detailsfields property if I change my code to do so, most of the bugs get fix, except on complex queries where the detailsfields has to have a reference to the table name (ie TableA.Idcustomer and not the generated by the property editor ‘Id.customer’) as I get the message “column ‘Idcustomer’ in the where clause is ambiguous”. (the same query works fine if I run it without assigned it to a master table) .
Another erratic error is that on tables with the same field names (Autoinc on master details) the identity field on the detail table get fill as soon as you do a insert with the identity of the master table when nothing shoud be done if the tables are only assigned when the masterfield is assigned and the detailsfields field is blank.
The parameter name is set correctly.

I have about 20 application on the market and I have not the time to rewrite all the code, more over, in some cases is impossible as the joint field are not in the result query in order to joint the to tables using the detailsfields property.
I would be grateful if you could revise you code as something is wrong, unfortually I do not own the code to be more helpful.

Mean time is it possible to get a old version of the components? If so from where?

Regards

Roberto

(hope my english is good enough!)

Antaeus · Post by **Antaeus** » Fri 21 Jul 2006 15:12

Please send us (evgeniyD*crlab*com) a complete small sample to demonstrate these problems including script to create and fill tables.

Antaeus · Post by **Antaeus** » Fri 21 Jul 2006 15:18

Also supply us following information
- Exact version of MyDAC you used before.
- Exact version of Delphi, C++ Builder or Kylix

roberto · Post by **roberto** » Fri 21 Jul 2006 15:41

Delphi 7
Mydac 4.30.1.17 07.07.06

As for a small demo, to busy at the momment....got lot of customer giving me the stick!.
I will send it as soon as posible.

please meantime give me a link to download old version of components
==============================================

thanks

roberto

roberto · Post by **roberto** » Fri 21 Jul 2006 16:43

Hi!

mail send with sample to 'evgeniyD*crlab*com'

Regards

Roberto

Antaeus · Post by **Antaeus** » Mon 24 Jul 2006 15:03

We have reproduced the problem with inserting value from master record set to wrong field of detail record set. The investigation of the problem is in progress. As soon as we solve the problem we'll let you know.
Please supply us with queries that cause the second problem (with ambiguous column name) and tables structures that are used in these queries. Possibly these problems are coupled.