Transaction Mode Code

das.

I suspect the data is being saved. You just can’t see it from other applications because it is inside a transaction.. anything in a transaction is only visible within the transaction.

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug@artsman.com
www.artsman.com
Phone (403) 650-1978

see you at the third annual users conference
tickets.proctors.org/TheatreManager/95/online?performance=29086 <tickets.proctors.org/TheatreManager/95/online?performance=29086>

> On Feb 28, 2018, at 9:00 PM, Das Goravani <das@goravani.com> wrote:
>
>
> These commands are what I thought should surround a large block of inserts and updates
>
> Do isessobj.$transactionmode.$assign(kSessionTranManual) Returns #F
> Do isessobj.$begin() Returns #F
>
> Do isessobj.$commit Returns lflag
> Do isessobj.$transactionmode.$assign(kSessionTranAutomatic) Returns lflag
>
> They have the effect of stopping all saving of data in-between them at this point.
>
> I thought this was the way to get a few things…access to rollback and record locking if I
>
> SELECT…FOR UPDATE in-between them.
>
> Am I wrong somewhere?
>
> If I comment them out, the data is saved just fine.
>
> Thank you
>
> Das Goravani
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com