Skip to Content (Press Enter)
UserImage.jpg
Henri Baar
124Views
3Comments
Solved
SQL syntax
Question
Hi,

Is there a way to simply send SQL syntax to the DB?
I would like to do something like "delete from CUSTOMERS where CUST_ZIP like "12"

Regards,
  Henri B.
0
0
12 Apr 2016
Copy Link
2016-04-21 20-09-55
J.
 
MVP
Solution
well, use an advanced query.

DELETE FROM {CUSTOMERS} WHERE {CUSTOMERS}.[CUST_ZIP] LIKE '12'

if you want 12 be a variable, ad an input-parameters like Zip, and depending how you want to solve it, expand-inline or not..

with a like you probably do want expand inline, otherwise a simple one is the way

0
0
12 Apr 2016
Copy Link
2018-11-23 09-43-46
Carlos Henriques
J. wrote:
well, use an advanced query.
 

"old school" :P
Since version 9 it's just called "SQL" widget:



https://www.outsystems.com/help/servicestudio/9.1/index.htm#t=Using_Data%2FAbout_SQL.htm
0
0
12 Apr 2016
Copy Link
UserImage.jpg
Henri Baar
thanks to all.

Regards,
  Henri B.
0
0
12 Apr 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.