On 15-02-2021 16:45, Dimitry Sibiryakov wrote:
15.02.2021 16:21, Alex Peshkoff via Firebird-devel wrote:
Trying to position in non-existent place should better raise error.

  According to ODBC (which is the most-established DB API) specs of SQLFetchScroll() function fetching beyond record set must end up to fixed "before start"/"after end" positions and return SQL_NO_DATA.


I could live with that behaviour. Because that would match with how FETCH NEXT / PRIOR currently already behave when positioned further out of bounds. Right now, it is only FETCH RELATIVE where the actual amount you're out of bounds matters, and having FETCH RELATIVE 1 behave as FETCH NEXT and FETCH RELATIVE -1 as FETCH PRIOR sounds reasonable.

Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to