Re: Storing where clause
From: Nagraj Kini <snakess_at_hotmail.com>
Date: 20 Aug 2004 00:57:30 -0700
Message-ID: <451a6377.0408192357.5a63dc5d_at_posting.google.com>
Date: 20 Aug 2004 00:57:30 -0700
Message-ID: <451a6377.0408192357.5a63dc5d_at_posting.google.com>
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 - 09:57:30 CEST