Microsoft SQL Server on a successful UPDATE doesn't return any bundles and my scenario stops

How To
1

I’m using the Microsoft SQL Server module in my scenario for updating the database. But a strange thing is that after a successful update, the module returns no bundles (there is no response) so the scenario stops and does not execute any further modules in my flow.

Is there any way to force MS SQL Server to return any response after an UPDATE? Or any way to force a bundle after a module is executed?

2

Are you using a query to update?
use after your update query

IF @@ROWCOUNT > 0
PRINT ‘[{“afected_rows”: ‘+ @@ROWCOUNT+’}]’;
ELSE
PRINT ‘No rows’
GO

3 Likes
3

Wow. I didn’t know you could make conditional queries with MS SQL. I found a solution and it’s so simple I’m embarrassed to share. I didn’t notice that there is a toggle “Continue the execution of the route even if the module returns no rows”. You simply just need to switch it on and even if there are no bundles after the update, the scenario goes further.

4 Likes
4

@surmacki Glad you have a solution, if so please mark this questions as solved please.

2 Likes
5

Hello all,

Could you tell how did you manage to connect to your microsoft sql server ?

6

Error : getaddrinfo enotfound

7

Using Microsoft SQL Server module. Probably you have an error in your access credentials.

2 Likes
8

Could you tell me what to put in the HOST name.
The IP ? the server name itself ? or IP.servername ?
I think the error comes from here.

9

The host name is either IP or URL depending on how you configure access to your server.

2 Likes