Micro Focus QTP (UFT) Forums

In a QTP script the first step is to get a table name from the database
If the query used in the script is executed in DataStudio it returns this value, which is correct : bill_0120150501

But when this code is executed in QTP the value assigned to the the array and variable is bill_0101/0/215

Anyone know how to prevent QTP / VBScript from doing this?

Code:
sql="select 'bill_01'||SUBSTR(bcy_next_run,1,4)||SUBSTR(bcy_next_run,6,2)||SUBSTR(bcy_next_run,9,2) current_bill_table from bcy_billing_cycle where bcy_bill_cycle = '01';"

testd = ExecuteQuery_Eppix(EppixDBUsername,EppixDBPassword,sql,EppixDBName)

current_bill_table= testd(0,0)

Code:
testd = double(ExecuteQuery_Eppix(EppixDBUsername,EppixDBPassword,sql,EppixDBName))

..... try this

Thank you for the reply, but no, that does not work
I need to understand why QTP / VB Script is changing the data in the first place

Odette

babu123

Odette