|
|
|
|
|
SQLColumnFormat (Function) In french: SQLFormatColonne
Not available with this kind of connection
Returns the different types of columns supported:
Str is string Str = SQLColumnFormat() // The Str string contains for example: // "CHAR" + TAB + "9" + CR + "VARCHAR" + TAB + "20" + CR
Syntax
<Result> = SQLColumnFormat([<Connection name>])
<Result>: Character string List of supported types:- by the data source (defined by SQLConnect)
- by <Connection name> if this parameter is specified.
This list has the following format: <Type of SQL column> + TAB + <WINDEV/WEBDEV type> + CR. For more details, see remarks. <Connection name>: Optional character string If this parameter is specified, it is used to specify the connection for which the format of columns must be returned. This name corresponds to a connection described in the analysis, or to a connection described by HDescribeConnection or HOpenConnection.If this parameter is not specified, the data source defined by SQLConnect will be used. Remarks The result of SQLColumnFormat has the following format:
<Type of SQL column> + TAB + <WINDEV type> + CR
The following table presents the equivalence between the SQL types and the WINDEV/WEBDEV types. | | | SQL type | Corresponds to | WINDEV/WEBDEV type |
---|
SQL_WLONGVARCHAR | Unicode memo | -2 | SQL_WCHAR | Unicode string | 0 | SQL_BIT | Bit | 1 | SQL_TINYINT | Integer | 2 | SQL_BIGINT | Integer | 3 | SQL_LONGVARBINARY | Binary Memo | 4 | SQL_VARBINARY | Fixed-length binary string | 5 | SQL_BINARY | Binary | 6 | SQL_LONGVARCHAR | ASCII string memo | 7 | SQL_CHAR | Fixed-length string | 9 | SQL_NUMERIC | Numeric | 10 | SQL_DECIMAL | Decimal number | 11 | SQL_INTEGER | Integer | 12 | SQL_SMALLINT | Integer | 13 | SQL_FLOAT | Real | 14 | SQL_REAL | Real | 15 | SQL_DOUBLE | Real | 16 | SQL_DATE | Date | 17 | SQL_TIME | Time | 18 | SQL_TIMESTAMP | Date + Time | 19 | SQL_VARCHAR | Fixed-length string | 20 |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|