On Mon, 5 Oct 2009, Felipe Monteiro de Carvalho wrote:
Hello, I am having a dilema with a dataset based app. I have 2 dataset objects pointing to the same database file, one connected with data-aware controls to allow the user to change the data and the other one only for reading. I need 2 because I need to show data based on the database while modifying it, and I can't iterate between items using the write dataset because that would disturb the user editing. The problem now is that the write doesn't go immediately to disk, so when modifications are done this doesn't modify the displaying of data which is based on the read dataset. Is it possible to have 2 dataset objects sharing the same memory database? Or else any ideas of how to solve this problem other then constantly writing changes to the disk and reloading the read dataset?
It's not possible with SQL databases. You can to it with objects, object persistence and mediators for data in-memory to the application (at least, I do :-) ). If there are 2 apps then there is no way I know of to do what you ask. Michael. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
