How do I retrieve data from a view created and saved in Oracle Forms 6i w/ dB 10g?
I have a form(6i) running against Oracle dB 10g w/ the following code in the "WHEN-BUTTON-PRESSED" Trigger:
BEGIN
GO_ITEM('SCOPE.TEXT_DATE');
SHOW_VIEW('SCOPE');
END;
It looks like the object is a View called 'SCOPE' and is being populated in the form, but how do I retrieve the data from the view 'SCOPE' since it does not physically exist in my schema?
Thank you very much in advance for any/all the help, Jinlan 🙏