New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE
Highlighted
Captain
Captain
368 views

UFT with PLSQL query

Jump to solution

Hi all 

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..

0 Likes
1 Solution

Accepted Solutions
Highlighted
Knowledge Partner Knowledge Partner
Knowledge Partner

Try Something Like:

sql = "select AAA From BBB where CCC= " & Datatable("DDD", dtLocalSheet)

Mark Smith.

View solution in original post

3 Replies
Highlighted
Knowledge Partner Knowledge Partner
Knowledge Partner

Try Something Like:

sql = "select AAA From BBB where CCC= " & Datatable("DDD", dtLocalSheet)

Mark Smith.

View solution in original post

Highlighted
Captain
Captain

Thank you man, I'll try it

0 Likes
Highlighted
Captain
Captain

HELLO AGAIN

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

help me.

thank you

 

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.