Patent ID: 7610308

Claim:
A computer-implemented method for querying records from a database in a SQL database server wherein the query is provided as a flowchart, the flowchart including: a start unit at which the flowchart starts; one or more value units at which the flowchart ends, one or more logic units between the start unit and the value unit, each logic unit: representing a logic statement, having a true output representing a true result of the logic statement, and having a false output representing a false result of the logic statement, and possible paths through the flowchart wherein each path extends: from the start unit, into one or more of the logic units, out of one of the true output and the false output of each logic unit that the path enters, and ending at one of the value units, the method including the steps of: a. determining all possible paths through the flowchart; for each possible path, generating a path logic statement including: the logic statement of the first logic unit along the path after the start unit, and the logic statement of each successive logic unit along the path, wherein the logic statement of each successive logic unit is appended to the path logic statement by: an AND if the successive logic unit is entered from a true output of the prior logic unit along the path, or an AND NOT if the successive logic unit is entered from a false output of the prior logic unit along the path; generating a flowchart logic statement including all path logic statements, wherein each path logic statement is separated from any adjacent path logic statements by a logical OR.