Hello everybody,
I need a SQL parsing tool, especialy for the where clause. At first approach, this doen't seem to be very easy. I wonder if there is someone who has written one.
I need this because in my project, the end-user can make a search on any field from the list of tables of the query. As in Valentina, I must group conditions by table. My plans are to read the custom SQL where clause and rewrite in the correct order.
Or perhaps, Ruslan, can you make our life better and do this for us as you have already the parser. You just have to replace the fields in the correct order. Am I wrong ?
Thank you.
Fran=E7ois Van Lerberghe Thier Monty, 15A B-4570 Marchin Belgique ©2002 Francois Van Lerberghe |