flash.data

# SQLColumnNameStyle - AS3

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.

Related API Elements

flash.data.SQLConnection.columnNameStyle

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

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.

Related API Elements

flash.data.SQLConnection.columnNameStyle

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

Related API Elements

flash.data.SQLConnection.columnNameStyle

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

Related API Elements

flash.data.SQLConnection.columnNameStyle

© 2015 Adobe Systems Incorporated. All rights reserved.
Mon Apr 10 2017, 12:28 PM -07:00