Using Win32 functions in Visual FoxPro Image Gallery
ODBC API
..msdn
SQLAllocEnv
SQLAllocHandle
SQLBindCol
SQLBrowseConnect
SQLConfigDataSource
SQLConnect
SQLCreateDataSource
SQLDataSources
SQLDisconnect
SQLDriverConnect
SQLDrivers
SQLExecDirect
SQLFetch
SQLFreeEnv
SQLFreeHandle
SQLGetConfigMode
SQLGetConnectAttr
SQLGetDiagRec
SQLGetEnvAttr
SQLGetFunctions
SQLGetInfo
SQLGetInstalledDrivers
SQLGetPrivateProfileString
SQLInstallerError
SQLManageDataSources
SQLNativeSql
SQLRowCount
SQLSetConfigMode
SQLSetEnvAttr
SQLTables
Code examples:
Obtaining list of tables stored in an ODBC Data Source
SQLTables
..msdn    Add comment     W32 Constants      Translate this page
Returns the list of table, catalog, or schema names, and table types, stored in a specific data source. The driver returns the information as a result set.
Code examples:
Obtaining list of tables stored in an ODBC Data Source
Declaration:
SQLRETURN SQLTables(
    SQLHSTMT    StatementHandle,
    SQLCHAR *   CatalogName,
    SQLSMALLINT NameLength1,
    SQLCHAR *   SchemaName,
    SQLSMALLINT NameLength2,
    SQLCHAR *   TableName,
    SQLSMALLINT NameLength3,
    SQLCHAR *   TableType,
    SQLSMALLINT NameLength4);
FoxPro declaration:
DECLARE SHORT SQLTables IN odbc32 AS SQLTables32;
    INTEGER StatementHandle,;
    STRING  CatalogName,;
    SHORT   NameLen1,;
    STRING  SchemaName,;
    SHORT   NameLen2,;
    STRING  TableName,;
    SHORT   NameLen3,;
    STRING  TableType,;
    SHORT   NameLen4

Parameters:
StatementHandle
[Input]
Statement handle for retrieved results.

CatalogName
[Input]
Catalog name.

NameLength1
[Input]
Length in characters of *CatalogName.

SchemaName
[Input]
String search pattern for schema names.

NameLength2
[Input]
Length in characters of *SchemaName.

TableName
[Input]
String search pattern for table names.

NameLength3
[Input]
Length in characters of *TableName.

TableType
[Input]
List of table types to match.

NameLength4
[Input]
Length in characters of *TableType.
Return value:
SQL_SUCCESS (0), SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR (-1), or SQL_INVALID_HANDLE.
My comment:
FoxPro native SQLTables() function is practically an ideal wrapper for this API routine. So in most cases staying within FoxPro functionality is more convenient.
Word Index links for the SQLTables :
Translate this page:
  Spanish    Portuguese    German    French    Italian  
FreeTranslation.com offers instant, free translations of text or web pages.
Created: 2003-05-28 08:58:14
Modified: 2003-05-28 09:06:14
Visited in last 7 days: 7
User Contributed Notes:
There are no notes on this subject.


Copyright 2001-2014 News2News, Inc. Before reproducing or distributing any data from this site please ask for an approval from its owner. Unless otherwise specified, this page is for your personal and non-commercial use. The information on this page is presented AS IS, meaning that you may use it at your own risk. Microsoft Visual FoxPro and Windows are trade marks of Microsoft Corp. All other trademarks are the property of their respective owners. 

Privacy policy
Credits: PHP (4.4.9), an HTML-embedded scripting language, MySQL (5.1.68), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice.   Hosted by Korax Online Inc.
Last Topics Visited (54.197.45.100)
1.5 min.Function: 'CreateWindowEx'
5.02 min.Function: 'midiOutGetNumDevs'
Function group: 'Windows Multimedia'
8.61 hrs.Example: 'Retrieving the state of your Internet connection'
8.62 hrs.Function: 'GetWindowLong'
8.65 hrs.Function: 'CryptHashData'
Function group: 'Cryptography Reference'
2 day(s)Function: 'HeapSize'
 
Function group: 'Authentication'
 Function: 'FillRect'
 Example: 'Retrieving information specific to the current Time Zone'
 Function: 'VirtualAllocEx'
Function group: 'Memory Management'
Google
Advertise here!