flash.events.SQLUpdateEvent (ActionScript 3.0)

	Property	Defined by
		bubbles : Boolean Indicates whether an event is a bubbling event.	Event
		cancelable : Boolean Indicates whether the behavior associated with the event can be prevented.	Event
		constructor : Object A reference to the class object or constructor function for a given object instance.	Object
		currentTarget : Object The object that is actively processing the Event object with an event listener.	Event
		eventPhase : uint The current phase in the event flow.	Event
		prototype : Object [static] A reference to the prototype object of a class or function object.	Object
		rowID : Number [read-only] The unique row identifier of the row that was inserted, deleted, or updated.	SQLUpdateEvent
		table : String [read-only] The name of the table whose data change caused the event to be dispatched.	SQLUpdateEvent
		target : Object The event target.	Event
		type : String The type of event.	Event

	Method	Defined by
		SQLUpdateEvent(type:String, bubbles:Boolean = false, cancelable:Boolean = false, table:String = null, rowID:Number = 0) Creates a new SQLUpdateEvent instance.	SQLUpdateEvent
		clone():Event Creates a copy of the SQLUpdateEvent object and sets the value of each property to match that of the original.	SQLUpdateEvent
		formatToString(className:String, ... arguments):String A utility function for implementing the `toString()` method in custom ActionScript 3.0 Event classes.	Event
		hasOwnProperty(name:String):Boolean Indicates whether an object has a specified property defined.	Object
		isDefaultPrevented():Boolean Checks whether the `preventDefault()` method has been called on the event.	Event
		isPrototypeOf(theClass:Object):Boolean Indicates whether an instance of the Object class is in the prototype chain of the object specified as the parameter.	Object
		preventDefault():void Cancels an event's default behavior if that behavior can be canceled.	Event
		propertyIsEnumerable(name:String):Boolean Indicates whether the specified property exists and is enumerable.	Object
		setPropertyIsEnumerable(name:String, isEnum:Boolean = true):void Sets the availability of a dynamic property for loop operations.	Object
		stopImmediatePropagation():void Prevents processing of any event listeners in the current node and any subsequent nodes in the event flow.	Event
		stopPropagation():void Prevents processing of any event listeners in nodes subsequent to the current node in the event flow.	Event
		toLocaleString():String Returns the string representation of this object, formatted according to locale-specific conventions.	Object
		toString():String Returns a string containing all the properties of the Event object.	Event
		valueOf():Object Returns the primitive value of the specified object.	Object

Public Constants

	Constant		Defined by
		ACTIVATE : String = "activate" [static] The `ACTIVATE` constant defines the value of the `type` property of an `activate` event object.	Event
		ADDED : String = "added" [static] The `Event.ADDED` constant defines the value of the `type` property of an `added` event object.	Event
		ADDED_TO_STAGE : String = "addedToStage" [static] The `Event.ADDED_TO_STAGE` constant defines the value of the `type` property of an `addedToStage` event object.	Event
		BROWSER_ZOOM_CHANGE : String = "browserZoomChange" [static] The `Event.BROWSER_ZOOM_CHANGE` constant defines the value of the `type` property of an `browserZoomChange` event object.	Event
		CANCEL : String = "cancel" [static] The `Event.CANCEL` constant defines the value of the `type` property of a `cancel` event object.	Event
		CHANGE : String = "change" [static] The `Event.CHANGE` constant defines the value of the `type` property of a `change` event object.	Event
		CHANNEL_MESSAGE : String = "channelMessage" [static] The `Event.CHANNEL_MESSAGE` constant defines the value of the `type` property of a `channelMessage` event object.	Event
		CHANNEL_STATE : String = "channelState" [static] The `Event.CHANNEL_STATE` constant defines the value of the `type` property of a `channelState` event object.	Event
		CLEAR : String = "clear" [static] The `Event.CLEAR` constant defines the value of the `type` property of a `clear` event object.	Event
		CLOSE : String = "close" [static] The `Event.CLOSE` constant defines the value of the `type` property of a `close` event object.	Event
		CLOSING : String = "closing" [static] The `Event.CLOSING` constant defines the value of the `type` property of a `closing` event object.	Event
		COMPLETE : String = "complete" [static] The `Event.COMPLETE` constant defines the value of the `type` property of a `complete` event object.	Event
		CONNECT : String = "connect" [static] The `Event.CONNECT` constant defines the value of the `type` property of a `connect` event object.	Event
		CONTEXT3D_CREATE : String = "context3DCreate" [static] The `Event.CONTEXT3D_CREATE` constant defines the value of the `type` property of a `context3Dcreate` event object.	Event
		COPY : String = "copy" [static] Defines the value of the `type` property of a `copy` event object.	Event
		CUT : String = "cut" [static] Defines the value of the `type` property of a `cut` event object.	Event
		DEACTIVATE : String = "deactivate" [static] The `Event.DEACTIVATE` constant defines the value of the `type` property of a `deactivate` event object.	Event
		DELETE : String = "delete" [static] The `SQLUpdateEvent.DELETE` constant defines the value of the `type` property of a SQLConnection `delete` event.	SQLUpdateEvent
		DISPLAYING : String = "displaying" [static] The `Event.DISPLAYING` constant defines the value of the `type` property of a `displaying` event object.	Event
		ENTER_FRAME : String = "enterFrame" [static] The `Event.ENTER_FRAME` constant defines the value of the `type` property of an `enterFrame` event object.	Event
		EXIT_FRAME : String = "exitFrame" [static] The `Event.EXIT_FRAME` constant defines the value of the `type` property of an `exitFrame` event object.	Event
		EXITING : String = "exiting" [static] The `Event.EXITING` constant defines the value of the `type` property of an `exiting` event object.	Event
		FRAME_CONSTRUCTED : String = "frameConstructed" [static] The `Event.FRAME_CONSTRUCTED` constant defines the value of the `type` property of an `frameConstructed` event object.	Event
		FRAME_LABEL : String = "frameLabel" [static] The `Event.FRAME_LABEL` constant defines the value of the `type` property of an `frameLabel` event object.	Event
		FULLSCREEN : String = "fullScreen" [static] The `Event.FULL_SCREEN` constant defines the value of the `type` property of a `fullScreen` event object.	Event
		HTML_BOUNDS_CHANGE : String = "htmlBoundsChange" [static] The `Event.HTML_BOUNDS_CHANGE` constant defines the value of the `type` property of an `htmlBoundsChange` event object.	Event
		HTML_DOM_INITIALIZE : String = "htmlDOMInitialize" [static] The `Event.HTML_DOM_INITIALIZE` constant defines the value of the `type` property of an `htmlDOMInitialize` event object.	Event
		HTML_RENDER : String = "htmlRender" [static] The `Event.HTML_RENDER` constant defines the value of the `type` property of an `htmlRender` event object.	Event
		ID3 : String = "id3" [static] The `Event.ID3` constant defines the value of the `type` property of an `id3` event object.	Event
		INIT : String = "init" [static] The `Event.INIT` constant defines the value of the `type` property of an `init` event object.	Event
		INSERT : String = "insert" [static] The `SQLUpdateEvent.INSERT` constant defines the value of the `type` property of a SQLConnection `insert` event.	SQLUpdateEvent
		LOCATION_CHANGE : String = "locationChange" [static] The `Event.LOCATION_CHANGE` constant defines the value of the `type` property of a `locationChange` event object.	Event
		MOUSE_LEAVE : String = "mouseLeave" [static] The `Event.MOUSE_LEAVE` constant defines the value of the `type` property of a `mouseLeave` event object.	Event
		NETWORK_CHANGE : String = "networkChange" [static] The `Event.NETWORK_CHANGE` constant defines the value of the `type` property of a `networkChange` event object.	Event
		OPEN : String = "open" [static] The `Event.OPEN` constant defines the value of the `type` property of an `open` event object.	Event
		PASTE : String = "paste" [static] The `Event.PASTE` constant defines the value of the `type` property of a `paste` event object.	Event
		PREPARING : String = "preparing" [static] The `Event.PREPARING` constant defines the value of the `type` property of a `preparing` event object.	Event
		REMOVED : String = "removed" [static] The `Event.REMOVED` constant defines the value of the `type` property of a `removed` event object.	Event
		REMOVED_FROM_STAGE : String = "removedFromStage" [static] The `Event.REMOVED_FROM_STAGE` constant defines the value of the `type` property of a `removedFromStage` event object.	Event
		RENDER : String = "render" [static] The `Event.RENDER` constant defines the value of the `type` property of a `render` event object.	Event
		RESIZE : String = "resize" [static] The `Event.RESIZE` constant defines the value of the `type` property of a `resize` event object.	Event
		SCROLL : String = "scroll" [static] The `Event.SCROLL` constant defines the value of the `type` property of a `scroll` event object.	Event
		SELECT : String = "select" [static] The `Event.SELECT` constant defines the value of the `type` property of a `select` event object.	Event
		SELECT_ALL : String = "selectAll" [static] The `Event.SELECT_ALL` constant defines the value of the `type` property of a `selectAll` event object.	Event
		SOUND_COMPLETE : String = "soundComplete" [static] The `Event.SOUND_COMPLETE` constant defines the value of the `type` property of a `soundComplete` event object.	Event
		STANDARD_ERROR_CLOSE : String = "standardErrorClose" [static] The `Event.STANDARD_ERROR_CLOSE` constant defines the value of the `type` property of a `standardErrorClose` event object.	Event
		STANDARD_INPUT_CLOSE : String = "standardInputClose" [static] The `Event.STANDARD_INPUT_CLOSE` constant defines the value of the `type` property of a `standardInputClose` event object.	Event
		STANDARD_OUTPUT_CLOSE : String = "standardOutputClose" [static] The `Event.STANDARD_OUTPUT_CLOSE` constant defines the value of the `type` property of a `standardOutputClose` event object.	Event
		SUSPEND : String = "suspend" [static] The `Event.SUSPEND` constant defines the value of the `type` property of an `suspend` event object.	Event
		TAB_CHILDREN_CHANGE : String = "tabChildrenChange" [static] The `Event.TAB_CHILDREN_CHANGE` constant defines the value of the `type` property of a `tabChildrenChange` event object.	Event
		TAB_ENABLED_CHANGE : String = "tabEnabledChange" [static] The `Event.TAB_ENABLED_CHANGE` constant defines the value of the `type` property of a `tabEnabledChange` event object.	Event
		TAB_INDEX_CHANGE : String = "tabIndexChange" [static] The `Event.TAB_INDEX_CHANGE` constant defines the value of the `type` property of a `tabIndexChange` event object.	Event
		TEXT_INTERACTION_MODE_CHANGE : String = "textInteractionModeChange" [static] The `Event.TEXT_INTERACTION_MODE_CHANGE` constant defines the value of the `type` property of a `interaction mode` event object.	Event
		TEXTURE_READY : String = "textureReady" [static] The `Event.TEXTURE_READY` constant defines the value of the `type` property of a `textureReady` event object.	Event
		UNLOAD : String = "unload" [static] The `Event.UNLOAD` constant defines the value of the `type` property of an `unload` event object.	Event
		UPDATE : String = "update" [static] The `SQLUpdateEvent.UPDATE` constant defines the value of the `type` property of a SQLConnection `update` event.	SQLUpdateEvent
		USER_IDLE : String = "userIdle" [static] The `Event.USER_IDLE` constant defines the value of the `type` property of a `userIdle` event object.	Event
		USER_PRESENT : String = "userPresent" [static] The `Event.USER_PRESENT` constant defines the value of the `type` property of a `userPresent` event object.	Event
		VIDEO_FRAME : String = "videoFrame" [static] The `Event.VIDEO_FRAME` constant defines the value of the `type` property of a `videoFrame` event object.	Event
		WORKER_STATE : String = "workerState" [static] The `Event.WORKER_STATE` constant defines the value of the `type` property of a `workerState` event object.	Event

