Using pb database management tools, execute the SELECT f_jfje directly, f_dfje,,,, can be retrieved records, but with the following code, but not retrieved records, prompt cursor is not open, please help, thank you!

The sqlca. DBParm="CursorUpdate=1"

Ls_sql="SELECT f_jfje f_dfje, f_rq, f_zy, f_zph, f_pzbh, f_no, f_dzbz FROM t_mxzh" + ls_year + & amp;
"WHERE f_kmbm='" + ls_dzkm +"' "+ & amp;
"AND f_rq & lt;='" + ls_tqrq + "' "+ & amp;
"And f_jllx='1'" + & amp;
"And f_dzbz='0'" + & amp;
"The ORDER BY f_dzbz ASC, f_kmbm ASC, f_rq ASC, f_no ASC"

DECLARE c101 DYNAMIC CURSOR FOR SQLSA;
PREPARE SQLSA FROM: ls_sql;

The OPEN DYNAMIC c101;

Lab1:
The fetch c101 into: ld_qy_jfje, ld_qy_dfje, : ls_mxrq ls_zy, : ls_zph, : ls_pzbh, ll_no, : ls_dzbz;

If the sqlca. Sqlcode=0 then
,,,,,,,

Goto lab1
End the if
The close c101.

CodePudding user response:

Wire for help: paid help do a simple thing,
Topic: MES production statistics and data export excuse development

The contents and requirements:
Understand MES principle and production statistics and analysis, the significance of design and development of a generic production statistics software, can according to the definition of data
Generate required format of the statistics, and has the function of export statistics data in EXCEL format and writing papers,

Two main technical indicators:

1) to develop a generic report generation software.
2) have the function of the export EXCEL format data;
3) complete thesis;

Three plans:
1) familiar with MES principle, database principle and the design of the database report
2) familiar with PB software with the use of SQL SERVER2000
3) the development of production statistics
4) the development of export data interface
5) of the authors of the paper, the test outline writing,

Four is expected to complete the work:
Paper 25 pages; 1 software module; Test outline 2 pages; Report 5

Five system software and support software:
WINDOWS 2000. PB; SQL SERVER2000,
If you have good friend can do, please contact me, I give corresponding compensation, be urgent!!!!!! Thank you
Mobile: 13851647282
E-MAIL:[email protected]
QQ: 121995805

CodePudding user response:

Confirm the correctness of the program database connection, is properly connected to the database

CodePudding user response:

guanzhu