Re: Want to use fast forward cursors (SQL_CO_FFO) and MARS

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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>