OraFAQ Forum: Forms » how we can sum data with out commit command in forms

Home » Developer & Programmer » Forms » how we can sum data with out commit command in forms

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

how we can sum data with out commit command in forms [message #493509]

Tue, 08 February 2011 08:58

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

how we can sum data with out commit command in forms

regards

faheem

Report message to a moderator

Re: how we can sum data with out commit command in forms [message #493512 is a reply to message #493509]

Tue, 08 February 2011 09:13

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Loop over the records in the datablock and sum them manually?
You need to give more details - what are you summing?
Where is the result supposed to?

Report message to a moderator

Re: how we can sum data with out commit command in forms [message #493626 is a reply to message #493512]

Wed, 09 February 2011 02:44

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

dear for example a product name xyz in first row have qty 12 and second row product abc have qty 10
and third row product name xyz 10 when we use loop it work very well but if i change qty but not use return key and use mouse to save then stock may gone in to negative i want that like group by command when going to save prior to commit command

Report message to a moderator

Re: how we can sum data with out commit command in forms [message #493632 is a reply to message #493626]

Wed, 09 February 2011 02:59

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

Senior Member
Account Moderator

How about

- POST
- calculate
- if calculation OK then commit
  else raise

Report message to a moderator

Previous Topic:	Hierarchical Tree
Next Topic:	READ_IMAGE_FILE issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 16:22:07 CDT 2024