+100 on SQLite Expert. I used the free version for about a month, but found it to be so useful, and with the life time upgrades feature, had to purchase to get the whole thing. The developer also spies on all of us in here, and is usually quick to reply to emails from registered users. (Unless I catch him on vacation or something. ;))
One of the features that are in SQLite expert is a GUI SQL builder. You basically drag and drop tables from one pane into another, drag lines between different fields, set conditions for each field, then a right-click and a left-click on the popup menu and you get a working SQL string as well as results of the query, to which you can then tune either via the SQL code, or go back to the GUI and rebuild. On Fri, Sep 13, 2013 at 12:19 PM, dochsm <docshotma...@hotmail.com> wrote: > I agree with the other poster. You can just use any string manipluation > routines you like to assemble the SQL into a string and then execute it. > Take care with literals, eg where name = 'fred' might have to become where > name = ''fred'' in Delphi (thats two single quotes at each end). > > If it's any help, two brilliant tools that I use are SQLinForm > (http://www.sqlinform.com) and SQLite Expert > (http://www.sqliteexpert.com/). > > SQLinForm lets me take some sql that I know works and with one click format > it to generate a string in loads of languages. So for example the sql.. > > select name from people where age = 30; > > becomes > > SQL := '' > +'SELECT name ' > +'FROM people ' > +'WHERE age = 30;'; > > and you can then copy/paste it into your editor and tweak it to accept > variables at runtime instead. > > SqliteExpert is simply the best database management system for SQLite that > I > have come across (and I've tried a few!) I can try out my sql, make tables, > see data and do all the manipulation I like. > Two tools I wouldn't be without when developing. > > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/Dynamically-generate-SQL-statements-for-SQLite-tp71240p71243.html > Sent from the SQLite mailing list archive at Nabble.com. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
