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:
Enumerating ODBC Data Sources available on the local computer
Establishing connection using the SQLDriverConnect
Obtaining list of tables stored in an ODBC Data Source
Retrieveing general information about the driver and data source associated with an ODBC connection
Testing an ODBC connection for supporting specific functionality
Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)
Using vendor-neutral SQL constructs
SQLAllocHandle
..msdn    Add comment     W32 Constants      Translate this page
SQLAllocHandle allocates an environment, connection, statement, or descriptor handle.
Code examples:
Obtaining list of tables stored in an ODBC Data Source
Retrieveing general information about the driver and data source associated with an ODBC connection
Establishing connection using the SQLDriverConnect
Enumerating ODBC Data Sources available on the local computer
Testing an ODBC connection for supporting specific functionality
Using vendor-neutral SQL constructs
Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)
Declaration:
SQLRETURN SQLAllocHandle(
     SQLSMALLINT     HandleType,
     SQLHANDLE     InputHandle,
     SQLHANDLE *     OutputHandlePtr);
FoxPro declaration:
DECLARE SHORT SQLAllocHandle IN odbc32;
    INTEGER   HandleType,;
    INTEGER   InputHandle,;
    INTEGER @ OutputHandlePtr
Parameters:
HandleType
[Input]
The type of handle to be allocated by SQLAllocHandle (predefined value).

InputHandle
[Input]
The input handle in whose context the new handle is to be allocated.

OutputHandlePtr
[Output]
Pointer to a buffer in which to return the handle to the newly allocated data structure.
Return value:
SQL_SUCCESS (0), SQL_SUCCESS_WITH_INFO, SQL_INVALID_HANDLE, or SQL_ERROR.
Translate this page:
  Spanish    Portuguese    German    French    Italian  
FreeTranslation.com offers instant, free translations of text or web pages.
Created: 2002-03-05 12:02:08
Modified: 2002-03-05 12:04:02
Visited in last 7 days: 63
User Contributed Notes:
There are no notes on this subject.


Copyright 2001-2017 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.6.38), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice.   Hosted by Korax Online Inc.
Last Topics Visited (54.198.134.32)
7 sec.Solutions
14 sec.Example: 'Adding and deleting Scheduled Tasks using NetScheduleJob API functions'
21 sec.Function: 'waveOutPrepareHeader'
Function group: 'Windows Multimedia'
28 sec.Function: 'InternetAutodialHangup'
Function group: 'Internet Functions (WinInet)'
34 sec.Example: 'Dragging files from Explorer window and dropping them on FoxPro control (requires VFP9)'
47 sec.Function: 'SQLAllocEnv'
Function group: 'ODBC API'
55 sec.Function: 'FtpDeleteFile'
1.05 min.Solutions
1.2 min.Function: 'GetFileAttributesEx'
Function group: 'File Management'
1.35 min.Gallery
Google
Advertise here!