{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section:description|text=}{sub-section}\\
{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Constants Summary{th}{tr}{tbody}{tr}{td}[Number]{td}{td}[#DELETE_ACTION]
Constant for the "delete" SQL action.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#INSERT_ACTION]
Constant for the "insert" SQL action.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#NO_ACTION]
Constant expressing that no SQL action took place.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#SELECT_ACTION]
Constant for the "select" SQL action.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#UPDATE_ACTION]
Constant for the "update" SQL action.{td}{tr}{tbody}{table}\\
{table:id=constant|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=DELETE_ACTION|class=node}{tr:id=name}{td}h6.DELETE_ACTION{td}{tr}{tr:id=des}{td}{sub-section:DELETE_ACTION_des|trigger=button|text=}{sub-section}{sub-section:DELETE_ACTION_des|trigger=none|class=sIndent}
Cache
index
true
refresh
100d
showRefresh
true
id
doc
title
Refresh page
showDate
true
retry
Enable
servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Constants SummaryConstant for the "delete" SQL action.Constant for the "insert" SQL action.Constant expressing that no SQL action took place.Constant for the "select" SQL action.Constant for the "update" SQL action.constantservoy sDetail2100%height:30px2Constants DetailsDELETE_ACTIONname
DELETE_ACTION
dessIndent
Constant for the "delete" SQL action.
{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:DELETE_ACTION_snc|trigger=button|text=}{sub-section}{sub-section:DELETE_ACTION_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:DELETE_ACTION_prs|trigger=button|text=}{sub-section}{sub-section:DELETE_ACTION_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:DELETE_ACTION_ret|trigger=button|text=}{sub-section}{sub-section:DELETE_ACTION_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:DELETE_ACTION_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:DELETE_ACTION_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DELETE_ACTION_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:DELETE_ACTION_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:DELETE_ACTION_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:DELETE_ACTION_sam|trigger=none}{code:language=javascript}
if (action == SQL_ACTION_TYPES.INSERT_ACTION)
application.output("it was an insert");
else if (action == SQL_ACTION_TYPES.DELETE_ACTION)
application.output("it was a delete");
else if (action == SQL_ACTION_TYPES.UPDATE_ACTION)
application.output("it was an update");
else if (action == SQL_ACTION_TYPES.SELECT_ACTION)
application.output("it was a select");
else if (action == SQL_ACTION_TYPES.NO_ACTION)
application.output("it was nothing");
else
application.output("what was this?");
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=INSERT_ACTION|class=node}{tr:id=name}{td}h6.INSERT_ACTION{td}{tr}{tr:id=des}{td}{sub-section:INSERT_ACTION_des|trigger=button|text=}{sub-section}{sub-section:INSERT_ACTION_des|trigger=none|class=sIndent}ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowINSERT_ACTIONname
INSERT_ACTION
dessIndent
Constant for the "insert" SQL action.
{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:INSERT_ACTION_snc|trigger=button|text=}{sub-section}{sub-section:INSERT_ACTION_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:INSERT_ACTION_prs|trigger=button|text=}{sub-section}{sub-section:INSERT_ACTION_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:INSERT_ACTION_ret|trigger=button|text=}{sub-section}{sub-section:INSERT_ACTION_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:INSERT_ACTION_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:INSERT_ACTION_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:INSERT_ACTION_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:INSERT_ACTION_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:INSERT_ACTION_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:INSERT_ACTION_sam|trigger=none}{code:language=javascript}
if (action == SQL_ACTION_TYPES.INSERT_ACTION)
application.output("it was an insert");
else if (action == SQL_ACTION_TYPES.DELETE_ACTION)
application.output("it was a delete");
else if (action == SQL_ACTION_TYPES.UPDATE_ACTION)
application.output("it was an update");
else if (action == SQL_ACTION_TYPES.SELECT_ACTION)
application.output("it was a select");
else if (action == SQL_ACTION_TYPES.NO_ACTION)
application.output("it was nothing");
else
application.output("what was this?");
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=NO_ACTION|class=node}{tr:id=name}{td}h6.NO_ACTION{td}{tr}{tr:id=des}{td}{sub-section:NO_ACTION_des|trigger=button|text=}{sub-section}{sub-section:NO_ACTION_des|trigger=none|class=sIndent}ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowNO_ACTIONname
NO_ACTION
dessIndent
Constant expressing that no SQL action took place.
{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:NO_ACTION_snc|trigger=button|text=}{sub-section}{sub-section:NO_ACTION_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:NO_ACTION_prs|trigger=button|text=}{sub-section}{sub-section:NO_ACTION_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:NO_ACTION_ret|trigger=button|text=}{sub-section}{sub-section:NO_ACTION_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:NO_ACTION_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:NO_ACTION_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:NO_ACTION_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:NO_ACTION_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:NO_ACTION_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:NO_ACTION_sam|trigger=none}{code:language=javascript}
if (action == SQL_ACTION_TYPES.INSERT_ACTION)
application.output("it was an insert");
else if (action == SQL_ACTION_TYPES.DELETE_ACTION)
application.output("it was a delete");
else if (action == SQL_ACTION_TYPES.UPDATE_ACTION)
application.output("it was an update");
else if (action == SQL_ACTION_TYPES.SELECT_ACTION)
application.output("it was a select");
else if (action == SQL_ACTION_TYPES.NO_ACTION)
application.output("it was nothing");
else
application.output("what was this?");
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=SELECT_ACTION|class=node}{tr:id=name}{td}h6.SELECT_ACTION{td}{tr}{tr:id=des}{td}{sub-section:SELECT_ACTION_des|trigger=button|text=}{sub-section}{sub-section:SELECT_ACTION_des|trigger=none|class=sIndent}ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowSELECT_ACTIONname
SELECT_ACTION
dessIndent
Constant for the "select" SQL action.
{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:SELECT_ACTION_snc|trigger=button|text=}{sub-section}{sub-section:SELECT_ACTION_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:SELECT_ACTION_prs|trigger=button|text=}{sub-section}{sub-section:SELECT_ACTION_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:SELECT_ACTION_ret|trigger=button|text=}{sub-section}{sub-section:SELECT_ACTION_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:SELECT_ACTION_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:SELECT_ACTION_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:SELECT_ACTION_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:SELECT_ACTION_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:SELECT_ACTION_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:SELECT_ACTION_sam|trigger=none}{code:language=javascript}
if (action == SQL_ACTION_TYPES.INSERT_ACTION)
application.output("it was an insert");
else if (action == SQL_ACTION_TYPES.DELETE_ACTION)
application.output("it was a delete");
else if (action == SQL_ACTION_TYPES.UPDATE_ACTION)
application.output("it was an update");
else if (action == SQL_ACTION_TYPES.SELECT_ACTION)
application.output("it was a select");
else if (action == SQL_ACTION_TYPES.NO_ACTION)
application.output("it was nothing");
else
application.output("what was this?");
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=UPDATE_ACTION|class=node}{tr:id=name}{td}h6.UPDATE_ACTION{td}{tr}{tr:id=des}{td}{sub-section:UPDATE_ACTION_des|trigger=button|text=}{sub-section}{sub-section:UPDATE_ACTION_des|trigger=none|class=sIndent}ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowUPDATE_ACTIONname
UPDATE_ACTION
dessIndent
Constant for the "update" SQL action.
{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:UPDATE_ACTION_snc|trigger=button|text=}{sub-section}{sub-section:UPDATE_ACTION_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:UPDATE_ACTION_prs|trigger=button|text=}{sub-section}{sub-section:UPDATE_ACTION_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:UPDATE_ACTION_ret|trigger=button|text=}{sub-section}{sub-section:UPDATE_ACTION_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:UPDATE_ACTION_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:UPDATE_ACTION_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:UPDATE_ACTION_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:UPDATE_ACTION_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:UPDATE_ACTION_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:UPDATE_ACTION_sam|trigger=none}{code:language=javascript}
if (action == SQL_ACTION_TYPES.INSERT_ACTION)
application.output("it was an insert");
else if (action == SQL_ACTION_TYPES.DELETE_ACTION)
application.output("it was a delete");
else if (action == SQL_ACTION_TYPES.UPDATE_ACTION)
application.output("it was an update");
else if (action == SQL_ACTION_TYPES.SELECT_ACTION)
application.output("it was a select");
else if (action == SQL_ACTION_TYPES.NO_ACTION)
application.output("it was nothing");
else
application.output("what was this?");
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}ret