How to select data from plsql query with UFT Datatable parametrization. I've connected with plsql. My challenge is: Query = "select AAA From BBB where CCC="XXX" I want to change this "XXX" to UFT datatable parameter. I have tried this: sql = "select AAA From BBB where CCC="Set Datatable("DDD", dtLocalSheet)" " .
Please give me some methods guys..
But How can I get all rows of another sheet?
I have tried like this:
sql="SELECT * FROM A WHERE B IN" & DataTable("C", "D")
myRecord.Open sql, myConnection