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:
Establishing connection using the SQLDriverConnect
How to obtain the number of rows affected by remote UPDATE, INSERT or DELETE statement
Retrieving current settings for an ODBC connection
SQLGetDiagRec
..msdn    Add comment     W32 Constants      Translate this page
SQLGetDiagRec returns the current values of multiple fields of a diagnostic record that contains error, warning, and status information.
Code examples:
Establishing connection using the SQLDriverConnect
Retrieving current settings for an ODBC connection
How to obtain the number of rows affected by remote UPDATE, INSERT or DELETE statement
Declaration:
SQLRETURN SQLGetDiagRec(
    SQLSMALLINT   HandleType,
    SQLHANDLE     Handle,
    SQLSMALLINT   RecNumber,
    SQLCHAR *     Sqlstate,
    SQLINTEGER *  NativeErrorPtr,
    QLCHAR *      MessageText,
    SQLSMALLINT   BufferLength,
    SQLSMALLINT * TextLengthPtr);
FoxPro declaration:
DECLARE SHORT SQLGetDiagRec IN odbc32;
    INTEGER   HandleType,;
    INTEGER   Handle,;
    INTEGER   RecNumber,;
    STRING  @ Sqlstate,;
    INTEGER @ NativeErrorPtr,;
    STRING  @ MsgText,;
    INTEGER   BufferLength,;
    INTEGER @ TextLengthPtr

Parameters:
HandleType
[Input]
A handle type identifier that describes the type of handle for which diagnostics are required.

Handle
[Input]
A handle for the diagnostic data structure, of the type indicated by HandleType.

RecNumber
[Input]
Indicates the status record from which the application seeks information. Status records are numbered from 1.

SQLState
[Output]
Pointer to a buffer in which to return a five-character SQLSTATE code pertaining to the diagnostic record RecNumber.

NativeErrorPtr
[Output]
Pointer to a buffer in which to return the native error code, specific to the data source.

MessageText
[Output]
Pointer to a buffer in which to return the diagnostic message text string.

BufferLength
[Input]
Length of the *MessageText buffer in characters.

TextLengthPtr
[Output]
Pointer to a buffer in which to return the total number of bytes available to return in *MessageText.
Return value:
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
Translate this page:
  Spanish    Portuguese    German    French    Italian  
FreeTranslation.com offers instant, free translations of text or web pages.
Created: 2002-03-21 20:35:06
Modified: 2002-03-21 20:38:43
Visited in last 7 days: 5
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.
Google
Advertise here!