Skip to main content

Hi Team,

I have created the control procedure to show the user regarding their work permit expire in LAYOUT and DEFAULT code group (I have tried these two things). Its been showing correctly when the work permit date is not current date, but the problem is its always showing the message even we clicked on other fields too if the date is not current date. 

Can anybody help me to fix this? How can I stop the message once its been executed?

Thanks and Regards,

Prabhu S

Hi Prabhu,

If you only want to show a message when a specific field has been modified by the user, you can use the @cursor_from_col_id variable to check the modified field in the Default logic.

For instance:

if @cursor_from_col_id = 'permit_date' 
   and @permit_date is not null
   and @permit_date <> getdate()
begin
    exec tsf_send_message 'warning_permit_date_not_today', null, 0;
end;

 

Thanks Anne Buit, It worked perfectly.

Terms & ConditionsCookie settings