| Pacote | flash.data |
| Classe | public class SQLColumnNameStyle |
| Herança | SQLColumnNameStyle  Object |
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.
Veja também
| Constante | Definido por | ||
|---|---|---|---|
| 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 | ||
| DEFAULT | Constante |
Esconder Propriedades Públicas Herdadas
Exibir Propriedades Públicas Herdadas
public static const DEFAULT:String = "default"
Indicates that column names returned from a SELECT statement
use the default format. In the default format, column names have the form
[table-name|alias]_[column-name] when multiple tables are
included in the SELECT statement, or [column-name] when
the SELECT statement includes a single table.
Veja também
| LONG | Constante |
public static const LONG:String = "long"
Indicates that column names returned from a SELECT statement use
long-column-name format. In this format, column names use the form
[table-name|alias]_[column-name] regardless of how many
tables are included in the SELECT statement.
Veja também
| SHORT | Constante |
public static const SHORT:String = "short"
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 exemplo, consider the following SELECT
statement:
SELECT customers.customerId, addresses.customerId
FROM customers INNER JOIN addresses
ON customers.customerId = addresses.customerId
When this statment is executed on a SQLConnection with short column name format,
each result object has a property named customerId, containing the
value from the addresses table's customerId column.
Veja também