Re: [sqlite] UI question

2007-08-05 Thread John Stanton
John wrote: John wrote: Griggs, Donald wrote: Regarding: " Where I get tripped up is making a typo in a multiline query that may have destructive effects if I terminate with a ';' and allow the CLI to execute the query. To date I have aborted the CLI with a ^C (MS Windows). I would love have

Re: [sqlite] UI question

2007-08-05 Thread John
John wrote: Griggs, Donald wrote: Regarding: " Where I get tripped up is making a typo in a multiline query that may have destructive effects if I terminate with a ';' and allow the CLI to execute the query. To date I have aborted the CLI with a ^C (MS Windows). I would love have a means of

Re: [sqlite] UI question

2007-08-05 Thread John
Griggs, Donald wrote: Regarding: " Where I get tripped up is making a typo in a multiline query that may have destructive effects if I terminate with a ';' and allow the CLI to execute the query. To date I have aborted the CLI with a ^C (MS Windows). I would love have a means of

RE: [sqlite] UI question

2007-08-05 Thread Griggs, Donald
Regarding: " Where I get tripped up is making a typo in a multiline query that may have destructive effects if I terminate with a ';' and allow the CLI to execute the query. To date I have aborted the CLI with a ^C (MS Windows). I would love have a means of escaping/cancelling back to the prompt

Re: [sqlite] UI question

2007-08-05 Thread John
[EMAIL PROTECTED] wrote: Scott Derrick <[EMAIL PROTECTED]> wrote: This is probably a stupid question but has frustrated me a couple of times. When using the command line interface sqlite3, a couple of times I have forgotten to use the "." before a command. After that I get a "...>" prompt

Re: [sqlite] UI question

2007-08-03 Thread John Stanton
Joe Wilson wrote: --- [EMAIL PROTECTED] wrote: Joe Wilson <[EMAIL PROTECTED]> wrote: --- John Stanton <[EMAIL PROTECTED]> wrote: Sqlite3 will get into a tangle with certain sequences where it does not accept a semicolon as a terminator or obey a CTL c. To reproduce: 1. build sqlite3

Re: [sqlite] UI question

2007-08-03 Thread Joe Wilson
--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > --- John Stanton <[EMAIL PROTECTED]> wrote: > > > Sqlite3 will get into a tangle with certain sequences where it does not > > > accept a semicolon as a terminator or obey a CTL c. > > > > To reproduce: > > > > 1. build

Re: [sqlite] UI question

2007-08-03 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > --- John Stanton <[EMAIL PROTECTED]> wrote: > > Sqlite3 will get into a tangle with certain sequences where it does not > > accept a semicolon as a terminator or obey a CTL c. > > To reproduce: > > 1. build sqlite3 without readline support. > 2. run

RE: [sqlite] UI question

2007-08-02 Thread Kalyani Tummala
question -Original Message- From: Scott Derrick [mailto:[EMAIL PROTECTED] Sent: Thursday, August 02, 2007 10:22 AM To: sqlite-users@sqlite.org Subject: [sqlite] UI question This is probably a stupid question but has frustrated me a couple of times. When using the command line interface

Re: [sqlite] UI question

2007-08-02 Thread Chris Peachment
On Thu, 2 Aug 2007 14:16:28 -0700 (PDT), Joe Wilson wrote: >--- John Stanton <[EMAIL PROTECTED]> wrote: >> Sqlite3 will get into a tangle with certain sequences where it does not >> accept a semicolon as a terminator or obey a CTL c. >To reproduce: >1. build sqlite3 without readline support.

Re: [sqlite] UI question

2007-08-02 Thread John Stanton
It seems to be connected with xterm. Joe Wilson wrote: --- John Stanton <[EMAIL PROTECTED]> wrote: Sqlite3 will get into a tangle with certain sequences where it does not accept a semicolon as a terminator or obey a CTL c. To reproduce: 1. build sqlite3 without readline support. 2. run

Re: [sqlite] UI question

2007-08-02 Thread John Stanton
Sqlite3 will get into a tangle with certain sequences where it does not accept a semicolon as a terminator or obey a CTL c. Chris Peachment wrote: On Thu, 02 Aug 2007 08:21:30 -0600, Scott Derrick wrote: This is probably a stupid question but has frustrated me a couple of times. When

Re: [sqlite] UI question

2007-08-02 Thread Joe Wilson
--- John Stanton <[EMAIL PROTECTED]> wrote: > Sqlite3 will get into a tangle with certain sequences where it does not > accept a semicolon as a terminator or obey a CTL c. To reproduce: 1. build sqlite3 without readline support. 2. run sqlite3 in an xterm 3. at the prompt, press cursor up 4.

Re: [sqlite] UI question

2007-08-02 Thread Joe Wilson
> This is probably a stupid question but has frustrated me a couple of times. > > When using the command line interface sqlite3, a couple of times I have > forgotten to use the "." before a command. After that I get a "...>" > prompt that I can't seem to escape from and accepts no commands?

Re: [sqlite] UI question

2007-08-02 Thread John Stanton
It is a bug in sqlite3. You can kill the process from another channel or supend it with a CTL Z and then kill it locally. Scott Derrick wrote: This is probably a stupid question but has frustrated me a couple of times. When using the command line interface sqlite3, a couple of times I have

Re: [sqlite] UI question

2007-08-02 Thread Jim Dodgen
also if the semicolon does not get you back to the prompt you may have an open quoted string so try a "; to close it and get you back. Quoting Dan Kennedy <[EMAIL PROTECTED]>: > On Thu, 2007-08-02 at 08:21 -0600, Scott Derrick wrote: > > This is probably a stupid question but has frustrated

Re: [sqlite] UI question

2007-08-02 Thread Trey Mack
When using the command line interface sqlite3, a couple of times I have forgotten to use the "." before a command. After that I get a "...>" prompt that I can't seem to escape from and accepts no commands? My only choice is to shut down that terminal and start a new one.. There must be an

Re: [sqlite] UI question

2007-08-02 Thread Chris Peachment
On Thu, 02 Aug 2007 08:21:30 -0600, Scott Derrick wrote: >This is probably a stupid question but has frustrated me a couple of times. >When using the command line interface sqlite3, a couple of times I have >forgotten to use the "." before a command. After that I get a "...>" >prompt that I

Re: [sqlite] UI question

2007-08-02 Thread Dan Kennedy
On Thu, 2007-08-02 at 08:21 -0600, Scott Derrick wrote: > This is probably a stupid question but has frustrated me a couple of times. > > When using the command line interface sqlite3, a couple of times I have > forgotten to use the "." before a command. After that I get a "...>" > prompt

Re: [sqlite] UI question

2007-08-02 Thread drh
Scott Derrick <[EMAIL PROTECTED]> wrote: > This is probably a stupid question but has frustrated me a couple of times. > > When using the command line interface sqlite3, a couple of times I have > forgotten to use the "." before a command. After that I get a "...>" > prompt that I can't seem

RE: [sqlite] UI question

2007-08-02 Thread Griggs, Donald
-Original Message- From: Scott Derrick [mailto:[EMAIL PROTECTED] Sent: Thursday, August 02, 2007 10:22 AM To: sqlite-users@sqlite.org Subject: [sqlite] UI question This is probably a stupid question but has frustrated me a couple of times. When using the command line interface

[sqlite] UI question

2007-08-02 Thread Scott Derrick
This is probably a stupid question but has frustrated me a couple of times. When using the command line interface sqlite3, a couple of times I have forgotten to use the "." before a command. After that I get a "...>" prompt that I can't seem to escape from and accepts no commands? My only

Re: [sqlite] UI question

2007-08-02 Thread P Kishor
just enter a ; (semi-colon) to indicate that you have ended your command. SQLite will complain, and then will let you pick up and continue. On 8/2/07, Scott Derrick <[EMAIL PROTECTED]> wrote: > This is probably a stupid question but has frustrated me a couple of times. > > When using the command