FreeTDS Development Group

[Sebastien FLAESCH <sf AT 4js.com>]

Thanks a lot Frediano,

I will give it a try ASAP.

What do you mean by "used if cursors are enabled" = "server-side cursors"?

Seb

ZIGLIO, Frediano, VF-IT wrote:
> > > Hi all,
> > >
> > > I had a little review of our code and found a unique "FIXME" 
> > > to resolve:
> > >
> > > /* FIXME!
> > >      } else {                    / * Use fast forward cursor * /
> > >          r = SQLSetStmtAttr(st->stmtHandle, 
> > > SQL_SOPT_SS_CURSOR_OPTIONS,
> > >                             (SQLPOINTER) SQL_CO_FFO, 
> > SQL_IS_UINTEGER);
> > >          if (!SQL_SUCCEEDED(r)) {
> > >              DBGMSG(1, "Could not set SQL_SOPT_SS_CURSOR_OPTIONS");
> > >              return -1;
> > >          }
> > > */
> > >
> > > With the native SQL Server ODBC drivers (SNAC and MDAC), this option
> > > can be used from the odbcss.h header.
> > >
> > > Are there any plans to support this?
> > >
> > > BTW: What about MARS (Multiple Active Result Sets)?
> > >
> > > Thanks a lot!
> > > Seb
> > Currently there is no plan. However there are some things that we need
> > to address. ODBC has mainly ABI compatibility for constants. 
> > That is the
> > same constant has the same value on all platforms. Constants 
> > defined in
> > odbcss.h are not (correctly) in standard headers so we must 
> > define these
> > constants in some way. Where to define these constants? 
> > Should we create
> > a tdsodbcss.h header?? Or should we install it as odbcss.h?? Should we
> > install this header or not?? I think that these constant should be
> > defined when tdsodbc.h is included (this not means that these 
> > constants
> > have to be defined in tdsodbc.h!) so c source files won't change.
>
> Solved
>
> > And back to fast forward cursors, when is it possible to set fast
> > cursors? Only after setting some types of cursors? Does setting fast
> > cursors can change cursor type? Setting fast forward cursors 
> > is just an
> > advise that is used only with some cursors type (that is you 
> > can set for
> > all cursor types but used only on some values) or setting 
> > with improper
> > cursor type give error/warning ?? And what happen if we try to move
> > cursor position on a read-only forward only cursor (this 
> > apply not only
> > to fast forward) ?? I think all these questions should we 
> > answered with
> > a test.
>
> It's just an advise, it doesn't give any error, is used if cursors are
> enabled.
>
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds