Child pages
  • SQL_ACTION_TYPES

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Divcache
id
classservoy sSummary
Colgroup Tag
Col
width80px
Col
Table Head (thead)
Table Row (tr)
styleheight: 30px;
Table Head (th)
colspan2
Constants Summary
Table Row (tr)
Table Cell (td)
Number
Table Cell (td)DELETE_ACTION
styleindexdisplay: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
iddescription
HTML Table
true
refresh100d
showRefreshtrue
iddoc
titleRefresh page
showDatetrue
retryEnable
id

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

Table Cell (td)
Number
Table Cell (td)INSERT_ACTION
servoy sSummary12%30%58%height: 30px;3Constants SummaryConstant for the "delete" SQL action. Table Row (tr) Table Row (tr)
Table Cell (td)
Number
Table Cell (td)NO_ACTION
Constant for the "insert" SQL action. Table Row (tr)
Table Cell (td)
Number
Table Cell (td)SELECT_ACTION
Constant expressing that no SQL action took place. Table Row (tr)
Table Cell (td)
Number
Table Cell (td)UPDATE_ACTION
Constant for the "select" SQL action.Constant for the "update" SQL action. HTML Table

constantclass Colgroup Tag Colcolspanservoy sDetail2width100%

Col
Table Head (thead) Table Row (tr)styleheight:30px; Table Head (th)colspan2Constants Details Table Body (tbody)ididDELETE_ACTION Table Row (tr)nametd

DELETE_ACTION

Table Row (tr)id

des Table Cell (td) DivclasssIndent
Constant for the "delete" SQL action.
Table Row (tr)idtd
ret

Returns

divsIndentclients

classtd

Supported Clients

sIndent
Number Table Row (tr)
idsam
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idINSERT_ACTION
Table Row (tr)
idname
tdSmartClient,WebClient,NGClientsam

Sample

Div
classsIndent
Code Block
languagejavascript
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?");
sIdentjavascriptlastDetailRowINSERT_ACTIONname

INSERT_ACTION

Table Row (tr)id Table Cell (td) DivclassdesidsIndent
Constant for the "insert" SQL action.
Table Row (tr)ret

Table Cell (td)

Returns

divsIndentclients

classid

Supported Clients

sIndent
Number Table Row (tr)SmartClient,WebClient,NGClientsam

Table Cell (td)

Table Body (tbody)
idNO_ACTION
Table Row (tr)
idname
Table Cell (td)

NO_ACTION

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant expressing that no SQL action took place.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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?");
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idSELECT_ACTION
Table Row (tr)
idname
Table Cell (td)

SELECT_ACTION

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant for the "select" SQL action.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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?");
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idUPDATE_ACTION
Table Row (tr)
idname
Table Cell (td)

UPDATE_ACTION

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant for the "update" SQL action.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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?");
Table Row (tr)
classlastDetailRow
Table Cell (td) 

Sample

Div
classsIndent
Code Block
languagejavascript
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?");
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
sIdentjavascriptlastDetailRowNO_ACTIONname

NO_ACTION

dessIndent
Constant expressing that no SQL action took place.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
SELECT_ACTIONname

SELECT_ACTION

dessIndent
Constant for the "select" SQL action.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
UPDATE_ACTIONname

UPDATE_ACTION

dessIndent
Constant for the "update" SQL action.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow