rbaldwin
|
Posted: 10/31/2003, 8:49 AM |
|
I'm trying to restrict the rows listed in my grid to the rows created by the user logged in.
I'm trying to use the data source propert for the grid.
I want to add a Where Condition but i'm having trouble filling in the Table Parameter form.
my Field is Form.Originator
my Condition is equals (=) but i'm not sure how to specify the Parameter source to use the CCGetUserID() function. i have created a session variable USERID but not sure how to use it either.
|
|
|
ryan
|
Posted: 10/31/2003, 3:22 PM |
|
do not create the USERID, ignore the CCGetUserID()
just add(+) a session parameter (integer) 'UserID' - i believe is case sensitive bec. it's a session variable
thus ur generated SQL WHERE would be
WHERE Originator={UserID}
|
|
|
|