FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> 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