Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
QTP Database conenction and parameterization of the values
#24
Solved: 11 Years, 4 Months ago
I have removed

this is my modified script
still it is showing me as americas only whe n i catch the meaning it is nto showing me the next meanin g







Code:
Set conn=CreateObject("ADODB.Connection")
                                      conn.Open("DRIVER={Oracle in OraHome92};SERVER=DEVMITG;UID=ITL_ASSET;PWD=ITL_ASSET;DBQ=DEVMITG")

           Set rs = CreateObject("ADODB.recordset")
           sql = "Select Code, Meaning From TB_AMS052_Codes Where Code_Nam = 'Pole' "

                      rs.Open sql,conn
  
                             Recordcount = rs.Recordcount

                                                            While(NOT Rs.EOF)
                                                            Msgbox rs.Fields("Meaning")
                                                            For i=1 to Recordcount

                                                                rs.MoveNext


                                                                

                                                            Next
                                                            Wend

                                                            rs.Close
                                                            conn.Close
Reply


Messages In This Thread
RE: QTP Database conenction and parameterization of the values - by siri - 07-25-2008, 03:59 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Action Parameterization Issue Slothman 1 1,970 10-31-2020, 01:05 PM
Last Post: Ankur
  Business Components Parameterization YogeshCallappa 0 1,628 06-07-2017, 04:32 PM
Last Post: YogeshCallappa
  Parameterization Hanskanika 0 1,650 11-20-2015, 04:45 PM
Last Post: Hanskanika
  QTP database seach siitohan 1 2,564 02-19-2013, 07:07 AM
Last Post: basanth27
  QTP 11.5 PARAMETERIZATION ERROR QTP(UFT)11.50 mseroney88 2 3,652 01-22-2013, 10:51 AM
Last Post: mseroney88

Forum Jump:


Users browsing this thread: 14 Guest(s)