I'm trying to empty a dataset which is a detail of a master table when the user selects a certain value in the master table this should delete all the records in the linked detail table.
To do this I've tried calling detailtable.EmptyTable but I get an error stating that I cannot do this with a read-only transaction active.
The table has its read and update transaction properties set to seperate read and write transactions. The write update transaction has not been set to readonly. I can insert and edit detail records without problem.
What have I misunderstood?
Peter