Didn't know about .cmd scripts (not that I know much about .bat) and will have a look at that. There is a slim chance that some of my users are still on Win98, so that could be a problem.
Will have a look at Sqlite3Explorer as well. Only started with SQLite a few days ago, but I can see it is great software, especially as I only need as a local, temporary, one user database. Shame I don't know C. RBS -----Original Message----- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: 15 November 2006 20:22 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Importing text file via .bat file 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] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
