FreeTDS Development Group

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

So far I have one remaining "FIXME" comment in my FreeTDS driver interface, 
regarding fast forward cursors...

With the native MSSQL ODBC drivers, when you set:

  r = SQLSetStmtAttr(st->stmtHandle, SQL_SOPT_SS_CURSOR_OPTIONS, (SQLPOINTER) 
SQL_CO_FFO, SQL_IS_UINTEGER);

You get fast forward-only cursors, as described in:

http://msdn2.microsoft.com/en-us/library/aa172573.aspx

Note this is a SQL Server 2000 feature...

Other link:

http://msdn2.microsoft.com/en-us/library/aa177106(SQL.80).aspx

I was wondering how difficult it would be to support this MSSQL specific 
statement attribute...

If it's just a matter of sp_cursoroption, then you should...

Attached a sample (must compile with -D USE_FAST_FOWARD to use FFO cursor)

I noticed that SQL Profiler should different values in the @p5 and @p6 
parameters of the sp_cursorprepexec() call:

With FFO:

@p5=16
@p6=1

With SQL_NONSCROLLABLE / SQL_SENSITIVE:

@p5=4
@p6=4

Tested with SQL Server 2005 ...

Thanks!
Seb