SPONSORS:






User Tag List

Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Dec 2001
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SilkTest crash when using DB_ExecuteSql() with nested table

    I am experiencing a crash when i use DB_ExecuteSql() with the following sql statement:

    select nt.name from table(select mt.attributes from xxx_table where id = '1234') nt;

    Does anyone knows if DB_ExecuteSql() support nested tables sql statements?

    Any help would be great. Thanks.
    Kn

  2. #2
    Senior Member
    Join Date
    Jun 2000
    Location
    Chicago, IL USA
    Posts
    383
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SilkTest crash when using DB_ExecuteSql() with nested table

    The most imporatant variable here is:

    What ODBC driver are you using ?

    ------------------
    Rob Kapteyn
    Rob Kapteyn, CSTE
    RobKapteyn@gmail.com

  3. #3
    Junior Member
    Join Date
    Dec 2001
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SilkTest crash when using DB_ExecuteSql() with nested table

    Oracle

    ------------------

  4. #4
    Senior Member
    Join Date
    Aug 1999
    Location
    Cambridge, UK
    Posts
    470
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SilkTest crash when using DB_ExecuteSql() with nested table

    Stuff to check:
    - does the exact same sql query work when executed through a different query tool (e.g. odbctest).
    - what, if any, error message do you get when silktest executes this query?
    - which build of silktest are you using? There used to be a bug whereby silktest would crash when executing an aggregated sql query, which was fixed by 5.0.3; it is possible that your bug has also been fixed. See http://www.qaforums.com/Forum1/HTML/001569.html for details.

    ------------------


    [This message has been edited by vincebowdren (edited 07-11-2002).]

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin 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 02:22 PM.

Copyright BetaSoft Inc.