This issue is similar to the following post in that I am seeing SQLite error (1): near “AND”: syntax error when trying to refresh the map after adding sqlitefeaturelayer. The layer does not display. Data in the table is good and I can query it using system.data.sqlite commands and return data no problem.
The error also persists if I try and getallfeatures just as in the post.
My where clause has no “AND” in it, so can you please tell me what this syntax issue could be? What queries are behind the scenes?
I am using an rtree index which I have implemented identically to other tables in the same model that display their data on the map. They appear to be populated properly so doesn’t seem there is any mismatches that would affect the display.