Gene
Posts: 14
|
| Posted: 06/01/2005, 7:52 AM |
|
I'm sure this is really simple, but I can't get it to work.
In the builders, there are specific controls that implement parenthesis to dictate order of precedence. This is not the case with the custom update tool, however.
Can someone explain how this is accomplished using the custom update tool? Specifically, I need to construct an OR clause that tests the state of a session variable along with the value returned by a function.
If
(some conditions)
...
AND
(UserID=CCGetUserID() OR CCGetGroupID() >=100)
I have tried using one long expression, encased in double quotes (executes but fails to update), as well as without double quotes (syntax error in SQL).
Thanks much.
Gene
|
 |
 |
Gene
Posts: 14
|
| Posted: 06/01/2005, 11:36 AM |
|
Nevermind.
I just coded it directly into the 'before build update' event using the datasource where object.
Simple enough.
Thanks anyway.
|
|
|
|
|