Property detail

rowID

property

rowID:Number [read-only]

Language version:

ActionScript 3.0

Runtime version:

AIR 1.0

The unique row identifier of the row that was inserted, deleted, or updated.

A row identifier is used to uniquely identify a row in a table within the database. The value is frequently generated by the database.

The row identifier for a single SQL INSERT statement execution can be obtained through the lastInsertRowID property of the SQLResult object returned by the SQLStatement object's getResult() method (when called after the SQLStatement dispatches its result event).

For more information about primary keys and generated row identifiers, see the "CREATE TABLE" and "Expressions" sections in the appendix "SQL support in local databases."

Implementation
public function get rowID():Number

table

property

table:String [read-only]

Language version:

ActionScript 3.0

Runtime version:

AIR 1.0

The name of the table whose data change caused the event to be dispatched.

Implementation
public function get table():String

Constructor detail

SQLUpdateEvent

()

constructor

public function SQLUpdateEvent(type:String, bubbles:Boolean = false, cancelable:Boolean = false, table:String = null, rowID:Number = 0)

Language version:

ActionScript 3.0

Runtime version:

AIR 1.0

Creates a new SQLUpdateEvent instance.

Parameters

	`type:String` — The type of the event, available through the `type` property.

	`bubbles:Boolean` (default = `false`) — Determines whether the event object participates in the bubbling stage of the event flow. The default value is `false`.

	`cancelable:Boolean` (default = `false`) — Determines whether the Event object can be cancelled. The default value is `false`.

	`table:String` (default = `null`) — Indicates the name of the table whose data changed.

	`rowID:Number` (default = `0`) — The unique row identifier of the row that was inserted, deleted, or updated.

