String expr_1
//expr_1="select operator_id operator_name, operator_password, operator_zb, operator_online from jxy where operator_zb='managers' order by operator_id desc"
//expr_1="select id, name, sex, yyh, yysj from lr"//where id & gt;=24 "
Expr_1="select * from lr the where the name like '%" + "zhang SAN %'"
String ls_present ls_syntax, ls_err
Ls_present='style (type=grid)'
Ls_syntax=SQLCA. SyntaxFromSQL (expr_1 ls_present, ls_err)
Dw_1. Create (ls_syntax ls_err)
Dw_1. SetTransobject (sqlca)
Dw_1. Retrieve ()

CodePudding user response:

Expr_1 the three sentences, which are not, depressed ah

CodePudding user response:

Ls_err all take a look at ah

CodePudding user response:

To lock the first update SetRedraw (false)
After retrieval to unlock update SetRedraw (true)

CodePudding user response:

String expr_1
//expr_1="select operator_id operator_name, operator_password, operator_zb, operator_online from jxy where operator_zb='managers' order by operator_id desc"
//expr_1="select id, name, sex, yyh, yysj from lr"//where id & gt;=24 "
Expr_1="select * from lr the where the name like '%" + "zhang SAN %'"
String ls_present ls_syntax, ls_err
Ls_present='style (type=grid)'
Ls_syntax=SQLCA. SyntaxFromSQL (expr_1 ls_present, ls_err)
Dw_1. Create (ls_syntax ls_err)
dw_1. SetRedrwa (False)
Dw_1. SetTransobject (sqlca)
Dw_1. Retrieve ()
dw_1. SetRedrwa (True)

CodePudding user response:

After the test, did not find problems
You can run smoothly

String expr_1
String ls_present ls_syntax, ls_err
Expr_1="select * from ref_ge_code"
Ls_present='style (type=grid)'
Ls_syntax=SQLCA. SyntaxFromSQL (expr_1 ls_present, ls_err)
Dw_1. Create (ls_syntax ls_err)
Dw_1. SetTransobject (sqlca)
Dw_1. Retrieve ()