Re: No. of recs in a block

Another thing you can try is this

DECLARE
  nLastRecord NUMBER;
BEGIN
 LAST_RECORD;
 nLastRecord := TO_NUMBER(:system.cursor_record); END; nLastRecord would then hold the number of records retrieved.

Hope this helps,
Patrick Flahan
flahan_at_earthlink.net

<srijay_at_my-dejanews.com> wrote in message 70p7e6$lnp$1_at_nnrp1.dejanews.com...
>Hi!
>
>Is there a way to get the numbers of records in a block. I know I can get
>the display records in a block using get_block_property, but I want to get
>the total number of records in the block. I can get the record count as it
>quired but how can I get the actual record count after user has add and
>delete records in the block before commiting to the database. I am useing
>Forms 4.5.
>
>Thanks,
>Sri.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Oct 24 1998 - 02:10:56 CEST