flash.data.SQLColumnNameStyle - Adobe® Flex® 4 Language Reference (Flex 4)

Package	flash.data
Class	public class SQLColumnNameStyle
Inheritance	SQLColumnNameStyle Object

Language Version:

ActionScript 3.0

Runtime Versions:

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

Public Properties

Hide Inherited Public Properties

Show Inherited Public 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 Public 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

Public 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"

Language Version:

ActionScript 3.0

Runtime Versions:

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

LONG

Constant

public static const LONG:String = "long"

Language Version:

ActionScript 3.0

Runtime Versions:

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

SHORT

Constant

public static const SHORT:String = "short"

Language Version:

ActionScript 3.0

Runtime Versions:

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