VALIDATE in OnAssistEdit

ervaro

For a field I use the OnAssistEdit trigger in C/AL. In this trigger I also put a VALIDATE command but it seems the validation is not executed at all.

Action Date - OnValidate()
IF "Action Date" > TODAY() THEN BEGIN
     ERROR('Date is after today');
   END;


Action Date - OnAssistEdit()
calendar.AssistEdit("Action Date",FIELDCAPTION("Action Date"),'');
VALIDATE("Action Date","Action Date");

Can somebody please help me to fix this problem.

Thanks.

Erik

kapamarou

ervaro wrote:

calendar.AssistEdit("Action Date",FIELDCAPTION("Action Date"),'');
VALIDATE("Action Date","Action Date");

Between those two lines add a MESSAGE('!!!!!') to see if the VALIDATE is called before you choose a date. I Had a similar issue in a different case where RUN was used instead of RUNMODAL. Maybe it's something similar here.

ervaro

Thanks for your reply.
The MESSAGE between these lines is executed but still no validation.

Any suggestions?

kriki

Try this:

Action Date - OnAssistEdit()
datActionDate := "Action Date";
calendar.AssistEdit(datActionDate,FIELDCAPTION("Action Date"),'');
VALIDATE("Action Date",datActionDate);

JPHSC

calendar.AssistEdit("Action Date",FIELDCAPTION("Action Date"),'');

What code is there in this function, because I don't think the "Action Date" value is updated when you validate...

ervaro

@Kriki: Unfortunately it did not work.
@JPHSC: It is a calendar form to pick a date (also downloaded from this site). When I put a message after the calendar form the picked date is shown.

Savatage

from your first post - Does the validate work on Validate-Action Date?

So you want to add some code on the assist edit to stop a blank? What is actually your problem?

kine

I assume that the OnValidate trigger you mentioned is on form and not on table. VALIDATE() calls only table validation, not form field validation...

ervaro

You are right, I used it as form validation. Will try it as table validation.
Update: Moving the validation to the table works fine. Thanks to all.