WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Latest posts

latest posts

In reply to: Damian Kryński

Hi,

I hope they will fix this "bug" anyway -> the action using the additional database connection is executed outside the transaction -> so it does not use the data changed during the action. To use the data, it must be previously saved in the database -> so the CTE action must be executed on subsequent steps.

I believe there won’t be any changes to this functionality.
According to the help documentation in WEBCON BPS Designer Studio, such queries are not supported due to the way they are wrapped.
Additionally, the official online documentation confirms that the WITH syntax is not supported:
https://docs.webcon.com/docs/2025R2/Studio/ConnectionsAndDataSource/DataSources/DataSource_MSSQL#12-sql-query

It appears that the fact it worked previously was more of a feature, and in future versions, even potential workarounds may no longer be effective.

In reply to: Maksymilian Stachowiak

Glad it's solved, I won't add a ticket then, semicolons are statement terminators in SQL so the behavior seems logical with that added to the context.
Error message isn't pretty, and explaining unfortunately.

Hi,

I hope they will fix this "bug" anyway -> the action using the additional database connection is executed outside the transaction -> so it does not use the data changed during the action. To use the data, it must be previously saved in the database -> so the CTE action must be executed on subsequent steps.

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings