Results 1 to 4 of 4
  1. #1

    complex query execution


    I want to know whther winner can handle complex database queries. Iam facing a problem when I execute complex quries.
    The version of winrunner that Iam using is winrunner 8.0.

    First, when I tried to execute a
    complex query : query which involved selection of data from three different tables ( eg: select item.a , item.b , item.c from table1 a, table2 b, table3 c where...) I get an error. The error code is -1. I put this complex query in a variable and execute it using db_execute_query statement.
    But, when I execute a query which involes selection between two different tables Iam able to execute it sucessfully. I use the same approach as before, I send the query in a variable and execute it using db_execute_query statement.
    Can anybody help me in what could be the problem. Is it that winrunner cannot handle complex queries between more than two tables?
    Kindly enlighten me.

  2. #2

    Re: complex query execution

    WinRunner doesn't "handle" database queries at all - it just passes them to the DB engine.

    So if yours is failing, there is a problem with the query as constructed.

  3. #3
    SQA Knight
    Join Date
    Jun 2002
    Cupertino, CA, USA

    Re: complex query execution

    WinRunner can handle anything ODBC can handle. Try db_get_last_error to see what the problem is.

  4. #4

    Re: complex query execution

    Does the query work in the database,
    say TOAD or SQL*plus, or the one that comes with MS ACCESS or SQL SERVER's Query Analyzer ???



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 07:19 PM.

Copyright BetaSoft Inc.