OraFAQ Forum: Forms » How to bring the number of record to the forms

Home » Developer & Programmer » Forms » How to bring the number of record to the forms

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

How to bring the number of record to the forms [message #109456]

Thu, 24 February 2005 15:19

wjhdhpy
Messages: 2
Registered: February 2005

Junior Member

After GO_BLOCK(Table_Name), EXECUTE_QUERY, there must be a way to show something like:

This is the "x Number of the records of xxx."

Can someone help to give a clue?

Thank you.

Report message to a moderator

Re: How to bring the number of record to the forms [message #109511 is a reply to message #109456]

Fri, 25 February 2005 02:50

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Have you looked at what Forms displays? It already does exactly what you want. Look at the image below:

/forum/fa/5/0/

MHE

Attachment: FMX1.jpg
(Size: 5.41KB, Downloaded 1214 times)

[Updated on: Fri, 25 February 2005 02:52]

Report message to a moderator

Re: How to bring the number of record to the forms [message #109533 is a reply to message #109511]

Fri, 25 February 2005 08:52

wjhdhpy
Messages: 2
Registered: February 2005

Junior Member

What I like to have is to show within a form to show a line in a display item as:

'This is number ' || :SYSTEM.CURSOR_RECORD || ' of :xx records'

for the end user. That was why I am looking for a kind built-ins to assign
:xx := ??

Thank you.

Report message to a moderator

Re: How to bring the number of record to the forms [message #109559 is a reply to message #109456]

Sat, 26 February 2005 00:32

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

hi

try this code this will give u the number of records fetch from the query;

first set the block property

query all reocords = yes

now
in post query trigger write this code

begin
:global.a := nvl(:global.a,0)+1;
end;

Global.a is number of record fetch;

**********************************************************
count_query built-in returns the message wich contans no of recored will be fetch by query do some R&D on that

Report message to a moderator

Re: How to bring the number of record to the forms [message #109606 is a reply to message #109456]

Sun, 27 February 2005 02:17

Frank
Messages: 7901
Registered: March 2000

Senior Member

The only way to know how many records there are in total, is to count them all.
In forms you want to show the records as soon as possible, to reduce wait-times. Therefor, you do NOT want to scan through all the records, just to be able to show the total number of records.
This is exactly why Forms itself won't show you the total number of records, but show you 2/? in the status-bar

hth

Report message to a moderator

Previous Topic:	Oracle Apps Installation
Next Topic:	oracle auto screen area setting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 05 22:39:42 CST 2025