pb 如何查找比较消耗时间的代码
发布网友
发布时间：2022-04-20 21:38
共1个回答
热心网友
时间：2023-07-21 20:32
（1）DeclareInstance Variables——Declare ——Instance Variables
//声明实例变量string is_sql
（2）窗体加载事件：w_query——open()事件中
//数据窗口dw设置连接事务sqlcadw_query.settransobject(sqlca)//让数据窗口控件从库中提取数据//dw_query.retrieve()//得到原始语法，为检索做准备is_sql = dw_query.getsqlselect()
3）查询cb_query——Clicked()事件：
string ls_start,ls_end ,ls_select
string ls_left ,ls_right//得到开始和结束时间ls_start = em_start.textls_end = em_end.textls_select = ''// 开始时间if not isnull(ls_start) and ls_start <> "" and lower(ls_start) <> 'none' then
ls_select = ls_select + " convert(char(10),抵店时间,120) >= '" + ls_start + "'"end if// 结束时间if not isnull(ls_end) and ls_end <> "" and lower(ls_end) <> 'none' thenif ls_select = "" then
ls_select = " convert(char(10),抵店时间,120) <= '" + ls_end + "'"
else
ls_select = ls_select + " AND convert(char(10),抵店时间,120) <= '" + ls_end + "' "
end ifend if拼SQL语句
ls_select = is_sql + ' where ' + ls_selectif ls_select <> '' then//赋值SQL语句
dw_query.setsqlselect(ls_select)
end ifdw_query.retrieve() //检索数据
