Cached Updates requeries Detail when updating single fields in Master

Jakob Hammer-Jakobsen

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

I have just updated a Delphi3-program (MSSQL6.5) to Delphi5 Ent.
It seems like there is a change on how the SQL-Links/BDE handles
Master-Details.
I do have a master-record with several detail-records. Normally I can change
the fields in
the master-record, without the requirying the details (theres is absolutely
no need for this) when changing.
In Delphi 5 the FIRST change of the master-record requiries the
child-records, thus causing unnessesary
net-traffic and confusing the users. (They cant update the details before
the master in Delphi 5, without committing
in-between.)
Does any know how to avoid this new requiry-feature/failure??

Best regards, Jakob Hammer-Jakobsen

Jakob Hammer-Jakobse

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

I have just updated a Delphi3-program (MSSQL6.5) to Delphi5 Ent.
It seems like there is a change on how the SQL-Links/BDE handles
Master-Details.
I do have a master-record with several detail-records. Normally I can change
the fields in
the master-record, without the requirying the details (theres is absolutely
no need for this) when changing.
In Delphi 5 the FIRST change of the master-record requiries the
child-records, thus causing unnessesary
net-traffic and confusing the users. (They cant update the details before
the master in Delphi 5, without committing
in-between.)
Does any know how to avoid this new requiry-feature/failure??

Best regards, Jakob Hammer-Jakobsen

John Pierc

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

If all the child tables use the same Datasource to link to the master,
set the Datasource.Dataset := nil before you change the master, and
reset afterwards.

John

Other Threads

1. Master detail detail, cached updates, and insert/delete

2. cached updates and master/detail queries

3. Detail table key field updates on a Master/Detail relation

4. Speed problems with updating new value to Query detail dataset (cached updates)

5. Detail table in Master/Detail not updating automatically

6. Deleting from Master/Detail using cached updates

7. Confirmed D2 bug: cached updates don't work for master/detail - here's why

8. Master / Detail Relationships with cached updates in Delphi 2.0

9. Cached Updates with Master/Detail?

10. Another possible solution for cache update ( master detail )