Packageflash.data
Classpublic class SQLColumnNameStyle
InheritanceSQLColumnNameStyle Inheritance Object

Language version: ActionScript 3.0
Runtime version: 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.

See also

flash.data.SQLConnection.columnNameStyle


Public Properties
 PropertyDefined by
 Inheritedconstructor : Object
A reference to the class object or constructor function for a given object instance.
Object
 Inheritedprototype : Object
[static] A reference to the prototype object of a class or function object.
Object
Public Methods
 MethodDefined by
 Inherited
Indicates whether an object has a specified property defined.
Object
 Inherited
Indicates whether an instance of the Object class is in the prototype chain of the object specified as the parameter.
Object
 Inherited
Indicates whether the specified property exists and is enumerable.
Object
 Inherited
Sets the availability of a dynamic property for loop operations.
Object
 Inherited
Returns the string representation of this object, formatted according to locale-specific conventions.
Object
 Inherited
Returns the string representation of the specified object.
Object
 Inherited
Returns the primitive value of the specified object.
Object
Public Constants
 ConstantDefined 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
DEFAULTconstant
public static const DEFAULT:String = "default"

Language version: ActionScript 3.0
Runtime version: 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.

See also

LONGconstant 
public static const LONG:String = "long"

Language version: ActionScript 3.0
Runtime version: 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.

See also

SHORTconstant 
public static const SHORT:String = "short"

Language version: ActionScript 3.0
Runtime version: 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.

See also