>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.