This view allows you to edit the attributes of a SQL method.
Note: If you change the ID of your DB Connection object, all the Z SQL Methods using this connection object will NOT be updated. You have to update all Methods one by one.
title:string="No title!", where
title is the
string is the type of the attribute, and
title!" is the default value.
Text area that specifies the SQL query that will execute when
this method is called. The query template can contain DTML
markup to tailor the SQL statement to the arguments. There are
three additional DTML tags called
SQLGROUP. Please refer to their references get more details on
how to use them in your SQL statement.
Note: the SQL statement need not be a
SELECT query, it may
be any valid SQL statement including an INSERT or UPDATE.
Important: You can have several SQL statements in one ZSQL Method.