On 2015-03-21 06:27 AM, danap at dandymadeproductions.com wrote: > Hello, > > PRAGMA index_list(table-name) > > In Sqlite's past history has PRAGMA index_list(table-name) returned a > SQLException indicating no ResultSet or a non-empty ResultSet that may > throw an exception on accessing the fields in the normal way?
Nope, not in the past and not currently. (There are very many test suites that check for this and has to be passed before any release date). That specific pragma very often returns an empty result-set, not the usual case with other queries, so that might be worth testing your code for. Other than that it has much the same internal process than any other query. If you post some code, some people here are bound to use the same platform / wrapper / interface and may have gotten the same kind of thing before. Good luck, Ryan
