Board index » delphi » Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

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

 

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

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