Locking only in trans mode, thanks to IT & Bastiaan, Identifying Integers

[Bastiaan Olij]

Hey Das,

The table classes are just construct that make a lot of common tasks
around tables easier. You can avoid using them by writing queries
yourself but I would ask "you re-invent the wheel"? I really recommend
you give them a chance, they really make your life easier.

Truth be told, I have re-invented the wheel myself but not because I
don't want to use table classes. I use table classes all throughout my
application and using Omnis' OO capabilty have added a lot of
enhancements on top of Omnis' build in logic.

But lately I have started to use JSON a lot to communicate to the
database. Given our invoice example I have a stored function that
returns the entire invoice, details and all, as a JSON body. I also have
a stored function that takes this JSON, validates if the invoice is
complete, and then applies the needed tables. That however is a subject
for another day :)

Cheers,

Bas

On 23/1/18 7:45 am, Das Goravani wrote:
> Well this is a hoop to jump through but if that’s the way it is then that’s what I’ll do.  I do understand what youre saying and doing here, this way, matches what I was thinking in terms of when to issue commands, the Select..For Update Before you enter data to lock the record
>
> So when there’s a CANCEL to the enter data…nothing has been sent to the server, so there’s nothing to rollback, correct ?  And how do the locks get cancelled on a Cancel to enter data.. by undoing the Transaction mode command? 
>
> Thank you IT for your very helpful answer. Thanks to Bastiaan for his as well. 
>
> Bastiaan, you mentioned something regarding Table Classes.  I was thinking up til now, and still, that I can avoid using them… the manuals say you really only need to use them to override the standard methods they have inside them, which I dont need to do at this point, that I’m aware of, or do you just need to use for various reasons when you’re serious about all this stuff?  I want to get off on the correct footing.. I thought I could skip table classes but that sometimes I would need query classes when doing two tables at once into a list…  
>
> There’s another thing.. in order to lock 2 records say, customer and invoice, that come from two different tables, I’m thinking I have to select each with a Prepare for Update (Select..For Update) commands… i hope it doesn’t tell me I cannot issue a second one.. I dont know how to select two records from two tables with one select command… i have unique fields with a simple integar in them for identity… my way is to have a table that is only for "Giving out numbers", it keeps track on the number, increments itself when one is taken out, and saves, just a very small definition, just 3 fields, mainly 2, the third is name of table it serves, 4 records for 4 types of number needs, customers, invoices, products, and representatives, so far… in future more parent type files will require making a record for number check out for them… these number check out records are the most accessed records in the database… a very quick lock and number grab during saving of a main record.  I dont know of any other way to do it without risking duplicates, and being impervious to export import… mine is impervious… just check in startup construct for the records to be holding one digit higher than highest record holds.. easy.. to ensure correct dispensation. 
>
> I think it’s great that there is this email list, I think that the knowers who answer are very magnanimous, kind.  I hope to be an answer giver myself someday.  I’m magnanimous too, by nature. 
>
>
>
>> On Jan 22, 2018, at 10:20 AM, IT <it at plastipol.com> wrote:
>>
>> 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
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> Das Goravani
> das at goravani.com
> http://www.Goravani.com <http://www.youtube.com/profile?user=RichardEdwardWurst>
>  <http://www.youtube.com/RichardEdwardWurst>http://www.YouTube.com <http://www.youtube.com/>/RichardEdwardWurst
> http://www.YouTube.com/DasGoravani <http://www.youtube.com/DasGoravani>
> http://YouTube.com/JyotishStudio <http://youtube.com/JyotishStudio>
>
>
>
>
>
>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com


-- 
Kindest Regards,

Bastiaan Olij
e-mail: bastiaan at basenlily.me
web: http://www.basenlily.me
Skype: Mux213
http://www.linkedin.com/in/bastiaanolij