Determine a record is newly inserted

eddietlin

I remember there's a way to determine the record is newly inserted by the user. Any ideas?

For example, I want some logic to take effect only when user enter a value on a field (OnValidate) on a new record.

evandeveerdonk

Hi Eddie,

not sure if I understand the question correctly. But if you want to execute some code only if the user modifies a record in a certain field, you can use CurrFIELDNO.

Let's say that you only want to execute some code only if a user is actually in the field "E-mail" of the Customer table:

IF CurrFieldNo = FIELDNO("E-Mail") THEN BEGIN
..
..
END;


Hope that helps