Moving an DBF-based program to PostgreSQL, is a good idea using transaction. But in existing source code
I use Rlock(). My questions are:
- if Rlock() with PgDbe make simple transaction?
- is possible "group" more updates (with RLock()) with BEGIN TRANSACTION... END TRANSACTION or is here
an conflict
For me is very important to have only one source code for DBF and SQL.
Piotr
RLock() and transaction
Re: RLock() and transaction
Hi,
how can I made transaction when programming in "ISAM Style"? I test:
BEGIN TRANSACTION
IF RLOCK()
REPLACE ...
Unlock
ENDIF
END TRANSACTION
and
oSession:beginTransaction()
IF Rlock()
REPLACE ...
UNLOCK
ENDIF
oSession:commitTransaction() <-- return .F.
and no effects. Any idea?
Piotr
how can I made transaction when programming in "ISAM Style"? I test:
BEGIN TRANSACTION
IF RLOCK()
REPLACE ...
Unlock
ENDIF
END TRANSACTION
and
oSession:beginTransaction()
IF Rlock()
REPLACE ...
UNLOCK
ENDIF
oSession:commitTransaction() <-- return .F.
and no effects. Any idea?
Piotr