SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Member
    Join Date
    Feb 2010
    Posts
    178
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Delete Row from Datatable

    Hi,

    I would like to delete particular row (ex. 3)from the data table. Is it possible ? If yes, please provide how to delete the row ?

    Thanks

  2. #2
    Moderator
    Join Date
    Jul 2005
    Location
    Delhi
    Posts
    15,575
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    7 Thread(s)
    Total Downloaded
    0

    Re: Delete Row from Datatable

    You can't delete the row. You can only change the data, but rows can't be deleted

  3. #3
    Senior Member
    Join Date
    Dec 2006
    Location
    Germany, Dresden
    Posts
    1,536
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Delete Row from Datatable

    [ QUOTE ]
    Hi,

    I would like to delete particular row (ex. 3)from the data table. Is it possible ? If yes, please provide how to delete the row ?

    Thanks

    [/ QUOTE ]

    attention: close the script first!!!

    if you have access to the file system where the script is stored open the script folder \\<your Folder>\<ScriptFolderName>\, backup the default.xls and open the file "default.xls" with Excel, then delete the row you want and save the file again.
    http://qcmt.pc-polis.de

    de omnibus dubitandum

    For all Questions: Please be sure to take a look at the QTP Manual before posting any Questions, thanks for doing this

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

    Re: Delete Row from Datatable


    Thank You, Tarun & rscholoz660.

    If I want to retrieve the values from the datatable for particular column, Is the column name should be in the first row only ?

    If the column name is in the second or third row and the values are under that, Is it possible to get the values for that column ?

  5. #5
    Advanced Member
    Join Date
    May 2006
    Location
    United Kingdom
    Posts
    742
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Delete Row from Datatable

    1. No it is not necessary
    2. Yes
    Explore Datatable's getcurrentrow , Value , SetCurrentrow,SetNextrow,Getrowcount

  6. #6
    Member
    Join Date
    Feb 2010
    Posts
    178
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Delete Row from Datatable

    Hi Krishan,

    Thanks for your comments.

    SetCurrentRow, SetNextRow, Getrowcount all these can be used. But if the column name is not in the first row in the data table, how it recognizes the column name ?

    Please provide one example ??

  7. #7
    Advanced Member
    Join Date
    May 2006
    Location
    United Kingdom
    Posts
    742
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Delete Row from Datatable

    Kindly let me clear your question. What do you mean by column at 2nd row ?

    kindly show attachment. Let me say one thing that you can access anything in datatable irrespective its ordinality but still kindly explain your situation with screenshot so we can able to get better idea.

  8. #8
    Member
    Join Date
    Feb 2010
    Posts
    178
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Delete Row from Datatable

    Hi,
    Please find the attached snapshot for more details.
    I have column name in the third and values are for that from fourth row onwards.

    How do I handle in QTP to retrieve the column name and values.

    Please suggest !!
    Attached Images Attached Images

  9. #9
    Senior Member
    Join Date
    Dec 2006
    Location
    Germany, Dresden
    Posts
    1,536
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Delete Row from Datatable

    and why there is a empty first row in your data table?
    http://qcmt.pc-polis.de

    de omnibus dubitandum

    For all Questions: Please be sure to take a look at the QTP Manual before posting any Questions, thanks for doing this

  10. #10
    Member
    Join Date
    Feb 2010
    Posts
    178
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Delete Row from Datatable

    Please assume that that first row will be there as I mentioned. That is the internal purpose for manual testing.

 

 
Page 1 of 2 12 LastLast

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.34%
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 08:34 AM.

Copyright BetaSoft Inc.