SQL syntax

  
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.
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

Solution
J. wrote:
well, use an advanced query.
 

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



http://www.outsystems.com/help/servicestudio/9.1/index.htm#t=Using_Data%2FAbout_SQL.htm
thanks to all.

Regards,
  Henri B.