Re: [sqlite] sqlite login password

2015-01-03 Thread Stephen Chrzanowski
Maybe the question is "How do I make SQLite do this when accessing a database?" and the 3 just got dropped inadvertently. If that is the case, as Dr. Hipp said, SQLite has never done it, and I'll add on that it has never done it "stock". On the other hand, that link you posted, Dr. Hipp, is rathe

Re: [sqlite] sqlite login password

2015-01-03 Thread Simon Slavin
On 4 Jan 2015, at 1:00am, Richard Hipp wrote: > (1) The OP says he used the "sqlite" command (version 2 of SQLite) not > sqlite3. > (2) SQLite has *never* given a prompt "Pls input your password". That > message is coming from third-party software. I agree that my answer has nothing to do with

Re: [sqlite] sqlite login password

2015-01-03 Thread Richard Hipp
On Sat, Jan 3, 2015 at 7:59 PM, Simon Slavin wrote: > > On 4 Jan 2015, at 12:56am, YAN HONG YE wrote: > > > I want to know how to setting a loging sqlite passwd? > > When I input: > > Sqlite mtdb > > Command, the console will prompt like this: > > Pls input your password: > > http://www.sqlite.o

Re: [sqlite] sqlite login password

2015-01-03 Thread Simon Slavin
On 4 Jan 2015, at 12:56am, YAN HONG YE wrote: > I want to know how to setting a loging sqlite passwd? > When I input: > Sqlite mtdb > Command, the console will prompt like this: > Pls input your password: http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt It is only available in re

[sqlite] sqlite login password

2015-01-03 Thread YAN HONG YE
I want to know how to setting a loging sqlite passwd? When I input: Sqlite mtdb Command, the console will prompt like this: Pls input your password: ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql

Re: [sqlite] Is this date supposed to be less than or more than the other?

2015-01-03 Thread J Decker
On Sat, Jan 3, 2015 at 5:23 AM, Simon Slavin wrote: > > On 3 Jan 2015, at 1:12am, J Decker wrote: > > > On Fri, Jan 2, 2015 at 4:44 PM, Simon Slavin > wrote: > > > >> On 3 Jan 2015, at 12:12am, J Decker wrote: > >> > >>> https://www.sqlite.org/datatype3.html /* lists DateTime as a distinct > >

Re: [sqlite] Client/Server Best Practices

2015-01-03 Thread Simon Slavin
On 3 Jan 2015, at 4:41am, Keith Medcalf wrote: > I do not believe that there is a way to specify "COMMIT BUT MAINTAIN THE > SHARED LOCK", (that is, to commit the changes only and un-escalate the lock > back to a shared lock) which would be required in order for the loop > semantics posited by

Re: [sqlite] Is this date supposed to be less than or more than the other?

2015-01-03 Thread Simon Slavin
On 3 Jan 2015, at 1:12am, J Decker wrote: > On Fri, Jan 2, 2015 at 4:44 PM, Simon Slavin wrote: > >> On 3 Jan 2015, at 12:12am, J Decker wrote: >> >>> https://www.sqlite.org/datatype3.html /* lists DateTime as a distinct >>> type */ I'm going to answer this in detail because you still don't