flash.data.SQLColumnNameStyle - Adobe® AIR® API Reference for HTML Developers

window.runtime property	window.runtime.flash.data.SQLColumnNameStyle

Inheritance	SQLColumnNameStyle Object

Runtime Versions:

1.0

This class contains the constants that represent the possible values for the SQLConnection.columnNameStyle property. These values indicate different options that control how column names (property names) are formatted in the objects returned as a result of a SQL SELECT statement.

See also

SQLConnection.columnNameStyle

Properties

Hide Inherited Public Properties

Show Inherited Properties

	Property		Defined By
		constructor : Object A reference to the class object or constructor function for a given object instance.	Object
		prototype : Object [static] A reference to the prototype object of a class or function object.	Object

Public Methods

Hide Inherited Public Methods

Show Inherited Methods

	Method		Defined By
		hasOwnProperty(name:String):Boolean Indicates whether an object has a specified property defined.	Object
		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
		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
		toLocaleString():String Returns the string representation of this object, formatted according to locale-specific conventions.	Object
		toString():String Returns the string representation of the specified object.	Object
		valueOf():Object Returns the primitive value of the specified object.	Object

Constants

	Constant		Defined By
		DEFAULT : String = "default" [static] Indicates that column names returned from a SELECT statement use the default format.	SQLColumnNameStyle
		LONG : String = "long" [static] Indicates that column names returned from a SELECT statement use long-column-name format.	SQLColumnNameStyle
		SHORT : String = "short" [static] Indicates that column names returned from a SELECT statement use short-column-name format.	SQLColumnNameStyle

Constant Detail

DEFAULT

Constant

public static const DEFAULT:String = "default"

Runtime Versions:

1.0

Indicates that column names returned from a SELECT statement use the default format. In the default format, column names have the form [table-name]_[column-name] when multiple tables are included in the SELECT statement, or [column-name] when the SELECT statement includes a single table.

See also

SQLConnection.columnNameStyle

LONG

Constant

public static const LONG:String = "long"

Runtime Versions:

1.0

Indicates that column names returned from a SELECT statement use long-column-name format. In this format, column names use the form [table-name]_[column-name] regardless of how many tables are included in the SELECT statement.

See also

SQLConnection.columnNameStyle

SHORT

Constant

public static const SHORT:String = "short"

Runtime Versions:

1.0

Indicates that column names returned from a SELECT statement use short-column-name format. In this format, column names use the form [column-name], regardless of how many tables are included in the SELECT statement.

If the result set contains multiple columns with the same name, only one property with that name is added to the result object. The value assigned to that property is taken from the last column with that name in the result row. For example, consider the following SELECT statement:

	 SELECT customers.customerId, addresses.customerId

	 FROM customers INNER JOIN addresses

	    ON customers.customerId = addresses.customerId

When this statement is executed on a SQLConnection instance with short column name format, each result object has a property named customerId, containing the value from the addresses table's customerId column.

See also

SQLConnection.columnNameStyle

[an error occurred while processing this directive][an error occurred while processing this directive]

Legal Notices | Online Privacy Policy