PB环境下通用动态多表查询的实现

Implement of universal dynamic multi-table query under PowerBuilder condition

为在PowerBuilder环境下实现通用动态多表查询 ,从数据库结构设计、界面设计、多表查询方法 3个方面进行了论述。运用此方法可满足以任意组合方式对水利规划计划项目进行检索查询的要求。介绍了利用缓冲区之间的数据移动从复合表得到符合条件单表的思路。

For implementing universal dynamic multi-table query under the PowerBuilder condition, three aspects, i.e., the data base structure design, the interface design and multi-table query method, are discussed in the paper. The method can meet the retrieval query requirement for hydraulic planning, design items through arbitrary composite ways. The train of thought for getting suitable single tables from composite table by use of the data moving between two buffer regions is introduced.