PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • List of supported types
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
SQLColumnFormat (Function)
In French: SQLFormatColonne
OLE DBNot available with this kind of connection
Returns the different types of columns supported:
Versions 19 and later
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
New in version 19
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
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. See remarks for more details.
<Connection Name>: Optional character string (with quotes)
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-size string9
SQL_NUMERICNumeric10
SQL_DECIMALDecimal number11
SQL_INTEGERInteger12
SQL_SMALLINTInteger13
SQL_FLOATReal14
SQL_REALReal15
SQL_DOUBLEReal16
SQL_DATEDate17
SQL_TIMETime18
SQL_TIMESTAMPDate + Time19
SQL_VARCHARFixed-size string20
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment