Idea - SQL Advanced Without Output Structure Mandatory

SQL Advanced Without Output Structure Mandatory

New

Database

I would like to be able to execute SQL commands with Advanced SQL without having to define an output structure for that component.

I believe that the entire community would benefit from this, to be able to execute commands in the database when necessary, without the need to assign dummy structures and create unnecessary logic in SQL.

28 Sep 2023

Daniël Kuhlmann

MVP

Hi Luiz,

The better tool to use for those tasks is:

https://www.outsystems.com/forge/component-overview/5900/sql-sandbox

Regards,

Daniel

02 Oct 2023

Sebastian Krempel

Champion

Hi Luiz,

For testing things out, I also like the tool @Daniel Kuhlmann recommended as it's way more flexible.

Nevertheless, I support your idea for advanced SQL when it comes to statements that do not produce a return value (e.g. bulk deletions or updates). As a workaroud for the meantime, I simply add one of the effected entities as output structure in these cases. This works fine as long as the statement will never produce a single result line.

Regards,
Sebastian

10 Oct 2023