I would like to take an offline view and use it to populate tables on a notebook, edit add and delete records in these tables, create another offline view from them, take the new view back to the desktop and update the original tables.
The difficulty I am having is in using SETFLDSTATE on the offline view. The view will only update a table where the view has been modified. When a view is made offline, GETNEXTMODIFIED returns 0. Running SETFLDSTATE on each record for each field and changing the flags from 1 to 2 returns .T. and GETFLDSTATE shows that the changes have been made; but the changes cannot be saved. So when the view is USEd in ONLINE EXCL mode in preparation for updating the source tables, the changes are lost and the source tables are not updated.
Does anyone know of a way around this problem, please?
I do not want to edit the offline view directly on the notebook, it is important that I should be able to update tables and transfer views as described above.
Many thanks.