SQLColumn (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / SQL functions

Detailed information about the columns
Tip: How can I speed up the execution time of the SQLColumn function?

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLColumn (Function)

In french: SQLColonne

Returns the characteristics of all the columns (or items):

for a given table.
for a given query.

The SQL functions are used to handle the local databases (such as Web SQL databases). For more details, see Accessing a database in local mode (SQLite).

SQLColumn returns only the characteristics of the columns for a given query. A result must have been returned by the query to get the query characteristics.

Example

// Connexion à une base de données
Numéro_Connexion is int 
Numéro_Connexion = SQLConnect(NomSource, "", "", "", "ODBC")
i is int
// LISTE_ListeTab est une liste contenant la liste des tables
i = LISTE_ListeTab
IF i <> -1 THEN
	ListAdd(LISTE_Liste1, SQLColumn(Numéro_Connexion, LISTE_ListeTab[i]))
END

Syntax

Columns of a given table Hide the details

<Result> = SQLColumn(<Connection number> , <Table name> [, <Details>])

<Result>: Character string

Name of the table columns.
If <Details> is set to False, the character string contains the name of each table column separated by CR:
Column1 + RC + Column2 + RC + ... + ColumnN
If <Details> is set to True, the character string contains the name of each table column along with various information about the column (name, type, size):
ColumnName + TAB + Type1 (N/T) + TAB + Type2 (number) + TAB + Size + CR

This format is presented in the Remarks.
The results regarding the types and the sizes of columns may differ from the results returned in WINDEV.

<Connection number>: Integer

Number of the connection to use, returned by SQLConnect.

<Table name>: Character string

Name of the table for which to get the columns.

<Details>: Optional boolean

True (default option) for a detailed result,
False for a simplified result.

Columns of a given query Hide the details

<Result> = SQLColumn(<Query name> [, <Details>])

<Result>: Character string

If <Details> is set to False, the character string contains the name of each table column separated by CR characters (Carriage Return):
Column1 + RC + Column2 + RC + ... + ColumnN
If <Details> is set to True, the character string contains the name of each table column along with various information about the column (name, type, size):
ColumnName + TAB + Type1 (N/T) + TAB + Type2 (number) + TAB + Size + CR

This format is presented in the Remarks.
The results regarding the types and the sizes of columns may differ from the results returned in WINDEV.
Warning If the query did not return any results, the characteristics of the columns cannot be known.

<Query name>: Character string

Name of the query (executed with SQLExec or SQLExecWDR) for which we want to get the columns.
Only the queries created and run by SQLExec are available.

<Details>: Optional boolean

True for a detailed result,
False (default option) for a simple result.

Remarks

Detailed information about the columns

If <Details> is set to True, the character string contains the names of all the columns of a table with various information about these columns (name, type, size) in the following format:

Column_Name + TAB + Type 1 (N/T) + TAB + Type 2 (number) + TAB + Size

Type 1 (N/T): "N" numeric column, "T" text column

Type 2: internal number indicating the exact type of column (see array)

Type 1	Type 2	ODBC type

N	1	SQL_BIT: Bit
N	2	SQL_TINYINT: Integer
N	3	SQL_BIGINT: Long integer
N	4	SQL_LONGVARBINARY: Binary memo type
N	5	SQL_VARBINARY: Variable-size binary string
N	6	SQL_BINARY: Binary
T	7	SQL_LONGVARCHAR: ASCII string memo
T	9	SQL_CHAR: Fixed-length string
N	10	SQL_NUMERIC: Numerical
N	11	SQL_DECIMAL: Decimal number
N	12	SQL_INTEGER: Integer
N	13	SQL_SMALLINT: Integer
N	14	SQL_FLOAT: Double real
N	15	SQL_REAL: Simple real
N	16	SQL_DOUBLE: Double real
T	17	SQL_DATE: Date
T	18	SQL_TIME: Time
T	19	SQL_TIMESTAMP: Date time
T	20	SQL_VARCHAR: Variable-size string
T	0	SQL_WCHAR: variable-size Unicode string
T	-2	SQL_WLONGVARCHAR: Unicode memo

Size: Displayable size of column: for strings, size of string, and for numericals, size of numerical in bytes.

In browser code:

Only two types are supported:
Type 1 Type 2 ODBC type
N 16 SQL_DOUBLE: Double real
T 0 SQL_WCHAR: variable-size Unicode string
the size is empty.

Reminder If the query has not returned any results, the characteristics of the columns cannot be known.

Tip: How can I speed up the execution time of the SQLColumn function?

Simply prefix the table name with the owner: the result is almost immediate:

SQLColumn(NumConnexion, PROPRIETAIRE.CLIENT)

Component: wd300hf.dll