{"action":"created","issue":{"url":"https://api.github.com/repos/ccgus/fmdb/issues/145","labels_url":"https://api.github.com/repos/ccgus/fmdb/issues/145/labels{/name}","comments_url":"https://api.github.com/repos/ccgus/fmdb/issues/145/comments","events_url":"https://api.github.com/repos/ccgus/fmdb/issues/145/events","html_url":"https://github.com/ccgus/fmdb/issues/145","id":14014698,"number":145,"title":"[Feature] Is possible to have [FMResultSet previous] and/or [FMResultSet goRecord:1]?","user":{"login":"mamcx","id":238983,"avatar_url":"https://avatars.githubusercontent.com/u/238983?v=3","gravatar_id":"","url":"https://api.github.com/users/mamcx","html_url":"https://github.com/mamcx","followers_url":"https://api.github.com/users/mamcx/followers","following_url":"https://api.github.com/users/mamcx/following{/other_user}","gists_url":"https://api.github.com/users/mamcx/gists{/gist_id}","starred_url":"https://api.github.com/users/mamcx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mamcx/subscriptions","organizations_url":"https://api.github.com/users/mamcx/orgs","repos_url":"https://api.github.com/users/mamcx/repos","events_url":"https://api.github.com/users/mamcx/events{/privacy}","received_events_url":"https://api.github.com/users/mamcx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2013-05-06T18:42:42Z","updated_at":"2015-07-12T00:40:28Z","closed_at":null,"body":"To use sqlite for populate UITableViews, I copy all the data to NSArrays/Dicts so I can travel back/forward on the list. However, this is wastefull and requiere to have the data twice.\r\n\r\nI wonder if is possible to have [FMResultSet previous] and/or [FMResultSet goRecord:RECNO] so I can get rid of the copy and use a FMResultSet directly."},"comment":{"url":"https://api.github.com/repos/ccgus/fmdb/issues/comments/120674348","html_url":"https://github.com/ccgus/fmdb/issues/145#issuecomment-120674348","issue_url":"https://api.github.com/repos/ccgus/fmdb/issues/145","id":120674348,"user":{"login":"danielmj","id":3281823,"avatar_url":"https://avatars.githubusercontent.com/u/3281823?v=3","gravatar_id":"","url":"https://api.github.com/users/danielmj","html_url":"https://github.com/danielmj","followers_url":"https://api.github.com/users/danielmj/followers","following_url":"https://api.github.com/users/danielmj/following{/other_user}","gists_url":"https://api.github.com/users/danielmj/gists{/gist_id}","starred_url":"https://api.github.com/users/danielmj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielmj/subscriptions","organizations_url":"https://api.github.com/users/danielmj/orgs","repos_url":"https://api.github.com/users/danielmj/repos","events_url":"https://api.github.com/users/danielmj/events{/privacy}","received_events_url":"https://api.github.com/users/danielmj/received_events","type":"User","site_admin":false},"created_at":"2015-07-12T00:40:28Z","updated_at":"2015-07-12T00:40:28Z","body":"Unfortunately, there is no way to step backward. This is a limitation on SQLite. Please reference the following (albeit deprecated) page: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor . Even though the page is deprecated, the concepts should still hold true.\r\n\r\nIf you are interested in making it easier to work with table view, check out this script I made to hopefully make working with tables on iOS easier. https://github.com/danielmj/SQLFetchedResultsController"}}