OraFAQ Forum: Forms » loop in data block

Home » Developer & Programmer » Forms » loop in data block

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

loop in data block [message #227776]

Thu, 29 March 2007 06:56

seddik_saber
Messages: 6
Registered: March 2007
Location: Tunisia

Junior Member

i search how to loop into a datablock for making a sum of a column?
please help me

PS:i'm a new user of oracle forms developping tool

Report message to a moderator

Re: loop in data block [message #227821 is a reply to message #227776]

Thu, 29 March 2007 09:08

seddik_saber
Messages: 6
Registered: March 2007
Location: Tunisia

Junior Member

i have using this

	go_block('BLOK1');
	first_record;
	loop
		If :system.last_record = 'TRUE' then
			Exit;
		Else
			Next_record; 
		End If;
	end loop;

but the probleme is that is the controle before the execution loose the focus any solution

Report message to a moderator

Re: loop in data block [message #227860 is a reply to message #227776]

Thu, 29 March 2007 19:14

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Which version of Forms are you using? If you are using 6i or higher, consider using the 'calculation' properties of an item.

Have a look at http://www.orafaq.com/forum/m/222451/67467/?srch=calculation#msg_222451

David

Report message to a moderator

Re: loop in data block [message #228338 is a reply to message #227776]

Mon, 02 April 2007 10:48

seddik_saber
Messages: 6
Registered: March 2007
Location: Tunisia

Junior Member

i'm using forms 6.0.
please explain more the calculation properties

Report message to a moderator

Re: loop in data block [message #228339 is a reply to message #227776]

Mon, 02 April 2007 10:58

seddik_saber
Messages: 6
Registered: March 2007
Location: Tunisia

Junior Member

ok i have find how to use the calculation mode.
but if i have a more complicated function other a sum how you fix it.
thanks for all

Report message to a moderator

Re: loop in data block [message #228417 is a reply to message #228339]

Tue, 03 April 2007 00:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Consider using the Post-Query trigger but remember that it fires for each line retrieved, not the whole 'select' statement.

Alternatively, retrieve all the information via a select statement in the When-New-Form-Instance trigger and populate the non-database fields of a 'control' block that appear on the same canvas as the items from the database block on which the values are based.

If you place the logic in a Forms procedure then you can all it in the WNFI trigger or in other triggers or buttons that you may have for doing requeries.

David

Report message to a moderator

Previous Topic:	What software should i buy if want to develop a web site using Oracle Forms and Reports (Merged)
Next Topic:	Difference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 21:31:56 CST 2025