OraFAQ Forum: Forms » Get_block

Home » Developer & Programmer » Forms » Get_block_Property (Oracle 10g)

Fri, 20 May 2011 05:57

swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai

Member

Please tell me how to get total number of record in form

swapnil

Fri, 20 May 2011 06:06

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

Senior Member
Account Moderator

This is one option:

last_record;
message('Number of records = ' || :system.cursor_record);

Or, you could utilize COUNT_QUERY built-in.

Or, loop record by record and count them.

[Updated on: Fri, 20 May 2011 06:07]

Fri, 20 May 2011 06:35

swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai

Member

thanx

is there any GET_BLOCK_PROPERTY built in function

to retrive direct value i want to use this value in for loop

Fri, 20 May 2011 06:45

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

Senior Member
Account Moderator

In a loop? How and why?

GET_BLOCK_PROPERTY is described, in details, in Forms Online Help system so - read it.

Previous Topic:	about button on LOV - Oracle Forms 10g
Next Topic:	RADIO BOX DISABLE

Goto Forum:

]

Current Time: Fri Dec 05 13:48:42 CST 2025