[sqlite] pragma table_info

Is there anyway to do 'pragma table_info' on a table in an attached database (even if a table in the main database has the same name). I guess I am wondering why this doesn't work: PRAGMA table_info(database_name.table_name) I get 'near ".": syntax error'. -Charlie

Re: [sqlite] Bug from ticket 1141 breaks existing applications

George Ionescu wrote: while trying to upgrade to sqlite 3.1.3, I've encountered the bug described in ticket #1141 (sqlite returns the primary key's column name, if any, instead of the ROWID column, in a query like SELECT rowid, * FROM table). Any idea how to fix this (if it's an easy one), sinc

Re: [sqlite] Interrupting write back of journal causes database corruption?

On Sun, 2005-03-06 at 21:26 +0100, Joris wrote: > I wonder if the interruption of writing back the journal can lead to > corruption of the database. No. Interrupting a write to the journal or a journal rollback will not corrupt the database file. At least, not unless there are undiscovered bug

[sqlite] Interrupting write back of journal causes database corruption?

~Yodels, I wonder if the interruption of writing back the journal can lead to corruption of the database. I understand how corruption is prevented when writing to the journal, but not how corruption can be prevented if the journal is written back to the database. I could not find anything in the

[sqlite] Bug from ticket 1141 breaks existing applications

Hello Dr. Hipp, Hello sqlite users, while trying to upgrade to sqlite 3.1.3, I've encountered the bug described in ticket #1141 (sqlite returns the primary key's column name, if any, instead of the ROWID column, in a query like SELECT rowid, * FROM table). Any idea how to fix this (if it's an ea

Re: [sqlite] Does sqlite has isnull function?

[EMAIL PROTECTED] wrote: Witold Czarnecki wrote: 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

Re: [sqlite] Does sqlite has isnull function?

Witold Czarnecki wrote: 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'

Re: [sqlite] Does sqlite has isnull function?

On Sun, 2005-03-06 at 09:12 -0400, [EMAIL PROTECTED] wrote: > Hi All, > > I don't think sqlite support isnull function, but I wonder is there > other function has same functionality but different name? > > thanks, > > Ming Is the function IS NULL? According to http://www.metrokc.gov/gis/kb/Con

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 "ISNULL" instead. For

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

[sqlite] Does sqlite has isnull function?

Hi All, I don't think sqlite support isnull function, but I wonder is there other function has same functionality but different name? thanks, Ming