I WANT TO PASS QUERY THAT WAS BUILT IN FORM BUILDER 9i TO REPORT BUILDER AS WE DONE IN FORMS 6I AS
ADD_PARAMETER(PL_ID,'P_1',DATA_PARAMETER,'EMP_QUERY');
THIS EMP_QUERY IS BUILT IN FORMS 6i AT RUNTIME.
THIS IS CODE WE WRITE IN FORMS 6I TO PASS RUNTIME QUERY THAT WAS BUILT AT FORM LEVEL AND PASS IT TO REPORTS TO GET RESULTS.THE RESULTS ARE DERIVED ACCORDING TO QUERY THAT WAS PASSED THROUGH PARAMETER.
HOW I CAN DO THAT IN FORMS 9i
ALSO TELL ME HOW TO USE SET_ALERT
WHEN I WRITE IN MY BUTTON CODE
ERROR IS GIVEN
"IDENTIFIER SET_ALERT MUST BE DECLARED"
PLEASE HELP ME
THANKS
HOW TO PASS QUERY FROM DS9
Who is online
Users browsing this forum: No registered users and 5 guests