update fields in form

Stéphane_Vabois

Hi everybody,

I'd like to know the way to update a field in a TABLE when I change records on form.
Example : I create a form based on TABLE Test
if the date in the table is less thant the WORKDATE, I want to change a boolean field (also in the table TEST).
I have a error message that I can change anything about the ONAFTERGETRECORD.

Does somebody have a solution ?

Thanks.

Sbhat

Hi,

I would suggest that you create a command button and execute this functionality, because on OnAfterGetRecord you cannot modify a record. Let the form come up as normal and then have the user click a button which would then modify the boolean field based on the condition.

Thanks
Best regards
Suresh.

pablo.passero

You need an automatic procedure... Create a new function in the table Test or in a new codeunit. Then, call your new function from the trigger OnAfterGetRecord()... The function will contain the source code to change the boolean value from the comparison of Wrokdate value into the current record... as simple like that.

See the example above: (The function is into the same Table 'Test')

OnAfterGetRecord()
ChangeValue; //this is your function

ChangeValue()
IF TestDate < WORKDATE() THEN
BEGIN
BooleanField := x; //Put your desired value
MODIFY;
END;

Bye.