Path: news.f.de.plusline.net!news-fra1.dfn.de!news2.telebyte.nl!fr.ip.ndsoftware.net!proxad.net!postnews2.google.com!not-for-mail From: snakess@hotmail.com (Nagraj Kini) Newsgroups: comp.databases.theory Subject: Re: Storing where clause Date: 20 Aug 2004 00:57:30 -0700 Organization: http://groups.google.com Lines: 15 Message-ID: <451a6377.0408192357.5a63dc5d@posting.google.com> References: <451a6377.0408190128.1afaa622@posting.google.com> NNTP-Posting-Host: 212.190.150.195 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1092988650 20846 127.0.0.1 (20 Aug 2004 07:57:30 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 20 Aug 2004 07:57:30 +0000 (UTC) Xref: news.f.de.plusline.net comp.databases.theory:21563 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