getdbfield syntax

Sort:
You are not authorized to post a reply.
Author
Messages
JackNoody
New Member
Posts: 3
New Member
    Can someone please reply with the correct syntax for the getdbfield function?
    We are trying to get the process level from the employee table. 
    Here is what we are trying and it is not working on the EMDEPEND table:

    trim(getDBField('EMPLOYEE','PROCESS_LEVEL',table.COMPANY,table.EMPLOYEE))=='1'
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
      I have: trim(getDBField('EMPLOYEE','PROCESS-LEVEL',table.COMPANY,table.EMPLOYEE))=='900' which is true if PROCESS-LEVEL = 900. Is 1 one of your process levels?
      JackNoody
      New Member
      Posts: 3
      New Member
        Thank you that was it. We had an underscore instead of a dash for the process level variable.
        You are not authorized to post a reply.