I am using QTP 11 along with Oracle database. When I am trying to retrieve the value from the database and if there is any 0 present at the end then the value is displayed without 0. For ex: If the value present in database is 5000 the value that is retrieved from QTP is displayed as 5 or if it is 510 the value is displayed as 51.
I am not sure whether any change in the below script might help my issue to get resolved:
i = "0"
QUERY = ""
If Not rs.eof Then
Do Until rs.EOF
FieldNameVal = rs(i)
Ganesh sorry it was actually i =0. While entering in the post made a mistake and entered as i ="0". So actually i am entering it as i = 0 but still i am unable to retrieve the appropriate value from the database.