Forum Discussion

rrkon99's avatar
rrkon99
New Member
11 years ago

TestComplete: Connected to database but only able to access to some tables

hi,





The datatbase is oracle. I was able to access database. I was also able to run a small query_A from Table_A (Query_A ).



Query_A: select * from Table_A where rownum < 2.



Query_A runs correctly retrieves the data- NO ISSUE.



Issue:

When I tried to connect to another table Table_B, it is not able to connect. It is getting blocked at  rs.MoveFirst() (rs is resultSet object) .

Query_B: select * from Table_B where rownum < 2.





output :  undefined



I did enable to log: Log.CallStackSettings.EnableStackOnError = true;





Thanks in adv.


RK

 

  • Ravik's avatar
    Ravik
    Super Contributor
    11 years ago
    Hi rrao,





    Might be there is no record in Table_B for the given query.

    try to execute your query manually and check whether its return any result or not.



    Support your query does not return result at that time (RecordSet.MoveFirst)

    statement thronging errors because of there is no records.







  • Colin_McCrae's avatar
    Colin_McCrae
    Community Hero
    11 years ago
    Sounds about right.



    You can check - Recordset.EOF - straight after you run the query.



    If that is true, your query returned an empty recordset.