[ANSWERED] Nitro query - edit grid

[ThierryC]

Is there a way to have default values for fields that are part of the file, but not necessarily to be displayed on the screen when editing or adding a new record.

in all my files i have f.e some logfields (creation date/updat date/ creation user..etc) and i can think of other examples as well..

these fields are not intended to be displayed ,nor edited in the editgrid;
so is there a way to have fields entered with the value (current date, current user...etc..)


thx

[Johnny Major]

Thierry,

As of Valence 5.1 you can setup an RPG program that can manipulate field values before the record(s) is updated/created. Example validation/modify program in Valence is "EXQRYVAL". You would use the SetValue helper procedure passing the file, field, and value.