OraFAQ Forum: Forms » How can i know what records are showed in data

Home » Developer & Programmer » Forms » How can i know what records are showed in data_block (Oracle Forms 11.5)

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

How can i know what records are showed in data_block [message #598690]

Wed, 16 October 2013 15:58

kiike007
Messages: 10
Registered: October 2013
Location: México

Junior Member

I urgently need to know what records are showing a text_item of a data block. For example in the attached image, how can I known that records displayed are Enterprice 8, Enterprice 9, ... , Enterprice 13? Tnx !

Attachment: Sin título.jpg
(Size: 44.50KB, Downloaded 831 times)

Report message to a moderator

Re: How can i know what records are showed in data_block [message #598692 is a reply to message #598690]

Wed, 16 October 2013 16:12

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Is it Oracle forms question? If yes, can you run opatch lsinventory -detail command?

Report message to a moderator

Re: How can i know what records are showed in data_block [message #598702 is a reply to message #598692]

Wed, 16 October 2013 17:18

kiike007
Messages: 10
Registered: October 2013
Location: México

Junior Member

It´s in Oracle Forms 6, assuming that the list is very large and we move in it, how can I know what items are visibles at one time?

Report message to a moderator

Re: How can i know what records are showed in data_block [message #598704 is a reply to message #598702]

Wed, 16 October 2013 17:22

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

kiike007 wrote on Thu, 17 October 2013 03:48

It´s in Oracle Forms 6, assuming that the list is very large and we move in it, how can I know what items are visibles at one time?

Sorry, I don't understand what you need. You said you want to know the version, right?

Report message to a moderator

Re: How can i know what records are showed in data_block [message #598709 is a reply to message #598704]

Wed, 16 October 2013 18:18

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

Senior Member

Where do you see any reference to version?

@kiike007 - you can check the values of the current record easily enough and you can skip between records using previous_record and next_record etc.
What exact problem are you trying to solve?

Report message to a moderator

Re: How can i know what records are showed in data_block [message #598711 is a reply to message #598704]

Wed, 16 October 2013 19:24

kiike007
Messages: 10
Registered: October 2013
Location: México

Junior Member

Oh no, hahaha im sorry.. really i want to know the numbers of records that are currently displayed in data_block, see the attach image, imagine that we I have records up and down, but only I can see 6 records at the same time, my question is, How i know the number of record of Enterprices that I can see..

Report message to a moderator

Re: How can i know what records are showed in data_block [message #598722 is a reply to message #598711]

Thu, 17 October 2013 02:39

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

Senior Member

the form shows the number of records at the bottom of the screen.

Report message to a moderator

Re: How can i know what records are showed in data_block [message #598915 is a reply to message #598722]

Sat, 19 October 2013 16:06

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

Senior Member
Account Moderator

... which, initially, doesn't need to show all available records. For example, you perform query in a tabular form which has 5 visible records. It fetches 100 but displays (obviously) 5 records. Information at the bottom of the screen says that you are on the "1/?" (1st of ? records) (?, because Forms doesn't know how much, yet), so you can't rely on that - navigate to the last record (using LAST_RECORD built-in) and check what's written in :SYSTEM.CURSOR_RECORD system variable.

Alternatively (and maybe even better - it is much simpler) is to set data block's "Query all records" property to YES (so you'll see "1/100" instantly. That property might cause problems (i.e. slow things down) if query retrieves many records (see also "Query array size" property).

Or, navigate to Forms' runtime "Query" menu and select "Count hits" - it will display number of records to be retrieved.

As you can see, quite a few possibilities - pick the one you find the most appropriate.

Report message to a moderator

Re: How can i know what records are showed in data_block [message #599039 is a reply to message #598915]

Mon, 21 October 2013 13:15

kiike007
Messages: 10
Registered: October 2013
Location: México

Junior Member

Littlefoot Tanx for the information, i solved the prblem using :system.cursor_record Smile

Report message to a moderator

Previous Topic:	Want to Store Images inside Database (merged)
Next Topic:	random selection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 16:08:26 CST 2025