llblgen 3.0 Release 3 December .Net framework 2.0 Oracle 9i/10g [MS Oracle] Windows App

Dear Support team,

I have very basic question.

Let us say I have a Table by name Invoice with Invoice Number and Value

Now users will update like tihs

UPDATE INVOICE SET VALUE=VALUE+ 100 WHERE INVOICENUMBER=1

Now my question is, since is multi user environment, if 5 users execute this statement at same time on different PC's how does LLBLGEN handle this ?

The question is how do you want to handle this?

Walaa wrote:

The question is how do you want to handle this?

USER1 WHEN IS IS 1000

UPDATE INVOICE SET 1000=1000+ 100 WHERE INVOICENUMBER=1

USER2 WHEN IS IS 1100 UPDATE INVOICE SET 1100=1100+ 100 WHERE INVOICENUMBER=1

But we need to remember that both users are executing the application at a time

shekar wrote:

Walaa wrote:

The question is how do you want to handle this?

USER1 WHEN value IS 1000

UPDATE INVOICE SET 1000=1000+ 100 WHERE INVOICENUMBER=1

USER2 WHEN value IS 1100 [but user1 may not have committed yet] UPDATE INVOICE SET 1100=1100+ 100 WHERE INVOICENUMBER=1

But we need to remember that both users are executing the application at a time

Please check Expressions in entity updates

Walaa wrote:

Please check Expressions in entity updates

Got it. Thanks