Re: Storing where clause

Right now the where clause is stored as a string which I am not too thrilled about. I want to provide a UI so that the application admin can himself add the where clause and he dosent call me everytime to change the clause or add a new one. Storing it as a string is easy but when he needs to edit it, I will have to write the entire string parser which I dont want to do.
To give a brief idea the requirments are like this:- 1) Each screen has one table which defines all the parameter for the subset.
2) I need to provide a where clause based on these params. 3) The general structure of the query is like this

   where param is (not) in ( 'value1','value2') and/or ....

Regards,
Raj Received on Fri Aug 20 2004 - 02:57:30 CDT