EXECUTE-QUERY doesn't exist. You're probably looking for QUERY and you should read the Form Builder help documentation:
SYSTEM.MODE indicates whether the form is in Normal, Enter Query, or Fetch Processing mode. The value is always a character string. ValueDescriptionNORMALIndicates that the form is currently in normal processing mode. ENTER-QUERYIndicates that the form is currently in Enter Query mode. QUERYIndicates that the form is currently in fetch processing mode, meaning that a query is currently being processed.
Thank You Hoek.
QUERY Indicates that the form is currently in fetch processing mode, meaning that a query is currently being processed.
You say 'QUERY' is when data is being fetched.
What mode will be the system in , after the fetching is over???
Will it come back to the 'NORMAL' mode?? Or will it still be 'QUERY' mode??
I actually want to code after execute_query is pressed but when the fetching of data is over.
Thank You so much. I'll try it out.
Actually not solving my purpose.
I have a form with one data block MATURED_FD_DTL which looks like below:
CREATE TABLE MATURED_FD_DTL
ACCT_FD_NO VARCHAR2(17 BYTE) NOT NULL,
P_TYPE VARCHAR2(1 BYTE)
I don't want the user to enter values already present in database in ACCT_FD_NO column ,
so as soon as the data is enter in that field & press next item, I want to display an error message saying its a Duplicate value
& raise form trigger failure & not allow to update.
So i put in the following code for ACCT_FD_NO, Trigger:KEY_NEXT_ITEM:
IF :SYSTEM.MODE = 'NORMAL' THEN
SELECT COUNT(*) INTO V_COUNT FROM MATURED_FD_DTL WHERE ACCT_FD_NO=CHECK_DUPLICATE;
IF V_COUNT>=1 THEN
MESSAGE('YOU HAVE ENTERED AN EXISTING ACCOUNT FD NO : '||CHECK_DUPLICATE);
SELECT ACCT_CUST_CODE, AMOUNT INTO CUST_CODE, FD_AMT
FROM KEC_FDACCT_MSTR WHERE ACCT_FD_NO = :ACCT_FD_NO;
:CUST_CODE := CUST_CODE;
:FD_AMT := FD_AMT;
:CREATED_DATE := SYSDATE;
:CREATED_BY := :GLOBAL.USER_ID;
ELSIF :SYSTEM.MODE = 'ENTER-QUERY' THEN
ELSIF :SYSTEM.MODE = 'QUERY' then
The purpose of not allowing duplicate value is done.
But if I press enter_query & execute_query to see all the values,all the values get populated.
When i move cursor from one field to another by using tab or right arrow button through keyboard,
then it shows that Message that is 'YOU HAVE ENTERED AN EXISTING ACCOUNT FD NO :value'.
So i want this to happen only when i enter the data (or say when in NORMAL Mode)
and not when i do 'ENTER_QUERY, EXECUTE_QUERY and also POST_QUERY.
So how do i do this??
Please help me.