OraFAQ Forum: Forms » how to add previous value in current record if their ID is same

Home » Developer & Programmer » Forms » how to add previous value in current record if their ID is same

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to add previous value in current record if their ID is same [message #633320]

Mon, 16 February 2015 00:13

saraa
Messages: 14
Registered: February 2015

Junior Member

i have a tabular form i select item_id through lov and also have quantity field i save 1 in it. now i want if i again select the same id then it vl make it 2 in quantity field. mean it vl add previous quantity if the item_id is same

Report message to a moderator

Re: how to add previous value in current record if their ID is same [message #633323 is a reply to message #633320]

Mon, 16 February 2015 00:20

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

POST changes to the database. When selecting ID value, check whether the same ID already exists and add 1 to previously stored quantity value.

Report message to a moderator

Re: how to add previous value in current record if their ID is same [message #633325 is a reply to message #633323]

Mon, 16 February 2015 00:30

saraa
Messages: 14
Registered: February 2015

Junior Member

i want to do it at form level .behind validate item trigger of quantity field what will be the code. plz??

Report message to a moderator

Re: how to add previous value in current record if their ID is same [message #633343 is a reply to message #633325]

Mon, 16 February 2015 07:35

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's what I meant - post changes you made in your form to the database. POST command works well in Forms.

As of code you need to write, I'm afraid you'll have to do that part yourself. If you can't make it work, please, come back here and post what you did. Someone will assist.

Report message to a moderator

Previous Topic:	Data saving
Next Topic:	Implementing a Cancel Button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 11:01:54 CST 2025