Re: [sqlite] Where are the tables being saved?

Run: sqlite -help ...and see the sqlite's command line syntax. You should give then db filename as an parameter. Otherwise DB will be created in the memory and not saved. Best regards, Witold - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Saturday, April 23, 2005 12:15 PM Sub

Re: [sqlite] querying schema for integer primary key

Try: sqlite>.schema TableName ...will display table definition. Best regards, Witold

Re: [sqlite] High throughput and durability

rsync could be better. Best Regards, Witold And is there a way to automatically replicate the database to a second system? Copying the database file should give you an exact replica.

Re: [sqlite] How to create Auto Increment Field in SQlite

http://www.sqlite.org/autoinc.html try INTEGER PRIMARY KEY (no interger :-) Best regards, Witold - Original Message - From: "alok" <[EMAIL PROTECTED]> To: Sent: Monday, April 04, 2005 12:21 PM Subject: [sqlite] How to create Auto Increment Field in SQlite I am knocking my head on door f

Re: [sqlite] How do I Register on sqlite.org

You don't need to register. Just place the ticket: http://www.sqlite.org/cvstrac/tktnew Best regards, Witold - Original Message - From: "David Wheeler" <[EMAIL PROTECTED]> To: "SQLite Users" Sent: Friday, March 18, 2005 9:06 PM Subject: [sqlite] How do I Register on sqlite.org Hi All,

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

I strongly suggest to use pysqlite. APSW may be more powerfull in some areas but is not complaint with the python standard DB access API. If you will use pysqlite: 1) you will learn Python standard DBAPI 2) you will able to easly (relativly) migrate to another DB engine in future (mysql, postgre

Re: [sqlite] Does sqlite has isnull function?

Sometimes IFNULL function can be also enough (http://sqlite.org/lang_expr.html). - Original Message - From: "Witold Czarnecki" <[EMAIL PROTECTED]> To: Sent: Sunday, March 06, 2005 2:21 PM Subject: Re: [sqlite] Does sqlite has isnull function? You may use operator

Re: [sqlite] Does sqlite has isnull function?

You may use operator "ISNULL" instead. For example "SELECT x FROM table WHERE y ISNULL". Best reagrds, Witold - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Sunday, March 06, 2005 2:12 PM Subject: [sqlite] Does sqlite has isnull function? Hi All, I don't think sqlite support

Re: [sqlite] more syntax errors ?

Are there spaces in [Company Name] and [Contact Name] field names? Regards, Witold - Original Message - From: "Richard Nagle" <[EMAIL PROTECTED]> To: Sent: Thursday, February 24, 2005 4:40 PM Subject: [sqlite] more syntax errors ? fastmac:/applications/sqlite rn$ ./sqlite contacts SQLit

Re: [sqlite] New to SQLite...............2....3..4 Thank you

- Original Message - From: "Witold Czarnecki" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 8:45 PM Subject: Re: [sqlite] New to SQLite...23 There is good PHP/SQLite introduction here: http://www.zend.com/php5/abs/php101-9.php Best regard

Re: [sqlite] Is it bug?

Thank you for the clarification. To force float type in this case I use now: ROUND(value, 2) + 0.0 Best regards, Witold - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Wednesday, February 23, 2005 1:50 PM Subject: Re: [sqlite] Is it bug? On Sat, 2005-02-19 at

Re: [sqlite] New to SQLite...............2....3

There is good PHP/SQLite introduction here: http://www.zend.com/php5/abs/php101-9.php Best regards, Witold - Original Message - From: "Jan Ekström" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 8:36 PM Subject: Re: [sqlite] New to SQLite...23 Is the code bel

[sqlite] Are triggers atomic?

Are all operations in the trigger succeed or fail as a unit? Two updates for example. Or should I start the transaction before trigger firing? Best regards, Witold

[sqlite] 2 question about SQLite types

Hello, two questions: 1. SELECT TYPEOF(ROUND(1)); ... returns 'text'. Is it OK? Sorry, I asked this question 2 days ago but I still don't know - is it a bug or not? 2. sqlite> CREATE TABLE test(id INTEGER NOT NULL PRIMARY KEY UNIQUE, fld INTEGER); sqlite> INSERT INTO test(fld) VALUES(1); sqlite>

Re: [sqlite] Is it bug?

3.0.8 - Original Message - From: "Ulrik Petersen" <[EMAIL PROTECTED]> To: Sent: Saturday, February 19, 2005 11:57 AM Subject: Re: [sqlite] Is it bug? Witold Czarnecki wrote: sqlite> select typeof(round(1)); text Is it bug? What version? Ulrik Petersen

[sqlite] Is it bug?

sqlite> select typeof(round(1)); text Is it bug? Best regards, Witold

Re: [sqlite] Getting metadata

SELECT name FROM sqlite_master WHERE type = 'table' Best regards, Witold Czarnecki - Original Message - From: "Sijmen Mulder" <[EMAIL PROTECTED]> To: Sent: Thursday, February 17, 2005 3:22 PM Subject: Re: [sqlite] Getting metadata PRAGMA table_info(tabl

Re: [sqlite] Getting metadata

PRAGMA table_info(table-name); http://sqlite.org/pragma.html - Original Message - From: "Sijmen Mulder" <[EMAIL PROTECTED]> To: Sent: Thursday, February 17, 2005 3:03 PM Subject: [sqlite] Getting metadata Hi there, Is there a way to get information about the format of the database from

Re: [sqlite] TYPEOF in triggers

12:16 AM Subject: Re: [sqlite] TYPEOF in triggers On Thu, 2005-02-10 at 23:59 +0100, Witold Czarnecki wrote: sqlite> CREATE TABLE test(a NUMERIC); sqlite> CREATE TRIGGER test1 BEFORE INSERT ON test FOR EACH ROW BEGIN ...> SELECT CASE WHEN (TYPEOF(NEW.a) != 'numeric'

[sqlite] TYPEOF in triggers

Can you help?: sqlite> CREATE TABLE test(a NUMERIC); sqlite> CREATE TRIGGER test1 BEFORE INSERT ON test FOR EACH ROW BEGIN ...> SELECT CASE WHEN (TYPEOF(NEW.a) != 'numeric') THEN RAISE(ABORT, 'Error!') END; ...> END; sqlite> INSERT INTO test VALUES('aaa'); sqlite> SELECT TYPEOF(a) FROM te

Re: [sqlite] would someone check my SQL..

You may try: SELECT NULL FROM sqlite_master WHERE tbl_name = 'table'; - Original Message - From: "Asko Kauppi" <[EMAIL PROTECTED]> To: Sent: Thursday, February 10, 2005 5:08 PM Subject: Re: [sqlite] would someone check my SQL.. Is it true that in SQLite one has no way to check (at CREAT