SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Sep 2004
    Location
    India
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    DB Tester Function with Excel Sheet

    Hi,

    when i try to access the MS Access using DB_Tester functions,its working fine,
    But when i do the same for excel sheet,it's not recoginising the Sheet Name.
    The following are the code i used to access the Excel Sheet.

    [-] testcase GetData() appstate none
    [ ] HANDLE hDB
    [ ] HANDLE hSQL
    [ ] INTEGER i
    [ ] hDB=DB_Connect("dsn=DSNTry")
    [ ] hSQL=DB_ExecuteSQL (hDB,"SELECT Operand1 from Calc where Operator='+'")
    [-] while DB_FetchNext(hSQL,i)
    [ ] print(i)
    [ ] DB_FinishSql(hSQL)
    [ ]
    [ ] DB_Disconnect(hDB)
    Here 'Calc' is the Excel Sheet Name and Operand1 and Operator are the Column Name..
    SilkTest is not recognising the 'Calc' Spreadsheet Name.
    Kindly let me know what has to be done to get it worked.

    Regards
    Amirtharaj

  2. #2
    Senior Member
    Join Date
    Feb 2003
    Location
    Romania
    Posts
    163
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: DB Tester Function with Excel Sheet

    Hi Amirthraj,

    You must define the table Calc in a SheetName of Excel file:
    select all line and columns of table, Insert/Name/Define
    and type the name Calc (Add, Ok).
    May be the same name for the Sheet.

    With Regards,

    nelumoldovan49,

  3. #3
    Junior Member
    Join Date
    Sep 2004
    Location
    India
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: DB Tester Function with Excel Sheet

    Thanks a lot man...
    I was really working hard to resolve it.
    Thank you once again.

 

 

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 11.54%
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:38 AM.

Copyright BetaSoft Inc.