Hi ALL,
I have two forms let's say Forms A and forms Z and fully based on database block.
I am calling form Z from form A and by parameter as primary key columns let's say EMPID,JOB and DEPTID.
In form z i have list items for deptname why because i am loading the department names into this list form dept master.
And in form z some non-database items are for showing names because of code and names are in masters.
In When-New-Form-Instance trigger of form z i have written the following.
IF Parameter.Entry_Mode = 'EDIT' THEN (I have three entry modes ADD , EDIT and VIEW) my problem is in EDIT mode.
GO_Block('EMP');
Execute_Query(No_Validate);
my Block emp having triggers Pre-Query, Post-Query and other When-Validate-Item triggers are there.
I am showing the block status here with alert but it is showing CHANGED, i don't understand why it is showing CHANGED instead of block status QUERY.
Set_Alert_Property('Alert_Ok',Alert_Message_Text,'Form_Status-->'||:System.Form_Status||'--'||Get_Block_Proeprty('EMP',Status));
Both :System.Form_Status and Get_Block_Proeprty('EMP',Status) are showing CHANGED.
END IF;
In When-Validate-Item trigger i have written the condition like this
IF Get_Block_Proeprty('EMP',Status) <> 'QUERY' THEN
Some codes are here;
END IF;
I hope everybody will understand the issue and my expression of describing about the issue.
Can anybody guide to solve the problem ?
Any help is appreciated.