SRW.SET_FIELD_DATE
built-in procedureThis procedure sets the value of a date field. This is useful when you want to conditionally change a field's date value.
SRW.SET_FIELD_DATE (objectid, date DATE);
Parameters |
Description |
objectid |
Is always 0. (The object must always set its own attributes.) |
date |
Is the date you want the field to display. |
SRW.SET_FIELD_DATE
is only meaningful in a format trigger for
a date field. It has no effect when entered in other places.
Suppose you want to conditionally change the date of the reunion invitation, based on each student's graduation year. In the format trigger for the field, you could type the following:
FUNCTION CHGFIELD RETURN BOOLEAN IS
BEGIN
if :graduation >= 1975 then
srw.set_field_date (0, '02-JUL-95');
else
end if;
RETURN (TRUE);
END;
About the
Reports Builder built-in package (SRW
)
Copyright © 1984, 2005, Oracle. All rights reserved.