PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 2/19/2013 3:55 PM by  Georgette
AP90 Security
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Sandra Badini
Application Analyst
Van Andel Institute
New Member
(3 points)
New Member
Posts:3


Send Message:

--
1/14/2013 8:08 PM
    I am trying to limit AP90 security to PO Vendors only.  I tried the following rule on the AP tables used by AP90 without success.  Has anyone tried to create this type of security rule before?

    table.VENDOR == getDBField('POVENDOR','VENDOR',table.VENDOR_GROUP, table.VENDOR)
    Georgette
    Financial Systems Coord
    MRHS
    Veteran Member
    (152 points)
    Veteran Member
    Posts:52


    Send Message:

    --
    2/19/2013 3:55 PM
    I am new, but I was told to use the trim function when accessing tables. Trim is for alpha numeric and lztrim for leading zeroes. So check what the data type is.

    trim(getDBField(.....)) == trim(table. ____)
    You are not authorized to post a reply.