Page 1 of 1

RLock() and transaction

Posted: Thu Jul 31, 2014 4:07 am
by Piotr D
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

Re: RLock() and transaction

Posted: Fri Aug 01, 2014 3:04 am
by Piotr D
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