Re: [sqlite] command line does not accept arrow keys

2009-11-21 Thread Qianqian Fang
hi Jay Jay A. Kreibich wrote: > Yes. Readline support is not on by default. > > You need to compile it with -DHAVE_READLINE and add -lreadline > to the linker: > > $ cc -DHAVE_READLINE -o sqlite3 sqlite3.c shell.c -lreadline recompiling sqlite3 from source code with your command solved the

Re: [sqlite] command line does not accept arrow keys

2009-11-20 Thread Jay A. Kreibich
On Fri, Nov 20, 2009 at 10:29:20PM -0500, Qianqian Fang scratched on the wall: > Is this possibly caused by how sqlite binary was compiled? Yes. Readline support is not on by default. You need to compile it with -DHAVE_READLINE and add -lreadline to the linker: $ cc -DHAVE_READLINE -o sq

Re: [sqlite] command line does not accept arrow keys

2009-11-20 Thread Qianqian Fang
I don't know, is there a way I can tell? the binary was downloaded from sqlite website, version is 3.6.2. The binary stores in a remote server, running Debian 3, I used ssh in a Terminator/gnome-terminal bash shell. I also installed sqlite on my local machine, running Ubuntu Karmic, interestingly

Re: [sqlite] command line does not accept arrow keys

2009-11-20 Thread Stephan Wehner
On Fri, Nov 20, 2009 at 6:02 PM, Qianqian Fang wrote: > hi > > I can not type arrow keys in the sqlite3 command line, all the arrow > keys (as well as other keys in the small keyboard) will be shown as > escape sequence "^]]A". Could it be a problem with readline? See http://www.sqlite.org/cvstr

[sqlite] command line does not accept arrow keys

2009-11-20 Thread Qianqian Fang
hi I can not type arrow keys in the sqlite3 command line, all the arrow keys (as well as other keys in the small keyboard) will be shown as escape sequence "^]]A". I am using Terminator/gnome-terminal, is there a setting I need to twig in order to get this working? thanks Qianqian