Parameter | Description |
---|---|
sOrigFilter | First filter string |
sFilter | Second filter string |
Function SQLStrAppend String sOrigFilter String sFilter Returns String
Call: | Get SQLStrAppend sOrigFilter sFilter to StringVariable |
This is a helper function that will take two SQL filter strings and combine them (i.e. combine them using proper SQL AND syntax).
If either filter string is empty, the function will handle this properly and just return the non-blank value. This means you don't need to test if a string is empty before calling this.
This sample shows how to create and apply two SQL filters that have been combined using AND.
Object oCustomerDataDictionary is a cCustomerDataDictionary Set pbUseDDSQLFilters to True Procedure OnConstrain String sFilter Get SQLStrAppend 'Customer.Customer_Number > 20' 'Customer.Customer_Number < 50' to sFilter Set psSQLFilter to sFilter End_Procedure End_Object