使用ODBC和PB数据窗口实现通用查询

IMPLEMENTATION OF A UNIVERSAL QUERY MODULE WITH ODBC AND DATAWINDOW

查询是数据库管理应用系统中很重要的功能。提出了一种在PB9.0下实现的按任意数据表、任意字段、任意指定条件进行查询的技术。该技术主要采用ODBC API编程和动态数据窗口技术,实现的查询模块灵活性和通用性强,且很容易挂接到其他PB应用软件中,提高了代码的可复用性和软件的开发效率。

Query is an important function in database management system. The paper provides a technology which can do combination query by arbitrary table, arbitrary field and arbitrary query condition. The query module with ODBC API and datawindow is flexible and universal, which can be integrated in any PB application system. As a result,it has aided in code re-usability, and advanced development efficiency software.