This content has been marked as final. Show 5 replies
Hi, try do it in the trigger "PRE-QUERY".
Thanks for your help. The validation work fine in pre-query. Could you also shed some light on error FRM-41003: "This function cannot be performed here" as well?
Hi Michael ,
I had tried it in pre-query but .. I found the same error..
It sounds like you have a trigger that is firing (like a When-Validate-Item) when you are not expecting it to fire. If you are able to run your form from the Forms Builder, I recommend you run your form with Debug Messages turned on to see what is firing when you click the "Execute Query" button. If you can't run from the Forms Builder, then I recommend you enable "Tracing" and run your form. Then review the trace log to see what is actually causing your error. Once you know the actual source of your error you will be able to resolve it.
Hope this helps,
If someone's response is helpful or correct, please mark it accordingly.
FRM-41003: "This function cannot be performed here"
My plan is ... click execute query buttonSo, when do you click enter query? If you input the dates in a control block, there is no enter query.
When I click enter query icon