String r_ddh, r_shbz
R_ddh=sle_ddh. Text
If rb_qb. Checked=true then
R_shbz="%"
Dw_ddcx. Retrieve ()
End the if
If rb_ysh. Checked=true then
R_shbz="Y"
Dw_ddcx. Retrieve (r_ddh r_shbz)
End the if
If rb_wsh. Checked=true then
R_shbz="N"
Dw_ddcx. Retrieve (r_ddh r_shbz)
End the if
Above is a according to the order number (DDH), and review marks (SHBZ) query program, but not achieve them, don't know where the problem is the (set) of the parameters, troublesome everybody help ah, thank you!!!!!!

CodePudding user response:

Prompt what mistake? Clear!
Dw_ddcx. Retrieve ()
Dw_ddcx. Retrieve (r_ddh r_shbz)
Dw_ddcx. Retrieve (r_ddh r_shbz)
Able to retrieve the parameter line, and set up? Set up several dw_ddcx. Retrieve () to enter several

CodePudding user response:

Dw_ddcx. Retrieve ()
Dw_ddcx. Retrieve (r_ddh r_shbz)
It must be wrong, look at your data window defines several parameters, then the parameters are consistent

CodePudding user response:

Using fuzzy query, conditions like to be used in the data window

CodePudding user response:

String r_ddh, r_shbz
R_ddh=sle_ddh. Text
If rb_qb. Checked=true then
R_shbz="%"
Dw_ddcx. Retrieve (%, %) of DDH,//the data window SHBZ condition to use like
End the if
If rb_ysh. Checked=true then
R_shbz="Y"
Dw_ddcx. Retrieve (r_ddh r_shbz)
End the if
If rb_wsh. Checked=true then
R_shbz="N"
Dw_ddcx. Retrieve (r_ddh r_shbz)
end if

CodePudding user response:

Set up two parameters, according to the order number, and audit marks (has not audit, audit, all) query

CodePudding user response:

Parameters of the query, the inside of the parameters to write

If is fuzzy query, data in the data source window parameter is set to use like

CodePudding user response:

The key is the operator in the where clause for the data window can be like to pick