SQL_ACTION_TYPES

Overview

The SQL_ACTION_TYPES class defines script constants for SQL data manipulation actions.

Constants Summarized

Type	Name	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 Detailed

DELETE_ACTION

Constant for the "delete" SQL action.

Type 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.

Type 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.

Type 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.

Type 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.

Type 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?");

---