Re: [sqlite] ~/sqliterc example/documentation avaible?

2007-08-11 Thread Joe Wilson 
--- Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 8/11/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> 
> > You can put any command seen in ".help" in the sqlite3 shell
> > or any SQL command in ~/.sqliterc, such as:
> 
> ...and of course, I would completely forget about the shell.  Oops.

As always, the definitive document is the source code itself:

http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/shell.c=1.166



   

Looking for a deal? Find great prices on flights and hotels with Yahoo! 
FareChase.
http://farechase.yahoo.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] ~/sqliterc example/documentation avaible?

2007-08-11 Thread Trevor Talbot 
On 8/11/07, Joe Wilson <[EMAIL PROTECTED]> wrote:

> You can put any command seen in ".help" in the sqlite3 shell
> or any SQL command in ~/.sqliterc, such as:

...and of course, I would completely forget about the shell.  Oops.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] ~/sqliterc example/documentation avaible?

2007-08-11 Thread Joe Wilson 
--- Brickl Roland <[EMAIL PROTECTED]> wrote:
> where can i find information about how the config-file should look like and 
> what is possible?

You can put any command seen in ".help" in the sqlite3 shell 
or any SQL command in ~/.sqliterc, such as:

select 'no place like home';
.mode column
.header on

You can specify an alternative config file with -init.
  
  sqlite3 -init /whatever/sqliterc your.db


   

Be a better Globetrotter. Get better travel answers from someone who knows. 
Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list=396545469

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] ~/sqliterc example/documentation avaible?

2007-08-10 Thread Trevor Talbot 
On 8/10/07, Brickl Roland <[EMAIL PROTECTED]> wrote:

> where can i find information about how the config-file should look like and 
> what is possible?

There is no ~/sqliterc or config file.  SQLite is an embedded database
engine; applications use it in application-specific ways.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] ~/sqliterc example/documentation avaible?

2007-08-10 Thread drh 
Brickl Roland <[EMAIL PROTECTED]> wrote:
> 
> "Feature Request": Column-definition INT should be parsed
> as INTEGER in sql-code.
> 

It is.  At least it is for the purpose of computing column
affinity.  For the INTEGER PRIMARY KEY you are required to
spell out "INTEGER".  We cannot change the latter without 
breaking backwards compatibility, which is something we are 
unwilling to do.

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-