[freetds] SQLRowCount failing after prepare and execute

Frediano Ziglio freddyz77 at tin.it
Sat Feb 14 08:26:41 EST 2004


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





More information about the FreeTDS mailing list