0
 Followers
10
 Likes

Allow primitive types as Output for Advanced SQL

Aggregates & Queries
New

If I have an SQL like this:

select count(*) from Users

I want an output parameter of INT, I do not want to have to create a stucture with one int attribute to get the value from my SQL.

Created on 7 Nov 2018
Comments (5)

Agreed, that would be useful.

Also allow no outputs. For example when using an update or delete query


eg 

Delete from {entity}

Currently requires an output defined even though it won't return one.

Yes!

Changed the category to Aggregates & Queries


The Update, Insert or Delete advanced queries accept any structure when the output must be an integer with the number of rows insert, updated or deleted. If execute any of these queries on SQL it return the number of rows affected.

views
161
Followers
0