Hi Community.
I'm new in Oracle Forms and I've a problem with a Personalization.
When I'm going to find a Requisition Line, I want to lines that not comply my condition, they appear deactivated.
I check condition and work fine, but I don't know how utilice triggers events on Oracle Forms. I've selected WHEN_NEW_BLOCK_INSTANCE for when I press "Find" the personalization look one to one of my records, It decide what records has to desactive.
I'm going to shared some pictures with my SQL query and my personalization.
When I press "Find" automatically the personalization look every line that don't work and disable It.
Lines must appear disabled if condition
This is my personalization.
SQL query.
(SELECT ''||COUNT(*)
FROM PO_REQ_DISTRIBUTIONS_ALL REQ_DIS
WHERE REQ_DIS.REQUISITION_LINE_ID = :REQ_LINES.REQUISITION_LINE_ID
AND TO_CHAR(REQ_DIS.GL_ENCUMBERED_DATE,'YYYY') < TO_CHAR(SYSDATE, 'YYYY')) <> '0'
Explanation.
When a Line lesser than sysdate then that line has to be disable. One Requisition can to have more one line. Count look when some line don't comply this condition and then disable it.
This are actions for the condition.
I hope you can help me. I need solve this problem with urgency.
Thanks so much!!