Search
Module:
Directory

   Desktop Functions:

   Smart Device Functions:


Show Recent Changes
Subscribe (RSS)
Misc. Pages
Comments
FAQ
Helpful Tools
Playground
Suggested Reading
Website TODO List
Download Visual Studio Add-In

SQLFetch (odbc32)
 
.
Summary
Returns a result row.

C# Signature:

  [DllImport("odbc32.dll")]
  static extern short SQLFetch(IntPtr StatementHandle);

VB Signature:

<Runtime.InteropServices.DllImport("odbc32.dll", CharSet:=Runtime.InteropServices.CharSet.Unicode)> _
    Private Function SQLFetch(ByVal statementHandle As IntPtr) As Short
    End Function

User-Defined Types:

None.

Alternative Managed API:

Do you know one? Please contribute it!

Notes:

None.

Tips & Tricks:

Please add some!

Sample Code:

    bool Fetch()
    {
        bool  ret = isOK(SQLFetch(statementHandle));
        if (ret == false)
        {
            //ignore end-of-file errors
            string maybe_err = GetError();
            if (maybe_err!=null)
            {
                throw new Exception(maybe_err);
            }
        }
        return ret;
    }

    bool isOK(int ret)
    {
        return ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO;
    }

Documentation
SQLFetch on MSDN

Please edit this page!

Do you have...

  • helpful tips or sample code to share for using this API in managed code?
  • corrections to the existing content?
  • variations of the signature you want to share?
  • additional languages you want to include?

Select "Edit This Page" on the right hand toolbar and edit it! Or add new pages containing supporting types needed for this API (structures, delegates, and more).

 
Access PInvoke.net directly from VS:
Terms of Use
Edit This Page
Find References
Show Printable Version
Revisions