> > If I insert data from one, I can't see inserted data from other before I
> close database connection from first one and the renew connection from
> second one.
>
> When you close a connection the transaction is closed. And when you
> reconnect, a new transaction is created.
> Hard commit both transactions and you should see those changes.

Commiting transactions did, what I want, but I have one additional question.
Is it normal, that transaction->commit closes all opened datasets/queries ?
Is there neccessary to start a new transaction each time we commit one ?


And to my example: without transaction I was doing following:
APP1 (application, where user enters data):
- dataset->open
- DataSet->Append
- define data
- Dataset->post
- dataset->close

APP2 (here can another user review data)
- prepare sql statement
- dataset open (on start of application)

I didn't see new inserted data in app2, after close/open dataset, so I did
following:
APP1 (application, where user enters data):
- dataset->open
- DataSet->Append
- define data
- Dataset->post
- dataset->close
- transaction->commit
- transaction->start


APP2 (here can another user review data)
- transaction->commit
- transaction->start
- prepare sql statement
- dataset open (on start of application)

Is this right approach or wrong ?

Any help would be apprechiated.

Regards,
Primoz