New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
how to pass an integer array variable in a query

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
how to pass an integer array variable in a query
ravi.gajul Offline
Moderator
*****
Posts: 257
Threads: 10
Joined: Oct 2011
Reputation: 2
#2
Not Solved 10-28-2011, 01:44 PM (This post was last modified: 10-28-2011, 01:48 PM by ravi.gajul.)
Looks like there is no syntax error as a Similar query in same format works fine for me
anyways try this

Code:
sqlquery="SELECT CMPGN_DIM_ID FROM STENCPS01.UDWHIT.CPS_ADVRTSNG_CMPGN_FACT where ADVRTSR_BRAND_DIM_ID in ("&array1(i)&")"
Set rs= gDBConnection.execute (sqlquery)


Regards,
Ravi
Find
Reply


Messages In This Thread
RE: how to pass an integer array variable in a query - by ravi.gajul - 10-28-2011, 01:44 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Convert the single to an integer Mozza 2 1,408 09-27-2018, 12:36 PM
Last Post: Ankur
  Pass reference to datatable into function smallsteve 2 2,068 09-28-2017, 09:18 PM
Last Post: smallsteve
  Can you please help me in QTP DP to pass the variable name anshika.agarwal 1 2,741 09-04-2014, 06:43 PM
Last Post: anshika.agarwal
Rolleyes Browse object query Hema a newbie 0 1,800 07-22-2014, 08:37 PM
Last Post: Hema a newbie
  SQL Query Issue in QTP rajiv.qtp 1 2,475 11-28-2013, 10:36 AM
Last Post: Jay

Forum Jump:


Users browsing this thread: 2 Guest(s)