[sqlite] TCL tester.tcl question

A general question for the TCL experts There is no problem, I'm just trying to understand how TCL works. In tester.tcl,v 1.79, at line 60, there is the following section: # Create a test database # catch {db close} file delete -force test.db file delete -force test.db-journal sqlite3 db

[sqlite] Test insert4-2.4.1 in insert4.test

I don't have TCL, so I'm trying to validate sqlite by running some of the tests by hand. In insert4.test, there is a sub-test do_test insert4-2.4.1 { execsql { DELETE FROM t3; INSERT INTO t3 SELECT DISTINCT * FROM t2; SELECT * FROM t3; } } {9 1 1 9} I can run this test by

[sqlite] Trigger Steps

The documentation for Triggers defines a trigger step as follows: trigger-step ::=update-statement | insert-statement | delete-statement | select-statement What would be an example of the select-statement? Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain

Re: [sqlite] Malformed database schema with SQLite version 3.5.x

Suggestion to SQLite Developers ... Have PRAGMA integrity_check reparse the SQL in sqlite_master, looking for errors. Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MarcoN Sent: Friday, March 21, 2008 12:54 AM To: General Discussion of

[sqlite] Why did 3.5.7 pass the following test in alter2

do_test alter2-2.1 { execsql { CREATE TABLE abc2(a, b, c); INSERT INTO abc2 VALUES(1, 2, 10); INSERT INTO abc2 VALUES(3, 4, NULL); INSERT INTO abc2 VALUES(5, 6, NULL); CREATE VIEW abc2_v AS SELECT *

[sqlite] Inconsistant comment in sqliteInt.h

Could someone with CVS access look into this for me. I think there is a documentation error in SqliteInt.h The routine sqlite3NestedParse in build.c shows that the variables up to nVar are static # define SAVE_SZ (sizeof(Parse) - offsetof(Parse,nVar)) In addition analyze.c has the comments

RE: [sqlite] Version 3.5.5 Released

#ifndef SQLITE_OMIT_VIRTUALTABLE Looks like a dummy MACRO or function needs to be created, or the PARSE code needs to be bracketed with #ifndef SQLITE_OMIT_VIRTUALTABLE Can someone with source access please make this change. Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may

RE: [sqlite] Version 3.5.5 Released

Got it! Thanks for the clarification. Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 31, 2008 10:43 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Version 3.5.5 Released Importance: High Noah Hart [EMAIL PROTECTED] wrote

RE: [sqlite] Date arithmetic question

Not really that goofy, just very specific. The SQL Server manual describes it this way: Returns the number of date and time boundaries crossed between two specified dates. Regards, Noah Hart -Original Message- So datediff('month', '2008-02-01 23:59:59','2008-01-31 00:00:00') should

RE: [sqlite] DeviceSQL

Why can't new OP codes be simply added to the end, so that the serializations will always work? Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, December 14, 2007 8:20 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] DeviceSQL Importance: High

RE: [sqlite] Version 3.5.3

Please note: typo on page http://sqlite.org/releaselog/3_5_3.html TCL interfaced -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 9:56 AM To: sqlite-users@sqlite.org Subject: [sqlite] Version 3.5.3 Importance: High SQLite version

RE: [sqlite] Request for help with the SQLite Website

that . . . SQLite is an embedded SQL database engine.. SQLite is a compact library. ... SQLite has a reputation for being very reliable. ... The SQLite code base is ... We the developers hope ... Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential

RE: [sqlite] Slow View Performance

Matt, if looks like you have a cross join between your tables. Are the tables A, B, C related in some way? IF so, then your queries should look something like SELECT fields from TabA LEFT OUTER JOIN TabB where TabA.IDb = TabB.IDb And your view like SELECT fields FROM TabB INNER JOIN TabC where

RE: [sqlite] Odd performance issue under Windows

Thanks Donald. The results are now identical. So, it has to do with buffer flushing differences between the machines. Now I have to figure out what the differences are given that the XP laptop is configured as shipped and is showing the performance improvement. Addendum. I have

RE: [sqlite] Journal files not deleted.

Not to quibble, but to quote from wipro's website Only Indian company to be ranked among the top 10 global outsourcing providers in IAOP's 2006 Global Outsourcing 100 listing NH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 10,

[sqlite] Building Test Fixture under Visual Studio 2005

TCL_OK; } What step / configuration param for VS2005 I forgetting? Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose

RE: [sqlite] Version 3.3.14

I found it, I was using an old sqlite3.def file for the exports. Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:00 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Version 3.3.14 Noah Hart [EMAIL PROTECTED] wrote

RE: [sqlite] Version 3.3.14

? Noah Hart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 8:47 AM To: sqlite-users@sqlite.org Subject: [sqlite] Version 3.3.14 SQLite version 3.3.14 is now available on the SQLite website CONFIDENTIALITY NOTICE: This message may

RE: [sqlite] invalid command name sqlite3

Is your operating system case sensitive? Try sqlite3, rather than Sqlite3 Regards, Noah -Original Message- From: Reber Douglas-ra7758 [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 9:08 AM To: sqlite-users@sqlite.org Subject: [sqlite] invalid command name sqlite3 I continue

[sqlite] Count of rows in every table

Using only SQLite and SQL, is there a way to get a count of rows in each table in the database? I know I can do this via an external application to query sqlite_master and using that list, query a row count of each table, but would prefer to find a pure SQL way if possible. Thanks, Noah

[sqlite] Sqlite 3.3.13; expr.c; analyzeAggregate

; ipSrcList-nSrc; i++, pItem++){ are the two i the same variable, and it is intended that the second loop reset the Outer loop variable each time the inner loop is run, and that the assignment statement affect the outer loop as well? Thanks for the clarification, Noah Hart CONFIDENTIALITY NOTICE

[sqlite] Singular Sqlite3Explorer 2.0 question

Has anyone used this program? I am trying to use the Import using Regular Expression option. Itis looking for some type of regular expression to parse the columns. Any suggestions or sample expressions you can offer? Regards, Noah Hart CONFIDENTIALITY NOTICE: This message may contain

RE: [sqlite] ANN: SQLite ODBC Driver 0.73

If I link a sqlite3 table via access and run a query to insert into the table, I get gibberish in the sqlite3 database. Did you support Unicode in your odbc driver? Thanks, Noah Hart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christian Werner

RE: [sqlite] Version 3.3.13

3.3.13 fails to link with SQLITE_OMIT_TRIGGER defined. Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of snowcrash+sqlite Sent: Tuesday, February 13, 2007 7:52 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Version 3.3.13 hi,

RE: [sqlite] Atomically creating a database and bootstrapping its tables

Why not create it under a random name, and then rename after creation? Noah Hart -Original Message- From: Ron Stevens [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 10:59 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Atomically creating a database and bootstrapping

[sqlite] SQLITE_OMIT_TRIGGER

I have no problems compiling under VS2005 using 3.3.12 when I don't define SQLITE_OMIT_TRIGGER. However, I do get an error compiling when I define SQLITE_OMIT_TRIGGER=1 The linker complains about sqlite3_enable_shared_cache not being exported. Is this just VS2005 wierdness, or is there a

[sqlite] compiler option SQLITE_OMIT_SQLITE_OMIT_PARSER

are the ramification of omitting it from sqlite? Thank you, Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based

RE: [sqlite] compiler option SQLITE_OMIT_SQLITE_OMIT_PARSER

Thank you, so as I understand it, the option SQLITE_OMIT_PARSER mean that I've already parsed the statements, and are not supporting ad-hoc SQL. What about the compiler option SQLITE_OMIT_CHECK Thanks, Noah Hart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

<    1   2