Ask a Question

Checkpoints on recordsets with multiple tables

SOLVED
DanH
Contributor

Checkpoints on recordsets with multiple tables

Hello,

 

I have a problem testing the data returned by a SQL stored procedure.

 

I have set up DBTables for stored procedures which return a single table with no problem; however, I need to check a number of stored procedures which return multiple tables.  I can't find any obvious way to do this in TestComplete.  When I set up a DBTable  to run the stored procedure, only the first of the tables in the recordset is saved.

 

Would the best way to procede be to run the stored procedure and then create a DBTable for each table in the recordset returned?  Any ideas on the best way to achieve this would be gratefully received.

1 ACCEPTED SOLUTION

Accepted Solutions
Marsha_R
Community Hero

Re: Checkpoints on recordsets with multiple tables

I'd have to guess!  If it were me, I'd probably do what @DanH came up with and do a DBTable for each table.  There might be a slicker way to do it but sometimes I just do the first thing that will let me move on.


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame

View solution in original post

4 REPLIES 4
sonya_m
Community Manager

Re: Checkpoints on recordsets with multiple tables

Let's see if the Community can help!

 

@BenoitB @Marsha_R @cunderw @Reshail , any suggestions here?🙂


Sonya Mihaljova
Community and Education Specialist

Marsha_R
Community Hero

Re: Checkpoints on recordsets with multiple tables

I'd have to guess!  If it were me, I'd probably do what @DanH came up with and do a DBTable for each table.  There might be a slicker way to do it but sometimes I just do the first thing that will let me move on.


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame

View solution in original post

sonya_m
Community Manager

Re: Checkpoints on recordsets with multiple tables

This is definitely a start Marsha, thank you. 

@DanH , how is your progress on this? 


Sonya Mihaljova
Community and Education Specialist

DanH
Contributor

Re: Checkpoints on recordsets with multiple tables

Thanks for the replies.  I mainly wanted to make sure I wasn't missing something obvious.

cancel
Showing results for 
Search instead for 
Did you mean: