--- David M X Green <[EMAIL PROTECTED]> wrote: > I'm trying sqlite3 run on WinXP by console using > (1) cygwin bash & > (2) bash run on rxvt. > I find sqlite3 - interactive does not work well with .help. > With just bash only part of the help printed to the screen; though the second > attempt seemed to > provide the complete listing. > With rxvt-bash all the help text appears but only with some difficulty such > as three .help's in > succession at the command line to get any result at all. Another way of > obtaining the .help text > is to .quit after .help, at which help test appears. > Other communication from sqlite appears to work, eg .show .schema & select, > though I have not > tested it thoroughly. I have not changed the stdout sqlite3 option, which is > set to stdout as > shown by .show. > Why is it that .help in particular does not work properly? > > Using the windows command-line console things appear to work fine. > The rxvt window is preferable to the Windows command line so it would be > useful to use it > reliably if possible. However I see that rxvt does not work with > interactively with a simple > program compiled from c, which does a lot worse than the sqlite3.exe. > > It seems that rxvt is capable of working with sqlite3.exe but just with some > remaining problems. > > Any way of fixing these issues? > Thank you > David M X Green
The sqlite3.exe file on sqlite.org was compiled with MinGW (a cross MinGW from Linux to be precise) and is not a proper Cygwin executable, and as result it has no notion of isatty() to tell whether it is run from a terminal, and its stdout/stderr buffering is screwed up when not run from a Windows console window. You can run it from rxvt like this with recent versions of sqlite3: sqlite3 -interactive foo.db Or, even better, just build it from scratch so it will work with readline (up and down arrow keys to get previous commands). wget http://sqlite.org/sqlite-3.3.12.tar.gz tar xzvf sqlite-3.3.12.tar.gz cd sqlite-3.3.12 ./configure && make sqlite3.exe ./sqlite3.exe If I did not make a typo, it should work. ____________________________________________________________________________________ Don't get soaked. Take a quick peak at the forecast with the Yahoo! Search weather shortcut. http://tools.search.yahoo.com/shortcuts/#loc_weather ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
