General Query Module Based on PB
Zhihong Liu · Ordnance Industry Automation · 2004
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.