Method detail

clone

()

method

public override function clone():Event

Language version:

ActionScript 3.0

Runtime version:

AIR 1.0

Creates a copy of the SQLUpdateEvent object and sets the value of each property to match that of the original.

Returns

Event — A new SQLUpdateEvent object with property values that match those of the original.

Constant detail

DELETE

constant

public static const DELETE:String = "delete"

Language version:

ActionScript 3.0

Runtime version:

AIR 1.0

The SQLUpdateEvent.DELETE constant defines the value of the type property of a SQLConnection delete event. The delete event has the following properties:

Property	Value
`bubbles`	`false`
`cancelable`	`false`; there is no default behavior to cancel.
`currentTarget`	The object that is actively processing the event object with an event listener.
`rowID`	The unique row identifier of the row that was inserted, deleted, or updated.
`target`	The SQLConnection object on which the operation was performed.
`table`	The name of the table on which the change occurred.

INSERT

constant

public static const INSERT:String = "insert"

Language version:

ActionScript 3.0

Runtime version:

AIR 1.0

The SQLUpdateEvent.INSERT constant defines the value of the type property of a SQLConnection insert event. The insert event has the following properties:

Property	Value
`bubbles`	`false`
`cancelable`	`false`; there is no default behavior to cancel.
`currentTarget`	The object that is actively processing the event object with an event listener.
`rowID`	The unique row identifier of the row that was inserted, deleted, or updated.
`target`	The SQLConnection object on which the operation was performed.
`table`	The name of the table on which the change occurred.

UPDATE

constant

public static const UPDATE:String = "update"

Language version:

ActionScript 3.0

Runtime version:

AIR 1.0

The SQLUpdateEvent.UPDATE constant defines the value of the type property of a SQLConnection update event.

The update event has the following properties:

Property	Value
`bubbles`	`false`
`cancelable`	`false`; there is no default behavior to cancel.
`currentTarget`	The object that is actively processing the event object with an event listener.
`rowID`	The unique row identifier of the row that was inserted, deleted, or updated.
`target`	The SQLConnection object on which the operation was performed.
`table`	The name of the table on which the change occurred.

Examples

examples\SQLUpdateEvent.class.1

The following example shows the use of of a SQLUpdateEvent instance in responding to an update event.


var dbStatement:SQLStatement;

function initConnection():void
{
    var dbFile:File = new File(File.separator + "employee.db");
    db.addEventListener(SQLEvent.OPEN, dbOpenHandler);
    db.addEventListener(SQLUpdateEvent.UPDATE, dbUpdateHandler);

    dbStatement.text = "UPDATE employees SET name = :name WHERE id = :id";
    dbStatement.parameters[:name] = "Bruce";
    dbStatement.parameters[:id] = 100;

    dbStatement.sqlConnection = db;

	db.open(dbFile);
}

function dbUpdateHandler(event:SQLUpdateEvent):void
{
    trace(event.type + " for table '" + event.table + "' was fired for row with ID:" + event.rowID);
}

function dbOpenHandler(event:SQLEvent):void
{
    dbStatement.execute();
}

Submit Feedback

ActionScript 3.0 Language Reference	All Packages \| All Classes \| Language Elements \| Index \| Appendices \| Conventions \| Frames No Frames
Class SQLUpdateEvent	Properties \| Methods \| Constants \| Examples

Package	flash.events
Class	public class SQLUpdateEvent
Inheritance	SQLUpdateEvent Event Object