:NEW,"RECORD-ID" :=
TO-NUMBER(SYS-GUID(),'xx xxxxxxxxxxxxxxxxxxx xxxxxxxxxxx');
END IF;
end;
Please note the modifications: "insert on " has been modified as "insert or update on" Two new lines has been added with respect to Ledger-name, Report-Type, Another new word 1 functions UPPER( ) has been used, This Upper() function will accept one parameter, For example Upper(
'raghu') will return value as RAGHU, Small 1 lower case letters has been embedded by single quotes in this function may be replaced by column name without single quotes,
Assume that there is only one record wherein 'bank account' has been entered in ledger-name,
If you give the command
select ledger-name, upper(ledger-name) as caps from raak-ledger-master;
will return
Ledger-name caps