Available query,support many tables with parameters.
Only need to post one parameter(datawindow), then you can free.
To use this function,you should call function:
gf_set_query(datawindow ad_dw)
ad_dw : The main datawindow that you want to be queried.
query.pbl : Query with parameters,must define a event(ue_retrieve) in datawindow
to execute the retrieve function with(without) parameters.
This function use the transaction sqlca twice.
rule: The column that be queried must be visible,
and the datawindow must have a text control named after 'column_t'.
object:
dw_jzh_query : Query datawindow.
gf_add_where : Add where for the datawindow.
gf_set_query : Query (main function).
w_jzh_query : Query window (main window).
Maybe you want to post a specific window for some usage,
such as retain the query conditions,you can do it youself,
or,you can ask me for help.
//v.2.1
//jzh(jzhaohua@263.net) 2002/05/04 04:02
=============================================================
通用查询,支持多表关联、带参数
只需要传递一个参数datawindow,剩下的一切交给这个函数去完成,看看她功能的强大吧
使用此功能调用方法:
gf_set_query(datawindow add_dw)
ad_dw : 被查询数据窗
query.pbl : 可带参数查询,必须在被查询数据窗上定义一个事件 ue_retrieve,
来执行 retrieve 函数(带参数或不带参数)
本功能使用sqlca事务对象两次
规则 : 被查询列必须是可视的,并且该数据窗必须有一个以 '列名_t' 命名的text控件
对象 :
dw_jzh_query : 查询数据窗
gf_add_where : 为数据窗添加 where 语句
gf_set_query : 查询函数
w_jzh_query : 查询窗口
如果你想保存上次的查询条件,可以传递一个窗口,你可以自己来做,也可以找我帮忙.
//版本.2.1
//jzh(jzhaohua@263.net) 2002/05/04 04:02
- 1
- 2
- 3
- 4
- 5
前往页