|FAQ FOR WINDEV, WEBDEV|
AND WINDEV MOBILE
|FAQ #2521, published on 2002-10-15|
|I am using the commands SQLColumn() and SQLListTable() under Oracle. |
How can I speed up these commands?
|These two commands will list the tables and table columns of your |
Oracle database. We suggest to limit the number of tables and columns to
For the command SQLListTable() you may use the following syntax:
SQLListTable(False,True). Setting the second parameter to True allows you to indicate that you do not want to get a list of temporary tables, system tables, alias tables, etc.
For the command SQLColumn() we suggest to use the following syntax:
SQLColumn(NumConnection,"OWNER.CLIENT"). Prefixing the table owner as the table name allows you to get an almost immediate result.
|Informations contained on this site are the exclusive property of PC SOFT. These informations and logos CANNOT be copied and/or used without a written authorization from PC SOFT. |
© PC SOFT 2004-2017.