PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Tip: How to speed up the execution time of SQLListTable?
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
List all the tables that can be accessed by the connected database system.
Versions 19 and later
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (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).
New in version 19
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (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 Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (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).
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
// Non-detailed list of tables
Str is string = SQLListTable(False)
Str = NoSpace(Str)
// Add into a List Box control
ListAdd(LIST_TableList, Str)
// Detailed list
Str is string = SQLListTable()
Str = NoSpace(Str)
// Add into a Table control
TableAdd(TABLE_SOURCETAB, Str)
Str is string = SQLListTable()
Str = NoSpace(Str)
// Processes the first line returned
Str = ExtractString(Str, 1, CR)
// Extract the name of the table
Name = ExtractString(Str, 1)
// Extract the qualifier
Qual = ExtractString(Str, 2)
// Extract the owner
Prop = ExtractString(Str, 3)
// Extract the type of table
Type = ExtractString(Str, 4)
Syntax
<Result> = SQLListTable([<Detailed List> [, <Elements to List>]])
<Result>: Character string
Characteristics (detailed or not) of each element listed for the current connection. These characteristics can be inserted into a list box by ListAdd.
  • Detailed characteristics:
    <Name of table> + TAB + <Qualifier> + TAB + <Owner of table> +
    TAB + <Type of table> + CR + <Name of table 2> + TAB + <Qualifier 2> +
    TAB + <Owner of table 2> + <Type of table 2> + CR +...
  • Non-detailed characteristics:
    <Name of Table 1> + CR + <Name of Table 2> + CR +...
PHP Only the non-detailed characteristics of each element are listed.
Java The qualifier and the owner of the table are not displayed.
<Detailed List>: Optional boolean
  • True (default value) to get a detailed list,
  • False to get a non-detailed list.
PHP Only the non-detailed characteristics of each element are listed.
<Elements to List>: Optional boolean
  • True to list the tables and the views,
  • False (default value) to list:
    • via an OLE DB provider: the tables, the views and the system tables
    • via an ODBC driver: the tables, the views, the system tables, the aliases, ... Caution: this operation may be quite slow when accessing Oracle via ODBC because the ORACLE database includes an important number of tables.
Remarks

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

The following syntax is recommended:
SQLListTable(False, True)
The second parameter is set to True to indicate that the temporary tables, the systems, the aliases, ... must not be listed.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment