Using"TREE"to Construct WHERE Clause in SQL Statement:Implementation and Application of "TREE" in VB
Ming Li · Microcomputer Development · 2003
When MIS is being developed,the function of searching information should be provided. In general,this function is implemented by using SQL statements.The key of correctness of the result of query is correctness of the WHERE clause.Here introduces a structured method of generating a WHERE clause. In this way, a condition expression is created by making use of hiberarchy of tree, from which, a string that stand for a condition expression which is used in WHERE clause is obtained. This method has been used in development of applications software, and has made good effects.