Some Oracle forms Developer 6i problems
Hello Knowledge exchanger
I have some problems which need to be fixed as soon as possible, I really need your help, the problems are listed below:
1) when creating a form with buttons one for enter query and another for execute query, an error raised at the run time which is "the function cannot performed here"... it's necessary to mention that the form is tab form, and the same code is running correctly in content form, so what is the problem? and how to fix it?
2) Global Variables: when Identifying global variables in the sign in form, these doesn't work well in other forms later when we use global variables, does this is because we open_form with new session? like this open_form('form_name', Activate, Session)?????, and how can we use these global variables in another forms correctly?
3) How can we make the built in Oracle messages as Alerts for user? I mean dialog Alert... this for example: if there is an error through inserting data in fields we raise an alert and these alerts are the same errors that are appears to users at the end of the form window
Thank you in advance and I highly appreciate your answers
Software/Hardware used:
Oracle Developer 6i and Oracle Database 10g
Software/Hardware used:
Oracle Developer 6i and Oracle Database 10g
ASKED:
March 30, 2011 9:28 PM
UPDATED:
June 14, 2012 5:54 PM
Answer Wiki:
I have some problems which need to be fixed as soon as possible, I really need your help, the problems are listed below:
1) when creating a form with buttons one for enter query and another for execute query, an error raised at the run time which is "the function cannot performed here"... it's necessary to mention that the form is tab form, and the same code is running correctly in content form, so what is the problem? and how to fix it?
2) Global Variables: when Identifying global variables in the sign in form, these doesn't work well in other forms later when we use global variables, does this is because we open_form with new session? like this open_form('form_name', Activate, Session)?????, and how can we use these global variables in another forms correctly?
3) How can we make the built in Oracle messages as Alerts for user? I mean dialog Alert... this for example: if there is an error through inserting data in fields we raise an alert and these alerts are the same errors that are appears to users at the end of the form window
Thank you in advance and I highly appreciate your answers
To see all answers submitted to the Answer Wiki: View Answer History.
“1) when creating a form with buttons one for enter query and another for execute query, an error raised at the run time which is “the function cannot performed here”… ”
Is that the exact and complete error message ?
Also, please post the code you are using.
“2) Global Variables: when Identifying global variables in the sign in form, these doesn’t work well in other forms ”
What exactly do you mean by “doesn’t work well” ?
“3) How can we make the built in Oracle messages as Alerts for user? ”
The ON-MESSAGE form level trigger is called every time the system generates an error or message to the user. Use this trigger to catch messages and display them according to your requirements.