[freetds] SQLRowCount failing after prepare and execute

Frediano Ziglio freddyz77 at tin.it
Fri Feb 13 14:57:33 EST 2004


Il ven, 2004-02-13 alle 20:23, Matthew A. Davis ha scritto:
> Frediano Ziglio wrote:
> > 
> > Il gio, 2004-02-12 alle 22:28, Matthew A. Davis ha scritto:
> > > When I send an UPDATE using SQLExecDirect(), then check the number of affected rows, all is fine.  When I send the same command using SQLPrepare() and SQLExecute(), checking the number of effected rows fails with SQLState 24000 (Invalid Cursor).
> > 
> > Hi Matthew!
> > I don't know if SQLRowCount should return error or no_row_count however
> > you won't be able to read row counts using SQLPrepare and insert. This
> > behavior reflect wire protocol and it's compatible with Microsoft ODBC.
> 
> Hi Freddy77,
> 
> Thanks for getting back to me.  I am doing an UPDATE, not an INSERT.  Getting row counts for UPDATES seems like a very important thing.  My understanding is that ODBC requires row counts to be available for UPDATE and DELETE.  (This makes sense - if you're inserting, you should know how many records
> you are inserting, and if you're selecting, you can count them as you fetch them.)
> 

delete, insert and update have the same behavior... if you use
SQLPrepare with sql server you are not able to get row count.

freddy77





More information about the FreeTDS mailing list