Developing select statement using a string

rameshpasara

Hi,

My select statement will be changed based on the parameters that I select in a form.

I have around 5 Yes/No fields in a form , and these 5 Yes/No fields are associated to other 5 string fields. So I have to write a statemnt based on the Yes/No values that I select.

For example my Yes/No fields are Field1,field2,filed2,field3,field4,field5 and the string fields are field11,field22,field33,field44,field5. And now if field1 , field3 , fiel5 are set to Yes my statement should be as

"while select table1 group by field11,fild33,field55 "

So based on the yes/no values that I select my grouping changes,I cannot keep on putting multiple if-elseif conditions for each combination of the values.



Thanks

kashperuk

If you switch to using the QueryBuild* framework, you can easily accomplish the specified requirements, by only adding SortFields (with GroupMode set to Group instead of Sort) based on the selection in the check-box controls.