| Navigation of block of records [message #85755] |
Tue, 27 July 2004 02:30  |
Vikram
Messages: 16
Registered: March 2000
|
Junior Member |
|
|
How to navigate block of records by using button.
ie
if there r 100 records and we want to see 10 records on the form and on pressing button next 10 records should get display and so on and in the same way on pressing another button previous 10 records should get display and while we r on first or lsat record it should display message
Vikram
|
|
|
|
| Re: Navigation of block of records [message #85791 is a reply to message #85755] |
Thu, 29 July 2004 01:59  |
sachin aggarwal
Messages: 9
Registered: June 2004
|
Junior Member |
|
|
this will certainly solve your problem
make a button in control block
and following code to it.i am using block emp, you can change name of block to your need
GO_BLOCK('EMP');
IF MOD(:SYSTEM.CURSOR_RECORD,GET_BLOCK_PROPERTY('EMP',RECORDS_DISPLAYED)) = 0 THEN
GO_RECORD(:SYSTEM.CURSOR_RECORD + GET_BLOCK_PROPERTY('EMP',RECORDS_DISPLAYED)-MOD(:SYSTEM.CURSOR_RECORD,GET_BLOCK_PROPERTY('EMP',RECORDS_DISPLAYED)));
ELSE
GO_RECORD(:SYSTEM.CURSOR_RECORD + (2*GET_BLOCK_PROPERTY('EMP',RECORDS_DISPLAYED))-MOD(:SYSTEM.CURSOR_RECORD,GET_BLOCK_PROPERTY('EMP',RECORDS_DISPLAYED)));
END IF;
|
|
|
|
| Thanks [message #85794 is a reply to message #85791] |
Thu, 29 July 2004 03:14 |
Vikram
Messages: 16
Registered: March 2000
|
Junior Member |
|
|
Thanks Sachin for u r help i willll try that but will it work for both previous and next navigation of records or we have to do something else.
Vikram
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
