Do a simple query interface, point button "query", find out the data of a table, SQL statements to find out the data in the background, do it in pb, click on the button, can appear sometimes data, sometimes it shows "no data to query!" According to a few times more, sometimes data will appear again!! Did a lot of such interface, first encountered this kind of circumstance!!!!!
Solving!!!!!!!!!!!!!!!
Appreciate!!!!!!!!!!!!!!

CodePudding user response:

Put your code up

CodePudding user response:

Can sometimes find out sometimes, not a ghost, ha ha you to check whether the database on local or network database, network problems, if it is local, may be there is something wrong with the code, best to stick in the query code,

CodePudding user response:

String SQL

SQL="SELECT RPT_NAME, PM, FZM, SHR, CAR_NO, CAR_POSITION, MATERIEL, the PROVIDER, START_STATION,"
SQL +="RPT_TIME YFLAGTIME, ADDTIME, YPBZ, GROSS_TIME, JLBZ,"
SQL +="DBRQ DZM, TRAIN_FLAG, CC_CHA"
SQL +="FROM TMP_USER. LQZT_WJ_CHEHAO_V s"

The clipboard (SQL)
Dw_1.com monquery (SQL)

This is the query button under the code, the database is not the machine, is the company's Intranet, using pl/SQL query has never been broken

CodePudding user response:

Commonquery ()? What version of PB are you using? With this function
You can try to use the
Dw_1. SetSqlselect (SQL)
Dw_1. Retrieve ()

CodePudding user response:

What is commonquery, never used,
Suggest using dw_1. SetSQLSelect (SQL) try

CodePudding user response:

Commonquery system () this function should do people leave the architecture of the function of the system were written so, didn't find any problem,
Dw_1. SetSQLSelect (SQL) tried to point query have no reaction at all,

CodePudding user response:

Is commonquery (), retrieve () won't have any problem,

CodePudding user response:

Yes, thank you!

CodePudding user response:

This problem I met settransobject (sqlca) and don't forget the oh

CodePudding user response:

references 9 f szxlw1977 response:

this problem I met settransobject (sqlca) and don't forget the oh

The elder brothers, the somebody else all say can sometimes find out, sometimes did not find, can't be settransobject problem (sqlca)
Suggest using retrieve () a try, I always use this, never been like this

CodePudding user response:

Dw_1. Dataobject=dw_1. Dataobject
Statement in the data window, initialize it