ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / SQL functions
  • List of supported types
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
SQLColumnFormat (Function)
In french: SQLFormatColonne
OLE DBNot available with this kind of connection
Returns the different types of columns supported:
Example
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

List of supported types

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 typeCorresponds toWINDEV/WEBDEV type
SQL_WLONGVARCHARUnicode memo-2
SQL_WCHARUnicode string0
SQL_BITBit1
SQL_TINYINTInteger2
SQL_BIGINTInteger3
SQL_LONGVARBINARYBinary Memo4
SQL_VARBINARYFixed-length binary string5
SQL_BINARYBinary6
SQL_LONGVARCHARASCII string memo7
SQL_CHARFixed-length string9
SQL_NUMERICNumeric10
SQL_DECIMALDecimal number11
SQL_INTEGERInteger12
SQL_SMALLINTInteger13
SQL_FLOATReal14
SQL_REALReal15
SQL_DOUBLEReal16
SQL_DATEDate17
SQL_TIMETime18
SQL_TIMESTAMPDate + Time19
SQL_VARCHARVariable-length string20
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 04/20/2023

Send a report | Local help