[fpc-pascal] Dataset modification and reading at the same time

[Michael Van Canneyt]

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.