>>Does anyone have a good function/procedure/class that can build n-sized WHERE clauses? That is, I want to be able to pass it something like an array full of populated or empty fields and have it automatically add any needed " AND ". So I could do something like:
>>
>>lnElements = 4
>>DIMENSION laFilter[lnElements]
>>
>>laFilter[1] = "One"
>>laFilter[2] = ""
>>laFilter[3] = "Three"
>>laFilter[4] = "Four"
>>
>>oSQL.Where(@laFilter)
>>
>>?oSQL.WhereClause
>>
>>One AND Three AND four
>
>Please don't take this as a critcism, but you are looking for a class to replace 3-4 lines of code MAX. If you write it yourself as straightforward in-line code you will save memory and it'll probably execute faster too.
This is not true. If you want to build a QBF interface that allows users to select as many or as few filters from x number of fields, then you need a class like this. You can not code it straight in line, because you don't want irrelevant filters in your WHERE clause.
I have had need for a class like this many times, but have never yet taken the time to build a generic one, I have just handled it per situation so far.
I, too will be watching this thread for ideas.
Erik Moore
Clientelligence