基于PB的通用查询模块

General Query Module Based on PB

基于PB的通用查询模块(GQM)在WIN2000/PB7/SQLServer7环境下开发。查询时,先提取当前数据窗口对应的表名,将其传给GQM,再提取GQM查询条件子句重构SQL脚本。在“字段名”栏选择相应字段列表,在“操作符”栏选择该条件的操作符,在“值”栏输入相应的值。在“连接符”栏选择相应连接符,反复插入、删除条件直到构成满意的条件组合,实现数据窗口内容的任意条件查询和检索。

General query module (GQM) based on PB was developed under WIN2000/PB7/SQLServer7. When queried, table name corresponded to current data window was extracted, and sent it to GQM, query if-clause was extracted to reconstruct SQL script. Corresponded field list was selected in column of field name, operation symbol of if-clause was selected in column of operation symbol, corresponded value was input in column of value. Corresponded connector was selected in column of connector, and inserted and deleted if-clause time after time, until constituted satisfying conditional combination. Discretionary conditional query and searching of contents of data window was realized.