Re: [sqlite] How to select Strict Affinity or No Affinity modes?

2008-02-02 Thread Scott Chapman
D. Richard Hipp wrote: > On Feb 2, 2008, at 7:57 PM, Scott Chapman wrote: > > >> I've looked high and low and can't find a way to invoke the other 2 >> affinity modes. Are they available? I'm on 3.5.4. >> > The concept of "strict" affinity mode was briefly discussed years > ago, but we nev

Re: [sqlite] Version 3.5.5 Released

2008-02-02 Thread [EMAIL PROTECTED]
Thanks, that helped. [EMAIL PROTECTED] wrote: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: Got the sqlite3.exe version 3.5.5 but .explain still doesn't seem to work.  Maybe it's me, could someone post a simple example of .explain working? C:\ sqlite3 SQLite version

Re: [sqlite] How to select Strict Affinity or No Affinity modes?

2008-02-02 Thread D. Richard Hipp
On Feb 2, 2008, at 7:57 PM, Scott Chapman wrote: > I've looked high and low and can't find a way to invoke the other 2 > affinity modes. Are they available? I'm on 3.5.4. > > The concept of "strict" affinity mode was briefly discussed years ago, but we never implemented it, having never seen an

[sqlite] How to select Strict Affinity or No Affinity modes?

2008-02-02 Thread Scott Chapman
I've looked high and low and can't find a way to invoke the other 2 affinity modes. Are they available? I'm on 3.5.4. Any pointers would be greatly appreciated. Thanks! Scott ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

Re: [sqlite] DBD::SQLite 1.14 prepare_cached bug?

2008-02-02 Thread Alexander Batyrshin
Opss. Code with numbers looks like this: $sth->execute; my ($val) = $sth->fetchrow_array; #[1] my ($val2) = $sth->fetchrow_array; #[2] $sth->finish; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mail

[sqlite] DBD::SQLite 1.14 prepare_cached bug?

2008-02-02 Thread Alexander Batyrshin
Hello All, I don't know is it right place to discuss this or not. Sorry If I am doing something wrong. Installed sqlite-3.5.4 and DBD::SQLite-1.14 I get problems with this code: %< #!/usr/bin/perl -w use strict; use DBI; use Data::Dumper; use Stora

Re: [sqlite] Version 3.5.5 Released

2008-02-02 Thread drh
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Got the > sqlite3.exe version 3.5.5 but .explain still doesn't seem to work.  > Maybe it's me, could someone post a simple example of .explain working? > C:\ sqlite3 SQLite version 3.5.5 Enter ".help" for instructions sqlite> create table t1(x); s

Re: [sqlite] Version 3.5.5 Released

2008-02-02 Thread [EMAIL PROTECTED]
Got the sqlite3.exe version 3.5.5 but .explain still doesn't seem to work.  Maybe it's me, could someone post a simple example of .explain working? [EMAIL PROTECTED] wrote: Also, .schema and .explain don't seem to do anything in then sqlite3.exe version 3.5.4. I downloaded in sqlite-3_5_5.zip

[sqlite] Mailing List Changes

2008-02-02 Thread Mike Owens
The SQLite mailing list has been moved over to Postfix and GNU Mailman. Please do not use the ezmlm mail accounts to modify your subscription status from this point on. You can now configure your list status and options via the Mailman interface at: http://sqlite.org:8080/cgi-bin/mailman/option

[sqlite] Testing the new SQLite mailing list

2008-02-02 Thread D. Richard Hipp
This is the initial test message for the new SQLite mailing list, using GNU mailman now instead of ezmlm. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-us

[sqlite] List Test

2008-02-02 Thread Mike Owens
Testing. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Version 3.5.5 Released

2008-02-02 Thread [EMAIL PROTECTED]
Also, .schema and .explain don't seem to do anything in then sqlite3.exe version 3.5.4. I downloaded in sqlite-3_5_5.zip Mohd Radzi Ibrahim wrote: Hi, The Precompiled Binary for Windows : the command-line sqlite-3_5_5.zip still contain the 3.5.4 version regards, Radzi. - Original M