Lost end-of-file On Sybase table when accessed thru sql statement

[goldi]

I am using VB6 with a sybase database. When I open a table using an SQL statement containing a "Where" clause I seem to lose the End-Of-File marker.

I can use MOVEFIRST, MOVENEXT, and MOVEPREVIOUS (if I haven't reached the end of file), but I cannot use MOVELAST (I get a BOF,EOF error). If I reach end-of-file (using MOVENEXT), the program recognizes that it is end-of-file, but if I then try to do a MOVEPREVIOUS to put the cursor back on the last record I get a BOF, EOF error. If I then do another MOVENEXT I find myself at the beginning of the file again. So, it's looping, but I want to be able to find the end-of-file and use the MOVELAST command.

Anyone have any suggestions?