Labar, Ken wrote: > [...] > select (rtTableSort < 1000) as selected, abbrString from userParameter order > by abbrString; > > This used to work until we upgraded sqlite to v3.8.2. It still does work at > the PC level.
What is the EXPLAIN QUERY PLAN output for this query on the handheld? When it works, it uses the index on the sort column to ensure that records are returned in the correct order: 0|0|0|SCAN TABLE userParameter USING INDEX idxAbbrString Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users