Last_Record
Hi Everyone.....
I have a master-detail form. The detail part of the form I am trying to navigate through the data. When the detail hits the last record I would like to display my Alert message, but every time I hit the navigation button (next record) I always get my ALERT message displayed (which states you are at the last record). What am I doing wrong... Here's my code:
declare
x number;
begin
GO_BLOCK('dept');
GO_RECORD(TO_NUMBER(:SYSTEM.CURSOR_RECORD)+1);
IF :System.Last_Record = 'TRUE' THEN
x:= show_alert('end_alert');
END IF;
END;