PB Mismatch between retrieve the columns and fetch the columns-CodePudding

PB 9 literally wrote a link SQLERRTEXT will prompt the Mismatch between the retrieve the columns and fetch the columns
I use PB 10 on the same machine with the same procedure is to use the

//Profile ZWGL
The SQLCA. DBMS="O73 ORACLE 7.3"
The SQLCA. LogPass="ZWGL"
The SQLCA. ServerName="jtyy"
The SQLCA. LogId="ZWGL"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="PBCatalogOwner='ZWGL'"

Connect using the SQLCA;

String ls_bmz, ls_js
The Select BMZ, js
Into: ls_bmz, : ls_js
The From wz_yhxx
Where XTXH=29
And yhdm='dbas' using the sqlca;

Ls_bmz=ls_bmz

CodePudding user response:

Whether the data window field types and the actual SQL types? The data window is built first?

CodePudding user response:

PB9 and PB10 data interface is different, the same code is general,

CodePudding user response:

See if your PB itself ODBC writing has a problem, can be directly copy attribute code inside out