Try this: http://www.w3schools.com/sql/default.asp
@Nyc: Thank you! Could you also recommend a book or a video tutorial?
I am rather interested in an "offline"-database, because I do not want to upload the SQLite DB.
SQL works almost the same regardless of the database system you use. The syntax for SQLite, MySQL, and other SQL based system is almost the same. I don't know any video tutorial perhaps searching the web may help.
@Nyc: Yay! Thanks!
Did the Unicode version ever eventuate? Got problems ordering results on a Unicode dataset. (Work around is read results into an object and sort them there) - but some results may be obscured.
- Or is there another option, like ODBC?
Also apols for digging up a long dead thread.
If you want it, you can get via signing up to my Patreon. One off payment is fine, but monthly helps pay for more exts and service maintenance (like Darkwire ext list and Lacewing servers).
Thanks @phi yes, aware of your Patreon, I know you have other cool stuff locked away in there too. Thanks for making me re-aware of it Jumped right in!
Excuse: I stuck this issue on the backlog and have finally returned to it.
And apologies I missed your response, really don't check in here often enough!
Further research, as the DB is Sqlite, generated by another app (Mediamonkey) that I can probably use this driver: http://www.ch-werner.de/sqliteodbc/, some mucking around in ODBC admin and potentially your object.. (Heaps of problems trying to automate it into mysql or something more sensible, lots of rows and complications) Got any more info on your object? Probably just willing to try it out, as the web query one is also interesting.