|
|
|
|
|
|
|
|
|
|
SQLColumnFormat (Function) In french: SQLFormatColonne
 Not available with this kind of connection
Returns the different types of columns supported: Ch is string
Ch = SQLColumnFormat()
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 is in the form: <SQL column type> + 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 | Variable-length string | 20 |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|