On Wed, 15 Nov 2006 19:15:38 -0000, you wrote: >Hi Kees, > >Thanks a lot for that. All working perfect now. >I think all this should be on the SQLite site as >it took me a long time to get this fixed.
http://www.sqlite.org/sqlite.html and the .help command taught me the commands, http://www.sqlite.org/lang.html the SQL as understood by sqlite; the rest is straight shell scripting, redirecting and piping. Which is nasty at first, but quite powerful once you get used to it. Worth to learn, really. But not really on topic on the sqlite site. But here are some hints: On windows NT4, 2000, XP and 2003 you're better off with writing .cmd scripts instead of .bat. .cmd is interpreted by CMD.EXE, which is much more powerful than command.exe, which is (usually) interpreted by the legacy command.exe command shell. Add some tools like make (for process management) and gawk (for data cleaning, input filtering and transformations), and there's your database factory ;) CMD.EXE even allows you to use forward slashes, you just have to put paths and filenames between double quotes as in "disk:/path/filename.extension". For easy table browsing and testing I use the excellent Sqlite3Explorer by Mike Cariotoglou (see http://www.sqlite.org/cvstrac/wiki?p=ManagementTools for a pointer), which even includes a query editor and a report generator. >Nogmaals bedankt. Veel plezier! >RBS -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------