Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQLFetch broken in HEAD?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQLFetch broken in HEAD?
  • Date: Thu, 6 Jul 2006 08:50:00 +0200

>
> From: Frediano Ziglio
> Sent: Tuesday, July 04, 2006 4:25 PM
> > Il giorno mar, 04/07/2006 alle 11.46 -0400, James K. Lowden ha
> scritto:
> > > ZIGLIO, Frediano, VF-IT wrote:
> > > > >
> > > > > > > > > I added a new unit test, src/odbc/unittests/rpc.c.
> > >
> > > I don't understand why SQLFetch returns SQL_NO_DATA_FOUND
> the first
> time
> > > it's called. How is that "correct behavior for ODBC"?
> What else am
> I
> > > supposed to do to get the data?
> > >
> >
> > This is procedure body
> >
> > select @null_input = max(convert(varchar(30), name)) from systypes
> > select @first_type = min(convert(varchar(30), name)) from systypes
> > select name from sysobjects where 0=1
> > select distinct convert(varchar(30), name) as 'type' from systypes
> > where name in ('int', 'char', 'text')
> > select @nrows = @@rowcount
> > select distinct convert(varchar(30), name) as name from sysobjects
> where type = 'S'
> > return 42
> >
> > first select return nothing (just an ignored DONEINPROC)
> > second select return nothing
> > third select (select name from sysobjects where 0=1)
> returns no row so
> > SQLFetch return NO_DATA
>
> First, my apologies. I didn't realize I needed to call
> SQLMoreResults.
> SQLFetch is OK. I committed a better version of my test.
>

No problem...

> Second, I believe result set processing is seriously broken.
> Please see
> my next message for details.
>

http://freetds.sourceforge.net/out/test/test103.html
I don't understand where the empty recordset came... perhaps it's return
?? Quite strange...

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page