The MSYS "start" command just circumvents the problem by starting a new clunky Windows cmd window. The Cygwin, Emacs and remote users logging into a Windows box via telnet/ssh who prefer to work in their native terminal program either have to hack the sqlite3 shell.c code to force an interactive session, or use a cygwin-compiled sqlite3.exe.
--- Dennis Cote <[EMAIL PROTECTED]> wrote: > You are correct. This is a common problem for Unix code under windows > (at least with MSYS), since isatty() doesn't work correctly. MSYS comes > with a start command to work around this issue. Instead of: > > sqlite3 ... > > you can use > > start sqlite3 ... > > at the MSYS prompt. It will start a windows command shell running > sqlite3 where the isatty returns the correct results, and hence the I/O > is flushed to the screen before any prompts for input. > > HTH > Dennis Cote > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com