2. ASPRunnerPro General questions
  3. PLEASE HELP - Charts have lost Security
This topic is locked

PLEASE HELP - Charts have lost Security

 		10/25/2009 9:24:36 AM
ASPRunnerPro General questions
C
 Conrunner author

Hi

Running ASPR 6.1

Everything was working fine up until recently but then all of a sudden my Charts rather than just showing the user who has logged in's data they show everyones data! (I have made the appropriate selections on the Security Tab). This did not happen before and I have no idea why it should be happening now. This is really messing things up for me so please can any one help?

Con.
J
 		Jane 10/26/2009

Hi,
try to add following code to the After table initialized event on the Events tab:

if bValue(SecuritySQL("Search","")) then

doAssignment gsqlWhereExpr,whereAdd(gsqlWhereExpr,SecuritySQL("Search",""))

end if