Skip to Content.
Sympa Menu

freetds - RE: [freetds] SQLRowCount failing after prepare and execute

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] SQLRowCount failing after prepare and execute
  • Date: Mon, 16 Feb 2004 09:03:48 -0000

Freddy,

> Issuing this query (using SQLPrepare)
> select * from #tmp where i=2 delete from #tmp
> return 1 columns and 1 row !!!
> Simply 1 column from select and 1 row from delete.
> I updated moreandcount test to catch this case (I'll fix ASAP)

I'm not sure of the context of your findings.
Are these the behaviours of FreeTDS or of some other ODBC driver ?

Bill

> -----Original Message-----
> From: Frediano Ziglio [SMTP:freddyz77 AT tin.it]
> Sent: Saturday, February 14, 2004 7:48 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] SQLRowCount failing after prepare and execute
>
> Il sab, 2004-02-14 alle 14:26, Frediano Ziglio ha scritto:
> > 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
> >
>
> I did some strange and it's more complicated than I though...
>
> Assuming you create a table with this code
>
> create table #tmp (i int)
> insert into #tmp values(1)
>
> Issuing this query (using SQLPrepare)
>
> select * from #tmp where i=2 delete from #tmp
>
> return 1 columns and 1 row !!!
> Simply 1 column from select and 1 row from delete.
> I updated moreandcount test to catch this case (I'll fix ASAP)
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

==============================================================================

If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.
<http://www.ml.com/email_terms/>

==============================================================================





Archive powered by MHonArc 2.6.24.

Top of Page