Master Details , what is going on?
Posted: 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!)
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!)