Kbase 17453: Programming for Parameters In Actuate
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Programming for Parameters In Actuate
The ObtainSelectStatement() builds the sql Statement.
There are two types of parameters
1.)AdHoc Parameters Made by clicking on the Adhoc option
in the Condition Tab in the Expression Builder
2.)Normal Parameters made by View Parameters / Add option
from the Menu
The Adhoc Parameters don't need any progamming on our part
because Actuate appends these parameters in the
DynamicWhere Clause built at Run Time.
The Normal Parameters need Programming on our Part
Eg) Lets Say we Have Created A paramater named CityParam
from View Parameters / Add option
Now This parameter Would Show In the Requester Window at
run time.The Value Inputted by the User has to be appeneded
in the WhereClause of the SQL Statement.The Way to do this
would be
WhereClause = " Customer.city = '" & CityParam & "'"
This Statement should go before
The Call to Super::ObtainSelectStatement()
Progress Software Technical Support Note # 17453