Home » Developer & Programmer » Forms » How can i know what records are showed in data_block (Oracle Forms 11.5)
icon4.gif  How can i know what records are showed in data_block [message #598690] Wed, 16 October 2013 15:58 Go to next message
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 !
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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1831
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?
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1831
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?
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 Go to previous messageGo to next message
cookiemonster
Messages: 10846
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?
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 Go to previous messageGo to next message
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..
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 Go to previous messageGo to next message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
the form shows the number of records at the bottom of the screen.
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 Go to previous messageGo to next message
Littlefoot
Messages: 19315
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.
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 Go to previous message
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
Previous Topic: Want to Store Images inside Database (merged)
Next Topic: random selection
Goto Forum:
  


Current Time: Sat Jul 26 08:42:34 CDT 2014

Total time taken to generate the page: 0.12414 seconds