Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

good way to get the number of records in a block

juliojgsNov 7 2013 — edited Nov 7 2013

Working with forms 11g .

I want to know the amount of records that are currently in a block, being that the :system.cursor_record you might get if you issue a last_record built-in.

This seems the kind of thing that should be easy to get with a get_block_property, but I've been looking for the property and I haven't found it.

There are various properties fo get_block_property that are related to number of records, but none seems to fit what I need. The best is QUERY_HITS. It works fine when you have just executed a query (with all records) , but if you add or delete records, it keeps its old value, so it's no use.

The last_record trick is quite dirty (and implies navigation, which is worse) ... Can you think of anything better?

I have tried with a summary item, and it works, but I'm not sure if it is reliable, and it is still too much for something that should be in a property

This post has been answered by Andreas Weiden on Nov 7 2013
Jump to Answer

Comments

EJP
I suggest you print out the name of the interface before trying to get its MAC address, and investigate the characteristics of the one that fails. Probably it is one that doesn't have a MAC address, e.g. 127.0.0.1.
qjvictor
Thanks for your reply.

The exception is specifically from the network interface between M5000 service processor and each domain.

In my case, I just need to catch this exception, and continue to get mac address from other interfaces.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 5 2013
Added on Nov 7 2013
1 comment
269 views