A data window made parameter array, the first parameter to the array, the data window can be taken to the data, when the content of an array parameter change, cannot take the data, the data window tracking to statements directly under PB can apply to the data, again will I reopen the window is closed, the data window with the same parameters and can get to the data?
You look is what reason, thank you!

CodePudding user response:

Write SQLPreview event

 if request=PreviewFunctionRetrieve! And sqltype=PreviewSelect! Then 
Messagebox (' ', sqlsyntax) 
End the if 

Look, when performing the retrieve didn't get to the data, execute the SQL statement

CodePudding user response:

Didn't get to the data, I use the Statement Tracer for Oracle track to statements can query to the data
Window opens, if the array parameters don't change, the data window can be taken to the data, if the parameter changed, we won't be able to take a data, the data window actually conform to the data table, if turn off the window to restart, can take to the data

CodePudding user response:

Since can track to the statement, the under several circumstances of SQL replication in contrast to bai, look at your incoming parameters have what problem,

CodePudding user response:

Recompile the datawindow try

CodePudding user response:

See if the parameter changes, query operation to perform,

CodePudding user response:

//to take to the data statement
SELECT DISTINCT
"DIALYSE_ORDERS". "ORDER_CODE",
"DIALYSE_ORDERS". "ORDER_TEXT",
"DIALYSE_ORDERS". "ORDER_SPEC",
"DIALYSE_ORDERS". "ORDER_CLASS",
Decode (" DIALYSE_ORDERS ". "PACKAGE_UNITS", null, ", "DIALYSE_ORDERS". "PACKAGE_UNITS"),
Decode (" DIALYSE_ORDERS ". "the AMOUNT", null, 0, "DIALYSE_ORDERS". "the AMOUNT"),
"DIALYSE_ORDERS". "DOSAGE,"
Decode (" DIALYSE_ORDERS ". "DOSAGE_UNITS", null, ", "DIALYSE_ORDERS". "DOSAGE_UNITS"),
Decode (" DIALYSE_ORDERS ". "the ADMINISTRATION", null, ", "DIALYSE_ORDERS". "the ADMINISTRATION"),
Decode (" DIALYSE_ORDERS ". "FREQUENCY", null, ", "DIALYSE_ORDERS". "FREQUENCY"),

"DIALYSE_ORDERS". "PERFORMED_BY",
"DIALYSE_BILL_ITEMS". "earlier,"
"DRUG_DICT". "TOXI_PROPERTY", "DIALYSE_ORDERS". "ORDER_NO", "DIALYSE_ORDERS". "ORDER_SUB_NO", "DIALYSE_ORDERS". "PRESCNO"
FROM "DIALYSE_ORDERS DIALYSE_BILL_ITEMS", ", "
"DRUG_DICT
"The WHERE (" DIALYSE_ORDERS ". "DIALYSE_ID"='02703200') AND
(" DIALYSE_ORDERS ". "DIALYSE_VISIT_ID"=1) AND
(" DIALYSE_ORDERS ". "DIALYSE_NO"=2) AND
(" DIALYSE_ORDERS ". "PRESCNO" in (1, 1)) AND
(" DIALYSE_ORDERS ". "ORDER_CLASS"='A') and
(" DIALYSE_ORDERS ". "DIALYSE_ID"="DIALYSE_BILL_ITEMS". "DIALYSE_ID") AND
(" DIALYSE_ORDERS ". "DIALYSE_VISIT_ID"="DIALYSE_BILL_ITEMS". "DIALYSE_VISIT_ID") AND
(" DIALYSE_ORDERS ". "DIALYSE_NO"="DIALYSE_BILL_ITEMS". "DIALYSE_NO") AND
(" DIALYSE_ORDERS ". "ORDER_NO"="DIALYSE_BILL_ITEMS". "RELATED_ORDER_NO") AND
(" DIALYSE_ORDERS ". "ORDER_SUB_NO"="DIALYSE_BILL_ITEMS". "RELATED_ORDER_SUB_NO") AND
(DIALYSE_ORDERS. ORDER_code=drug_dict. Drug_code (+))
;


//can't take data statement
SELECT DISTINCT
"DIALYSE_ORDERS". "ORDER_CODE",
"DIALYSE_ORDERS". "ORDER_TEXT",
"DIALYSE_ORDERS". "ORDER_SPEC",
"DIALYSE_ORDERS". "ORDER_CLASS",
Decode (" DIALYSE_ORDERS ". "PACKAGE_UNITS", null, ", "DIALYSE_ORDERS". "PACKAGE_UNITS"),
Decode (" DIALYSE_ORDERS ". "the AMOUNT", null, 0, "DIALYSE_ORDERS". "the AMOUNT"),
"DIALYSE_ORDERS". "DOSAGE,"
Decode (" DIALYSE_ORDERS ". "DOSAGE_UNITS", null, ", "DIALYSE_ORDERS". "DOSAGE_UNITS"),
Decode (" DIALYSE_ORDERS ". "the ADMINISTRATION", null, ", "DIALYSE_ORDERS". "the ADMINISTRATION"),
Decode (" DIALYSE_ORDERS ". "FREQUENCY", null, ", "DIALYSE_ORDERS". "FREQUENCY"),

"DIALYSE_ORDERS". "PERFORMED_BY",
"DIALYSE_BILL_ITEMS". "earlier,"
"DRUG_DICT". "TOXI_PROPERTY", "DIALYSE_ORDERS". "ORDER_NO", "DIALYSE_ORDERS". "ORDER_SUB_NO", "DIALYSE_ORDERS". "PRESCNO"
FROM "DIALYSE_ORDERS DIALYSE_BILL_ITEMS", ", "
"DRUG_DICT
"The WHERE (" DIALYSE_ORDERS ". "DIALYSE_ID"='02703200') AND
(" DIALYSE_ORDERS ". "DIALYSE_VISIT_ID"=1) AND
(" DIALYSE_ORDERS ". "DIALYSE_NO"=2) AND
(" DIALYSE_ORDERS ". "PRESCNO" in (2)) AND
(" DIALYSE_ORDERS ". "ORDER_CLASS"='A') and
(" DIALYSE_ORDERS ". "DIALYSE_ID"="DIALYSE_BILL_ITEMS". "DIALYSE_ID") AND
(" DIALYSE_ORDERS ". "DIALYSE_VISIT_ID"="DIALYSE_BILL_ITEMS". "DIALYSE_VISIT_ID") AND
(" DIALYSE_ORDERS ". "DIALYSE_NO"="DIALYSE_BILL_ITEMS". "DIALYSE_NO") AND
(" DIALYSE_ORDERS ". "ORDER_NO"="DIALYSE_BILL_ITEMS". "RELATED_ORDER_NO") AND
(" DIALYSE_ORDERS ". "ORDER_SUB_NO"="DIALYSE_BILL_ITEMS". "RELATED_ORDER_SUB_NO") AND
(DIALYSE_ORDERS. ORDER_code=drug_dict. Drug_code (+))
;

CodePudding user response:

Two statements with PB data query can be taken directly to the

It is no use data window to recompile

CodePudding user response:

(" DIALYSE_ORDERS ". "PRESCNO" in (1, 1)) AND

(" DIALYSE_ORDERS ". "PRESCNO" in (2)) AND
See whether these two problems,