Constraint Problem
Posted: Mon 23 Jun 2008 09:04
im facing problem in master(MT)/detail(DT) tables:
journal (MT) --> journaldt (on journal_id)-----------------> cstjour (on journaldt_id).
im using the ApplyUpdate method cause there is constraint on tables.
but when filling journaldt and then cstjour, and try to insert another row in journaldt, the previous rows in cstjour are missed.
this is how i used the applyupdates:
after post journal table:
Try
journaldt.ApplyUpdates;
Cstjour.ApplyUpdates;
Database.commit;
Except
journaldt.RestoreUpdates;
Cstjour.RestoreUpdates;
Database.Rollback;
end;
journaldt.CommitUpdates;
Cstjour.CommitUpdates;
can u help please?
journal (MT) --> journaldt (on journal_id)-----------------> cstjour (on journaldt_id).
im using the ApplyUpdate method cause there is constraint on tables.
but when filling journaldt and then cstjour, and try to insert another row in journaldt, the previous rows in cstjour are missed.
this is how i used the applyupdates:
after post journal table:
Try
journaldt.ApplyUpdates;
Cstjour.ApplyUpdates;
Database.commit;
Except
journaldt.RestoreUpdates;
Cstjour.RestoreUpdates;
Database.Rollback;
end;
journaldt.CommitUpdates;
Cstjour.CommitUpdates;
can u help please?