[RBG7-L] - Re: getproperty for a row in scrolling region

[A. Razzak Memon]

At 05:15 PM 5/14/2005, Bernie Lis wrote:

I want to know what row I am on in a scrolling region.

Bernie,

You can easily achieve that goal by using the RECORDCOUNT and RECNO
option of the GETPROPERTY command.

Here's how:

Syntax:

GETPROPERTY TABLE 'tablename->RECORDCOUNT' varname

GETPROPERTY TABLE 'tablename->RECNO' varname

Example 01:

-- GetRecordCountAndRecordNumber.EEP
-- R:BASE 7.5 for Windows, Build: 7.5.5.30511 or higher
-- Database: RRBYW10
-- Associated Table: Customer
-- Associated Form: RecordCount_RecNo
-- To Demonstrate the use of RECORDCOUNT and RECNO GetProperty Commands

CLEAR VAR vRecordCount, vRecNo, vRecInfo
SET VAR vRecordCount TEXT = NULL
SET VAR vRecNo TEXT = NULL
SET VAR vRecInfo TEXT = NULL
GETPROPERTY TABLE 'Customer->RECORDCOUNT' vRecordCount
GETPROPERTY TABLE 'Customer->RECNO' vRecNo
SET VAR vRecInfo = ('Record'&.vRecNo&'of'&.vRecordCount)
PROPERTY RecInfo CAPTION .vRecInfo
CLEAR VAR vRecordCount, vRecNo, vRecInfo
RETURN

Have fun!

Very Best R:egards,

Razzak.