Skip to Content (Press Enter)
UserImage.jpg
XiaoDong Zhu
58Views
1Comments
I use update,insert,delete sql excute successfully,but the return result is 0,why?
Question

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

0
0
23 Apr 2020
Copy Link
2020-03-01 17-52-33
Nikhil Gaur

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

0
0
23 Apr 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.