|
|
|
|
|
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|
|