How to Validate a field while opening a page.

Dileepa_B

Hello Everyone,

How to validate a field while opening a page.

For example: System must call Validate of "Direct Unit Cost" field while opening Requisition Worksheet page. I tried Validate function in OnAfterGetRecord and OnAfterGetCurrRecord. it didn't work out.

Kishorm

If you want to do something when a page opens then you need to use the OnPageOpen trigger

skulla

Firstly why do you want to validate while opening the page, do you have a code which you want to execute if so where did you add that code on table or on page of that field validate trigger.

Dileepa_B

Yes i want to execute in OnAfterGetRecord trigger page, but when i do it shows error.

Kishorm

You can't make database changes in the OnAfterGetRecord trigger

Dileepa_B

Is there any other way to Validate or update the field when open page?

Kishorm

If you want to do it when the page opens then use the OnPageOpen() trigger

Dileepa_B

Yes i tried the same, still same error.


A transaction must be started before changes can be made to the database.

Page Edit - Req. Worksheet must close.

Kishorm

I've just tested it and databases changes in the OnPageOpen() trigger work fine for me.

Are you sure you have put the code in OnPageOpen() and not in OnInit() for example?

Dileepa_B

Yep I am sure.

Kishorm

Try removing all code from all your page triggers and then running the page to make sure it works OK and then add code to the OnPageOpen trigger and see if that works.

Dileepa_B

Thanks for your help but if i call Validate function from OnOpenPage system does not any validation because system doesn't fetch any record while opening page. Hence its of no use.