Forum Discussion

anand1's avatar
anand1
Contributor
5 years ago

Dynamic query, temp table, insert select

Hi, 

 

I went thru this older post

https://community.smartbear.com/t5/SoapUI-Pro/Stored-Proc-DYNAMIC-SQL-returns-no-rows/td-p/42621

 

And i also have the similar problem, I am creating a temp table, inserting the data using a SP and then doing some select based on my criteria

I am using JDBC test step in my test case to execute this, whenever I am executing it, I am not getting any error, instead i m getting 

<Results>
<UpdateCount>0</UpdateCount>
</Results>

 

Although, I expect the output of my Select query which is my last statement.

I can see it use to be a bug in earlier version.

Not sure if that is still an issue, or am I missing something.

 

Thanks in advance.

P.S: It is working fine if I am executing the same in SSMS(Sql Server Management Studio)

 

Regards,

Andy

3 Replies

Sort By
  • hina's avatar
    hina
    Contributor
    2 months ago
    Copy Link

    Hi Hassan,

    Thank you for your reply. [NumAsterisk] worked!! But I have opened a support ticket to get this fixed. I have couple of test cases using *, it's going to be an effort to update all of them.

    • Hassan_Ballan's avatar
      Hassan_Ballan
      Icon for Champion Level 1 rankChampion Level 1
      2 months ago
      Copy Link

      Hi Hina,

      You did the right thing to contact support and report it, it should still work as it was working before and the more reporting the higher attention it will get.

      The way I would like to use the "Keys" method is the same as user would use the keyboard, and for the user to type * user would use Shift+8 key combination, and to simulate that try out !8, I would think it should also work as a work around.

  • richie's avatar
    richie
    Community Hero
    5 years ago
    Copy Link
    Hey anand1,

    I dunno if i can help, but i'll try and reproduce the issue on my readyapi!/sqlserver instance.

    Im using readyapi! v3.3.0, what version are you using? Im gonna assume its not a driver problem cos you say it works using groovy, but not the embedded functionality, right?

    Can you attach the storedproc so i get a feel for what its doing? I'll try and build an sp on my instance replicating the basics of your sp.

    Nice one,

    Rich