New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Using an output value as input to a SQL statement

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Using an output value as input to a SQL statement
Jackomcnabb Offline
Member
***
Posts: 52
Threads: 8
Joined: Dec 2008
Reputation: 0
#2
Not Solved 07-30-2009, 03:30 AM
You can pass a variable to a string then pass that string to the DB Query:
Code:
ZipCode="12345"
sqlstring= "SELECT count(*)  FROM LOCCITY WHERE  LOCCITY.LOCZIPCODESTART LIKE '"&ZipCode&"%' "

Set Rec = CreateObject("ADODB.Recordset")
SQL= ""&sqlstring&" "
Rec.open SQL ,conn

as you can see I'm just getting the count back
Find
Reply


Messages In This Thread
RE: Using an output value as input to a SQL statement - by Jackomcnabb - 07-30-2009, 03:30 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Need to input Japanese Character through UFT Alaguraja 0 908 07-01-2020, 11:32 AM
Last Post: Alaguraja
  How to get input from the user in QTP? shanthiK 10 18,581 08-07-2017, 11:34 PM
Last Post: zunebuggy
  Exe invoked through UFT is unable to access IIS and SQL Server service bkdevise 0 2,155 08-25-2015, 05:49 PM
Last Post: bkdevise
  Output Values error Tasleem 3 3,937 10-27-2014, 02:13 PM
Last Post: Tasleem786
  parameterize Excel Sheet Name in SQL bjitsidhu 0 2,917 07-20-2014, 08:34 AM
Last Post: bjitsidhu

Forum Jump:


Users browsing this thread: 1 Guest(s)