SQLFetch (odbc32)
Last changed: -201.0.182.247

.
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