Thanks a lot for your reply.
Actually, STATUT is a variable name and it stores the string value of Status field Labeled corresponding database column name. Same is the case with other variables defined in ModuleName_Fields(xxx) without parameters.
Please find below code:
STATUT = userfield("Status","REQ")
sql = "Select SF_COLUMN_NAME as thecolumn FROM SYSTEM_FIELD WHERE SF_USER_LABEL='" & label & "' "
sql = sql & "AND SF_TABLE_NAME='" & tablename & "'"
set req = requestRecordset(sql)
if req.Recordcount > 0 then
result = req.FieldValue("thecolumn")
msgbox "Error for the field " & label
userfield = result
We have noticed that by mistake someone changed value of DISABLE_COMMAND_INTERFACE site admin parameter value from N to Y,So after changing DISABLE_COMMAND_INTERFACE site admin parameter value from Y to N, issue got resolved.
Setting DISABLE_COMMAND_INTERFACE value to N means, all Non Admin users will be able to execute commands via Workflow without any issues just like Admin users.
Strange thing in my case is, when DISABLE_COMMAND_INTERFACE parameter is Y,how come first user who logged in with non admin credentials able to execute workflow commands without any issue, and second user who is using same non admin credentials failed to execute SQL commands via workflow?
What would have caused this difference? Ideally both the first and second user who are using non admin credentials should have failed to execute the SQL commands in workflow script when DISABLE_COMMAND_INTERFACE parameter is Y.