Edd
Posts: 547
|
Posted: 01/30/2004, 4:04 PM |
|
To have SQL Paramater Expressions parsed for parameter values. e.g.
In a TABLE VIEW I create a SQL GRID where I wish to retrieve data if the Code is equal to a value inside of the Grid OR or the Parameter contains the value "ALL". I add 1 parameter Code I then want to reuse that Parameter in an expression where '{Code}' = 'ALL'.
In the a above case the 2nd Parameter is passed as it looks '{Code}' = 'ALL', however if I convert the TABLE grid to SQL the values are correctly parsed. i.e.
Select * from Mytable where Mytable.Code ='{Code}' OR '{Code}' = 'ALL' .
If the Expression Builder can be clarified or have a HTML tag on it, it would help.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|