Movelast gives 'Rowset does not support fetching backward'
Posted on 2003-03-04
The following doesn't work, although it is not a forward-only cursor.
Conn.open Application("ConnectionString") ' Works fine throughout my software
set rstAllReceipts = Server.CreateObject("ADODB.RecordSet")
strQuery = "(select 1 as code, stack_detail_id as id_no from stack_detail where unit_no = 'U1') union (select 2, internal_movement_id from internal_movement where toUnit_no = 'U1') order by 1,2"
rstAllReceipts.open strQuery, conn, 1, 3 ' Tried with 2,3 too
' The Movelast statement gives the error "Rowset does not support fetching backward"
If I modify my SQL statement to "select * from stack_detail order by unit_no" then it works fine.
Kindly suggest me solution.