{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:DELETE_ACTION_des|trigger=button|text=}{sub-section}{sub-section:DELETE_ACTION_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:INSERT_ACTION_des|trigger=button|text=}{sub-section}{sub-section:INSERT_ACTION_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:NO_ACTION_des|trigger=button|text=}{sub-section}{sub-section:NO_ACTION_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:SELECT_ACTION_des|trigger=button|text=}{sub-section}{sub-section:SELECT_ACTION_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:UPDATE_ACTION_des|trigger=button|text=}{sub-section}{sub-section:UPDATE_ACTION_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{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}