Lukas Haase schrieb: > Igor Tandetnik schrieb: >> "Lukas Haase" <[email protected]> wrote in >> message news:[email protected] >>> I use an SQLite database to fill a virtual list control in Windows. In >>> this control, I just tell the control the numer of my elements and the >>> control tells me for which range data is needed. > [...] > However, I solved this, even if not so performant, according to your link. > > The actual problem is the find-function: From my 1000-elements > resultset, I need to pass to Windows that index (between 1 and 1000!) > that fits best to the search criterion.
Yeah, yeah, I think I had a flash of genius right now! Very simple, I don't know why I did not come to this earlier... SELECT COUNT(*) FROM keywords WHERE keyword < '%s*' ORDER BY keyword ASC; where %s is the string to be found :-) Luke _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
