[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
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: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:12 PM Subject: [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
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: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:21 PM Subject: 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: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:12 PM Subject: [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
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/Content/SQLTipNull.htm it is. -- G. Roderick Singleton [EMAIL PROTECTED] PATH tech
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: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:12 PM Subject: [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 What I want to do is: select ISNULL(MAX(SubOrder), 0)+1 from Table1 where ... anyway I can do this, since isnull is not working this way. Thanks,
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: sqlite-users@sqlite.org Sent: Sunday, March 06, 2005 2:12 PM Subject: [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 What I want to do is: select ISNULL(MAX(SubOrder), 0)+1 from Table1 where ... anyway I can do this, since isnull is not working this way. Thanks, IFNULL worked! thanks Witold Czarnecki
[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 easy one), since it breaks existing applications. Thanks. Regards. George Ionescu. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
[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 source code nor the documentation that explains this. Can anyone enlighten me? Regards, Joris
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 bugs in the pager system. And that stuff is tested pretty heavily. -- D. Richard Hipp [EMAIL PROTECTED]
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), since it breaks existing applications. SELECT rowid AS 'rowid',* FROM table
[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