Servoy 2020 Documentation
Child pages
  • SQL_ACTION_TYPES

Versions Compared

Old Version 7

changes.mady.by.user Servoy Docs

Saved on

compared with

New Version Current

changes.mady.by.user Servoy Docs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
{div: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 AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.\\ \\ Enter additional information related to this 'class' inside the \{div} macro with 'id=description'{div} {div:id=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}{tr:id=name}{td}h6.DELETE_ACTION{td}{tr}{tr:id=des}{td}{div:class=sIndent}
Wiki Markup
Cache
indextrue
refresh100d
showRefreshtrue
iddoc
titleRefresh page
showDatetrue
retryEnable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy 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.
{div}{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=INSERT_ACTION}{tr:id=name}{td}h6.INSERT_ACTION{td}{tr}{tr:id=des}{td}{div:class=sIndent}
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowINSERT_ACTIONname
INSERT_ACTION
dessIndent
Constant for the "insert" SQL action.
{div}{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=NO_ACTION}{tr:id=name}{td}h6.NO_ACTION{td}{tr}{tr:id=des}{td}{div:class=sIndent}
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowNO_ACTIONname
NO_ACTION
dessIndent
Constant expressing that no SQL action took place.
{div}{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=SELECT_ACTION}{tr:id=name}{td}h6.SELECT_ACTION{td}{tr}{tr:id=des}{td}{div:class=sIndent}
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowSELECT_ACTIONname
SELECT_ACTION
dessIndent
Constant for the "select" SQL action.
{div}{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=des}{td}{div:class=sIndent}
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowUPDATE_ACTIONname
UPDATE_ACTION
dessIndent
Constant for the "update" SQL action.
{div}{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}{table}
ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow