Developer forum

Forum » Development » Stored Procedures and Data Lists

Stored Procedures and Data Lists

E-mail notifications
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply
Posted on 04/11/2022 13:19:56

Hi,

 

(Not sure if the right category) We have a stored procedure that runs perfectly in SQL Firehose, but Data lists does not return anything.

 

The stored procedure is creating some temp tables, and I wonder if that has anything to do with it. At least in Firehose we get the warning of the number of records being affected (populating the temp tables I would assume) - I am attaching the sp in case you want to take a look at it.

 

Is this a known limitation?

 

Best Regards,

Nuno Aguiar


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 07/11/2022 10:41:24
Reply

Data lists has never been tested with store procedures, so it is an unknown limitation. Or something might be wrong with the SP.

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Posted on 07/11/2022 12:47:13
Reply

Hi Nicolai,

 

We figured it out. We changed the stored procedure NOT to work with a temp table. For some reason Data Lists does not like those. 

 

Thanks anyway,

Nuno Aguiar

 

You must be logged in to post in the forum