SQLColumn (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Detailed information about the columns
Tip: How to speed up the execution time of SQLColumn?

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.

Versions 16 and later

This function is now available in Browser code.

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.

New in version 16

This function is now available in Browser code.

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.

This function is now available in Browser code.

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.

Versions 19 and later

This function is now available in Android widget mode (accessing external databases via a Webservice).

This function is now available for Android applications (accessing external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing external databases via a Webservice).

New in version 19

This function is now available in Android widget mode (accessing external databases via a Webservice).

This function is now available for Android applications (accessing external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing external databases via a Webservice).

This function is now available in Android widget mode (accessing external databases via a Webservice).

This function is now available for Android applications (accessing external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing external databases via a Webservice).

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Example

// Connection to a database
Connection_Number is int
Connection_Number = SQLConnect(SourceName, "", "", "", "ODBC")
i is int
// LIST_TableList is a list containing the list of tables
i = LIST_TableList
IF i <> -1 THEN
ListAdd(LIST_List1, SQLColumn(Connection_Number, LIST_TableList[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 + CR + Column2 + CR + ... + 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 whose columns are requested.

<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 + CR + Column2 + CR + ... + 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.
Versions 16 and later
Caution: The characteristics of the columns cannot be known if no result was returned by the query.
New in version 16
Caution: The characteristics of the columns cannot be known if no result was returned by the query.
Caution: The characteristics of the columns cannot be known if no result was returned by the query.

<Query name>: Character string

Name of the query (executed with SQLExec or SQLExecWDR) for which we want to get the columns.
Versions 16 and later
Only the queries created and run by SQLExec are available.
New in version 16
Only the queries created and run by SQLExec are available.
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 along with some 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" for numeric column, "T" for text column

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

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
N	5	SQL_VARBINARY: Variable-length 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: Numeric
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: Single 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-length string
T	0	SQL_WCHAR: Variable-length Unicode string
T	-2	SQL_WLONGVARCHAR: Unicode memo

Size: Displayable size of the column: size of the string for the character strings and size of the numeric value (in bytes) for the numeric values.

Versions 16 and later

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-length Unicode string
the size is empty.

Reminder: The characteristics of the columns cannot be known if no result was returned by the query.

New in version 16

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-length Unicode string
the size is empty.

Reminder: The characteristics of the columns cannot be known if no result was returned by the query.

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-length Unicode string
the size is empty.

Reminder: The characteristics of the columns cannot be known if no result was returned by the query.

Tip: How to speed up the execution time of SQLColumn?

The name of the table must be prefixed by the owner: the result will be nearly immediate:

SQLColumn(ConnectionNum, OWNER.CUSTOMER)

Component: wd270hf.dll