摘要 |
The invention comprises a query generator program and an improved client program adapted to use the query generator program. The improved client program comprises a query template that includes one or more query clauses and parameter data. Query clauses include parameter markers that operate as placeholders for dynamic parameters. Parameter data comprises a data type character and a program variable. The improved client program accepts a dynamic parameter from a user, or calculates it at run-time, and then replaces the program variable in the query template with the dynamic parameter. The query generator program then processes the modified query template to generate a query string. The client program then can process the query string further, or pass the string on to a DBMS as a query statement.
|