Dear Support

I just need a hint to achieve the following with llblgen I have a table called monthlybill whose structure is as follows

TABLE : MONTHLYBILL

MONTHLYBILL_ID MONTH MEMBER_ID AMOUNT 1 SEPTEMBER 2010 1 0 2 OCTOBER 2010 1 0

EMPTY TABLE : MONTHLYBILLDETAIL

MONTHLYDETAIL_ID[SEQUENCE] MONTHLYBILL_ID[FK] LEDGER_ID MEMBER_ID AMOUNT

Now mutliple user action AT A TIME will be as follows

USER1

UPDATE MONTHLYBILL SET AMOUNT=AMOUNT+100 WHERE MONTHLYBILL_ID=1 INSERT INTO MONTHLYBILLDETAIL LEDGER_ID=1 MEMBER_ID=1 AMOUNT=100

USER2 UPDATE MONTHLYBILL SET AMOUNT=AMOUNT+500 WHERE MONTHLYBILL_ID=1 INSERT INTO MONTHLYBILLDETAIL LEDGER_ID=1 MEMBER_ID=1 AMOUNT=100 [ THIS SHOULD INFACT UPDATE SINCE LEDGER_ID=1 IS INSERTED BY FIRST USER]

INSERT INTO MONTHLYBILLDETAIL LEDGER_ID=2 MEMBER_ID=1 AMOUNT=250

I see, but I don't understand what is the problem. I mean, Are you looking for concurrency control? Or Are you looking for a way the second action checks if it need to do an update or an insert?

daelmo wrote:

I see, but I don't understand what is the problem. I mean, Are you looking for concurrency control? Or Are you looking for a way the second action checks if it need to do an update or an insert?

Daelmo, you got it right. looking for a way the second action checks if it need to do an update or an insert. Because both user 1 and user2 will use the application on different PC's at a time and it is winform application

This is a business case and should be handled in your code (Business Logic Layer). There you should check for a matching record before inserting, and if found update it with the required values and save it.

Walaa wrote:

This is a business case and should be handled in your code (Business Logic Layer). There you should check for a matching record before inserting, and if found update it with the required values and save it.

Thanks Walaa if it is part business case, I will manage it