An application done in Delphi 4 using the good old BDE and Paradoxe tables. Data shared on apeer-to-peer network, four XP pro machines .
All machines are set for no cacheing and the 'sharing' property set to true in the BDE on all amchines. We use DBISaveChanges to force immediate updating.
However, occasionally and getting more often, the master-detail link between 2 tables fail and the detail 'stalls' on one record - the same record, but one of no particular siginficance ie not he first or last in the table.
Resetting the link (closing tables, re-applying the indexed fields, nmastersources etc) does not work. The application must be shut down and restarted for links to be reset.
No data is lost but it is a real problem.
I know the BDE is old hat now, but we need to fix this problem.Thanks in advance
All machines are set for no cacheing and the 'sharing' property set to true in the BDE on all amchines. We use DBISaveChanges to force immediate updating.
However, occasionally and getting more often, the master-detail link between 2 tables fail and the detail 'stalls' on one record - the same record, but one of no particular siginficance ie not he first or last in the table.
Resetting the link (closing tables, re-applying the indexed fields, nmastersources etc) does not work. The application must be shut down and restarted for links to be reset.
No data is lost but it is a real problem.
I know the BDE is old hat now, but we need to fix this problem.Thanks in advance