Re[2]: [sqlite] I'm Starving for New User Information

2007-05-06 Thread Teg
Hello C.Peachment, Yeah, I wasn't going to answer. Clearly this person hasn't even read the website which is where all the documentation resides. C Sunday, May 6, 2007, 10:38:59 PM, you wrote: CP> You ask too many questions in one go. I will be surprised if anyone CP> is willing to provide

Re: [sqlite] how to add a new column quickly

2007-05-06 Thread Mohd Radzi Ibrahim
How about this? update tablename set newcolname=(case rowid when 1 then 1 else 2 end); best regards, Radzi - Original Message - From: "Tomash Brechko" <[EMAIL PROTECTED]> To: Sent: Saturday, May 05, 2007 8:09 PM Subject: Re: [sqlite] how to add a new

Re: [sqlite] I'm Starving for New User Information

2007-05-06 Thread C.Peachment
You ask too many questions in one go. I will be surprised if anyone is willing to provide that much assistance all at once. It appears that you need some more fundamental knowledge about programming on GNU/Linux and maybe even about programming in C. Some of your questions are contradictory and

[sqlite] I'm Starving for New User Information

2007-05-06 Thread km4hr
Is there a sqlite introduction for programmers wanting to use the sqlite C API? The info on the web site is pretty sparse. There seems to be plenty of info regarding the use of sqlite3 all over the web. But not much on getting set up to write programs that use sqlite. I have some specific

Re: [sqlite] Conditional table select

2007-05-06 Thread Vitali Lovich
Dan Kennedy wrote: On Fri, 2007-05-04 at 18:22 -0400, Vitali Lovich wrote: Multiple tables contain a primary key KEY. If Table1 contains a matching KEY, then I want that row from Table1. Only if it isn't in Table1, then look in Table2 if it is there. If not in Table2 go on to Table3, etc

[sqlite] Ticket #2339

2007-05-06 Thread drh
Will the anonymous user who contributed the remark to ticket #2339 on 2007-May-06 18:03:48 that contains a 6-line patch for fixing the ticket, please identify yourself to me. Tnx. -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] Re: How to obtain the integer part of a result

2007-05-06 Thread Igor Tandetnik
A.J.Millan <[EMAIL PROTECTED]> wrote: I would like to know if there are a way to obtain a result without decimals (the integer part) in this query: CAST(expr AS INTEGER) Igor Tandetnik - To unsubscribe, send email to

Re: [sqlite] How to obtain the integer part of a result

2007-05-06 Thread Liam Healy
See the "floor" function (largest integer value not greater than argument) in http://sqlite.org/contrib/download/extension-functions.tgz?get=17 On 5/6/07, A.J.Millan <[EMAIL PROTECTED]> wrote: Hi all: I would like to know if there are a way to obtain a result without decimals (the integer

[sqlite] How to obtain the integer part of a result

2007-05-06 Thread A.J.Millan
Hi all: I would like to know if there are a way to obtain a result without decimals (the integer part) in this query: SELECT round(julianday('now')-Dat) FROM SomeTable WHERE ...; Obviously Dat contain a Julian Date (nnn.nnn) and I want the difference in days from today. None the above,