I use update,insert,delete sql excute successfully,but the return result is 0,why?

I use update,insert,delete sql excute successfully,but the return result is 0,why?The outSystem vision is outSystem11.

Hi XiaoDong,

For insert, update & delete nothing will be returned. The output parameter need to be select because SQL tool need an output parameter to work. Otherwise it will give error.

Results are returned only in case of select query.

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/SQL_Queries