dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: OneEyeMan

Search: Search took 0.01 seconds.

  1. Replies
    9
    Views
    869

    Re: SQLSetPos failure

    Hi, guys,
    I got a suggestion to use SQLFetchScroll with SQL_FETCH_FIRST parameter.
    I will try to use that for now and if I hit an issue I will come back.

    Thank you.
  2. Replies
    9
    Views
    869

    Re: SQLSetPos failure

    Hi,
    I think the SQLSetPos will still fail as I will break from the loop with SQL_NO_DATA.
    Or am I missing something?

    Thank you.
  3. Replies
    9
    Views
    869

    Re: SQLSetPos failure

    Hi, Arjay,
    Here is the full loop:



    for( ret = SQLFetch( stmt ); ( ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO ) && ret != SQL_NO_DATA; ret = SQLFetch( stmt ) )

    After it is done, the...
  4. Replies
    9
    Views
    869

    Re: SQLSetPos failure

    Hi,
    After the initial Fetch() loop my cursor is positioned after the last record:



    for( ret = SQLFetch( stmt ); ( ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO ) && ret != SQL_NO_DATA;...
  5. Replies
    9
    Views
    869

    SQLSetPos failure

    Hi,
    I am trying to do follwing:
    Execute a query on the database and grab just some fields results.
    Then call SQLSetPos( stmt, 0, SQL_POSITION, SQL_LOCK_NO_CHANGE ); and then process the complete...
Results 1 to 5 of 5


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)