Servoy 6.0.x Documentation
Child pages
  • SQL_ACTION_TYPES
Skip to end of metadata
Go to start of metadata


Constants Summary
Number #DELETE_ACTION
Constant for the "delete" SQL action.
Number #INSERT_ACTION
Constant for the "insert" SQL action.
Number #NO_ACTION
Constant expressing that no SQL action took place.
Number #SELECT_ACTION
Constant for the "select" SQL action.
Number #UPDATE_ACTION
Constant for the "update" SQL action.

Constants Details
DELETE_ACTION
Constant for the "delete" SQL action.
Returns
Number
Sample
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?");
INSERT_ACTION
Constant for the "insert" SQL action.
Returns
Number
Sample
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?");
NO_ACTION
Constant expressing that no SQL action took place.
Returns
Number
Sample
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?");
SELECT_ACTION
Constant for the "select" SQL action.
Returns
Number
Sample
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?");
UPDATE_ACTION
Constant for the "update" SQL action.
Returns
Number
Sample
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?");
  • No labels