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.
See also
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.
See also
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.
See also