Does $insert() etc not work in Postgres? It's WORKING now.
IT
it at plastipol.com
Mon Jan 22 13:20:24 EST 2018
Hi Das
SELECT … FOR UPDATE locks records in transaction mode, otherwise only selects the record
So you need to do something like this:
Do $cinst.$sessionobject.$transactionmode.$assign(kSessionTranManual)
Do $cinst.$sessionobject.$begin() Returns #F
select … for update
enter data
if flag true
update ...
Do $cinst.$sessionobject.$commit
Do $cinst.$sessionobject.$transactionmode.$assign(kSessionTranAutomatic)
else
Do $cinst.$sessionobject.$rollback
Do $cinst.$sessionobject.$transactionmode.$assign(kSessionTranAutomatic)
end if
> El 22/1/2018, a las 4:30, Das Goravani <das at goravani.com> escribió:
>
> I would like to read the use of that command, $definefromSQLclass… if you can post it for me, just one line of code, i need to see what precedes it, how it’s used, syntax, example basically. Similarly for the one called $prepareforupdate as i assume that locks records since it issues a SELECT .. FOR UPDATE command which I was told locks records
More information about the omnisdev-en
mailing list