Skip to Content.
Sympa Menu

freetds - Re: [freetds] Want to use fast forward cursors (SQL_CO_FFO) and MARS

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] Want to use fast forward cursors (SQL_CO_FFO) and MARS
  • Date: Wed, 7 May 2008 15:20:39 +0200

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




Archive powered by MHonArc 2.6.24.

Top of Page