SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Feb 2009
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Importing a SQL dataset

    I would like to use a SQL query result set to validate the items in a drop down list. This is a list of offices (200+) that is reconfigured occasionally. I can step through the list and get the office names OK. So, I could compare the name to a name stored in a data sheet, but because the data is not always the same, a result set from a SQL query seems a cleaner option. I did this using winrunner; is there similar functionality in QTP? What I need to do is Select the first item in the drop down, then select the value in the first row of the query dataset - and check to see if they match... I can code most of this, it is the reading a query that I am unsure of.

  2. #2
    Senior Member
    Join Date
    Jul 2007
    Location
    Amman, Jordan
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Importing a SQL dataset

    reading a query? Anyways just like you said, you'll get the data from the drop down list and store them in an array, then you get the expected data from the database and store them in a recordSet object, then store the data from the recordSet into an array. After that compare the arrays.

    Paste the code you can do and we'll help you with the rest.
    _______________________________________________
    1. LR Version: LR 9.5
    2. protocol: Web (HTTP/HTML)
    3. HTML-Advanced with URLs: No
    4. URL mode: N/A
    5. LR FP: N/A
    6. VuGen Recording: New Engine
    7. Web & Multimedia 1700 - Oracle E-Business 100
    8. support/maintenance contract active: yes
    9. Windows 2003 R2
    10. Did not file

  3. #3
    Member
    Join Date
    Oct 2008
    Location
    Cambs, UK
    Posts
    426
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    For an easy to use test automation framework, checkout my website:

    http://www.atomqa.com

  4. #4
    Member
    Join Date
    Feb 2009
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Importing a SQL dataset

    Reading a query - recordset sorry but I was in a hurry. This will work. Thanks.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.71%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:00 AM.

Copyright BetaSoft Inc.