Page History

{hiddendiv:style=display:none}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACTAUTO CHANGES FROMUPDATE THE PAGECONTENT ANDTHROUGH MERGETHE THEM BACK INTO SERVOY SOURCE{hiddenDOC GENERATOR{div}
{sub-sectiondiv:description|text=}{sub-sectionid=description}{div}\\ 

{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=desret}{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*Returns*\\{div:class=sIndent}[Number]{div}{td}{tr}{tr:id=sam}{td}*SinceSample*\\{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:class=sIndent}{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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=INSERT_ACTION}{tr:id=name}{td}h6.INSERT_ACTION{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[Number]{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}{tr:id=sam}{td}*Sample*\\{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)
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}{divdiv}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=INSERTNO_ACTION|class=node}{tr:id=name}{td}h6.INSERTNO_ACTION{td}{tr}{builder-show:permission=edit}{tr:id=desret}{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*Returns*\\{div:class=sIndent}[Number]{div}{td}{tr}{tr:id=sam}{td}*SinceSample*\\{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}{div:class=sIndent}{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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=SELECT_ACTION}{tr:id=name}{td}h6.SELECT_ACTION{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[Number]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=UPDATE_ACTION}{tr:id=name}{td}h6.UPDATE_ACTION{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[Number]{div}{td}{tr}{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}