This content has been marked as final. Show 4 replies
pravish wrote:You can use the apex_application.g_fxx arrays instead of using bind variables in the validation code. To identify which apex_application.g_fxx arrays map to your date columns, you need to look at the generated HTML source of the page or refer to this link for details:
I have a tabular form. I have 2 columns end_date and extension_date. I need to create a validation saying " extension_date has to be greater than end_date". I tried below but it didn't worked. Any tips would be helpful.Thanks in advance.
Type: Function returning Boolean
if to_date(:P40_EXTEND_DATE, 'DD-MON-YYYY HH:MIPM') > to_date(:P1_END_DATE, 'DD-MON-YYYY HH:MIPM')
Once you have identified the array elements, you can use them in your validation. One of the examples is explained here:
Hi Rohit, thanks for the tip.But i hit another issue. I have multiple rows in the form and the validation code is working for only first row.From the second row onwards the validation doesn't work. Any idea/tips?
Hi Rohit, I figured out the answer.
THX A LOT
I am glad that you figured it out.