From: Paulo Amorim <pauloamorim@uol.com.br>
>
>I'm using an ODBC Informix driver to connect to an IDS 7.30 database.
>The application is developed in Visual Basic using ASP code.
>
>When I try to use the cursor, I'm getting an error when I try to fetch
>backwards the cursor position. No problems when I fetch forwards. The
>error message is the following:
>
>"Microsoft OLE DB Provider for ODBC Drivers error '80040e24' The rowset
>does not support fetching backwards"
>
>I'm writing above the code which is causing the error:
>
>s_Select = "Select * from movimentocx order by idmovimento" rs.Open
>s_Select, Conn, 3, 3
>If Not rs.Bof or Not rs.Eof then
> rs.Movefirst -- No problem
> rs.MoveNext -- No problem
> rs.MovePrevious -- Error
> rs.MoveLast -- Causes an error too
> Do while...........
In the ODBC driver setup, there is a checkbox called Enable Scrollable
Cursors...
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com