FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Freddy

> Does Microsoft's version stop at the first DONEINPROC?  
> 

Yes. Assume that server return large text/image data on select, client
cannot cache all rows so it has to stop at first recordset (I tested and
it stops even if recordset is empty).


Stopping at the first result set is not the same as stopping at the first
DONEINPROC

There may be DONEINPROC with no result set...



Bill

> -----Original Message-----
> From: ZIGLIO, Frediano, VF-IT [SMTP:Frediano.Ziglio AT vodafone.com]
> Sent: 09 March 2004 15:33
> To:   FreeTDS Development Group
> Subject:      RE: [freetds] ODBC - binary, row count and compatibility
> 
> > 
> > On Tue, 9 Mar 2004, "ZIGLIO, Frediano, VF-IT"
> > <Frediano.Ziglio AT vodafone.com> wrote:
> > > >   81(TDS7_RESULT)
> > > >   ff(DONEINPROC)
> > > >   81(TDS7_RESULT)
> > > >   aa(ERROR)
> > > >   ff(DONEINPROC)
> > > >   79(RETURNSTATUS)
> > > >   fe(DONEPROC)
> > > > 
> > > > it can't return SUCCESS just because that last DONEPROC was 
> > > > OK.  It has to
> > > > notify the client there was an intervening ERROR.  
> > > 
> > > SQLExecDirect stop at first DONE, so it do not see the 
> > ERROR token and
> > > returns SQL_SUCCESS.
> > 
> > Does Microsoft's version stop at the first DONEINPROC?  
> > 
> 
> Yes. Assume that server return large text/image data on select, client
> cannot cache all rows so it has to stop at first recordset (I tested and
> it stops even if recordset is empty).
> 
> > I don't understand how SQLExecDirect() can (correctly) stop before
> > DONEPROC.  How is the application expected to learn of the ERROR?  
> > 
> 
> I think on next SQLMoreResults or perhaps on SQLFetch (I didn't test
> it)...
> >From lang_error test calling SQLExecDirect("SELECT
> DATEADD(dd,-100000,getdate())") return SQL_ERROR.
> 
> 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/>

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