Professional Web Applications Themes

SQLSetPos with SQL_UPDATE not working - MySQL

MySQL version: 4.1.20 MyODBC version: 3.51.12-2 After doing a SQLFetchScroll, I update one or more columns. Then I do a rc = SQLSetPos(hstmt, 1, SQL_UPDATE, SQL_LOCK_NO_CHANGE); to do the updates. Nothing happens. I even ran tcpdump to see what (if anything) was going across the wire. I see the query, the result passed back after the SQLFetchScroll, but nothing else. So when I say "Nothing happens", I really mean, NOTHING happens! I've tried various settings settings in the driver. I've tried using SQL_CURSOR_STATIC, and SQL_CURSOR_DYNAMIC, and I've tried with and without SQLSetConnectAttr(hdbc, SQL_ATTR_ODBC_CURSORS, (void*)SQL_CUR_USE_ODBC, 0); Does this not work, or ...

  1. #1

    Default SQLSetPos with SQL_UPDATE not working

    MySQL version: 4.1.20
    MyODBC version: 3.51.12-2

    After doing a SQLFetchScroll, I update one or more columns. Then I do a
    rc = SQLSetPos(hstmt, 1, SQL_UPDATE, SQL_LOCK_NO_CHANGE);
    to do the updates. Nothing happens.

    I even ran tcpdump to see what (if anything) was going across the wire.
    I see the query, the result passed back after the SQLFetchScroll, but
    nothing else. So when I say "Nothing happens", I really mean, NOTHING
    happens!

    I've tried various settings settings in the driver. I've tried using
    SQL_CURSOR_STATIC, and SQL_CURSOR_DYNAMIC, and I've tried with and
    without SQLSetConnectAttr(hdbc, SQL_ATTR_ODBC_CURSORS,
    (void*)SQL_CUR_USE_ODBC, 0);


    Does this not work, or am I missing something?

    Thanks!
    jcf
    John C. Frickson Guest

  2. #2

    Default Re: SQLSetPos with SQL_UPDATE not working

    Maybe I'm asking the wrong question. Does anybody actually have updates
    through SQLSetPos working? If so, I'd like to see your driver settings
    and code snippets.

    John C. Frickson wrote:
    > MySQL version: 4.1.20
    > MyODBC version: 3.51.12-2
    >
    > After doing a SQLFetchScroll, I update one or more columns. Then I do a
    > rc = SQLSetPos(hstmt, 1, SQL_UPDATE, SQL_LOCK_NO_CHANGE);
    > to do the updates. Nothing happens.
    >
    > I even ran tcpdump to see what (if anything) was going across the wire.
    > I see the query, the result passed back after the SQLFetchScroll, but
    > nothing else. So when I say "Nothing happens", I really mean, NOTHING
    > happens!
    >
    > I've tried various settings settings in the driver. I've tried using
    > SQL_CURSOR_STATIC, and SQL_CURSOR_DYNAMIC, and I've tried with and
    > without SQLSetConnectAttr(hdbc, SQL_ATTR_ODBC_CURSORS,
    > (void*)SQL_CUR_USE_ODBC, 0);
    >
    >
    > Does this not work, or am I missing something?
    >
    > Thanks!
    > jcf
    John C. Frickson Guest

  3. #3

    Default Re: SQLSetPos with SQL_UPDATE not working

    Update: Something I did got me further along. It's still not working,
    but now it looks like a bug in the driver (very weird update query.)

    John C. Frickson wrote:
    > Maybe I'm asking the wrong question. Does anybody actually have updates
    > through SQLSetPos working? If so, I'd like to see your driver settings
    > and code snippets.
    >
    > John C. Frickson wrote:
    >> MySQL version: 4.1.20
    >> MyODBC version: 3.51.12-2
    >>
    >> After doing a SQLFetchScroll, I update one or more columns. Then I do a
    >> rc = SQLSetPos(hstmt, 1, SQL_UPDATE, SQL_LOCK_NO_CHANGE);
    >> to do the updates. Nothing happens.
    >>
    >> I even ran tcpdump to see what (if anything) was going across the wire.
    >> I see the query, the result passed back after the SQLFetchScroll, but
    >> nothing else. So when I say "Nothing happens", I really mean, NOTHING
    >> happens!
    >>
    >> I've tried various settings settings in the driver. I've tried using
    >> SQL_CURSOR_STATIC, and SQL_CURSOR_DYNAMIC, and I've tried with and
    >> without SQLSetConnectAttr(hdbc, SQL_ATTR_ODBC_CURSORS,
    >> (void*)SQL_CUR_USE_ODBC, 0);
    >>
    >>
    >> Does this not work, or am I missing something?
    >>
    >> Thanks!
    >> jcf
    John C. Frickson Guest

Similar Threads

  1. #38816 [Opn]: PHP code that was working perfectly recently stopped working.
    By mtoohee at gmail dot com in forum PHP Programming
    Replies: 0
    Last Post: September 13th, 09:41 PM
  2. Replies: 0
    Last Post: November 26th, 06:47 AM
  3. Data not working on Label but is working in Datagrid
    By KetanS in forum Macromedia Flex General Discussion
    Replies: 4
    Last Post: June 11th, 03:56 AM
  4. Working TableStyle Not Working on a Second DataGrid
    By psibertrip in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: May 7th, 04:57 PM
  5. ASP not working
    By Bruce Jackson in forum ASP Components
    Replies: 6
    Last Post: November 1st, 08:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139