freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] SQLRowCount failing after prepare and execute

From: Frediano Ziglio <freddyz77 AT tin.it>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] SQLRowCount failing after prepare and execute
Date: 14 Feb 2004 14:26:41 +0100

Il sab, 2004-02-14 alle 14:11, Thompbil18 AT aol.com ha scritto:
> Hey Freddy,
>
> Correct me if I'm wrong - is this discussion the same as the one we had a
> while ago about the ODBC test program "moreandcount" after my ct-lib patch
> ?
>
> Bill
>

It's related. ODBC seems to discard insert/delete/update inside
procedure (or inside prepared statement, for implementation details it's
the same). However there are other raised problems:
- does ODBC cache row counts and return last valid one (so even last
statement in prepared/store procedure are returned) ?
- when should SQLRowCount return error 24000 (Invalid cursor state) ?
I have to do some tests (and update moreandcount test too)

freddy77

[freetds] SQLRowCount failing after prepare and execute, Matthew A. Davis, 02/12/2004
- Re: [freetds] SQLRowCount failing after prepare and execute, Frediano Ziglio, 02/13/2004
  - Re: [freetds] SQLRowCount failing after prepare and execute, Matthew A. Davis, 02/13/2004
    - Re: [freetds] SQLRowCount failing after prepare and execute, Frediano Ziglio, 02/13/2004
      - Re: [freetds] SQLRowCount failing after prepare and execute, Matthew A. Davis, 02/13/2004
        
        Re: [freetds] SQLRowCount failing after prepare and execute, James K. Lowden, 02/13/2004
- <Possible follow-up(s)>
- Re: [freetds] SQLRowCount failing after prepare and execute, Thompbil18, 02/14/2004
  - Re: [freetds] SQLRowCount failing after prepare and execute, Frediano Ziglio, 02/14/2004
    - Re: [freetds] SQLRowCount failing after prepare and execute, Frediano Ziglio, 02/14/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, Thompson, Bill D (London), 02/16/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, ZIGLIO, Frediano, VF-IT, 02/16/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, Thompson, Bill D (London), 02/16/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, ZIGLIO, Frediano, VF-IT, 02/16/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, Thompson, Bill D (London), 02/16/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, ZIGLIO, Frediano, VF-IT, 02/16/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, Thompson, Bill D (London), 02/16/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, ZIGLIO, Frediano, VF-IT, 02/16/2004
- RE: [freetds] SQLRowCount failing after prepare and execute, Thompson, Bill D (London), 02/17/2004