Re: [sqlite] random() function does not keep value in subquery

the hole explanation is: I modified your select a bitt get a result for the random() function sqlite> select b,a, b & a from (select random() as b, 65535 as a); -3252060536130257049|65535|48999 So I got these results b = -3252060536130257049 in decimal form b = 110100101100010111101

Re: [sqlite] Merry Christmas

+1 = 3 -Original Message- From: TR Shaw Sent: Saturday, December 25, 2010 7:46 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Merry Christmas +1 On Dec 25, 2010, at 12:31 AM, Artur Reilin wrote: > Merry Christmas to the whole mailing list and your families :) >

Re: [sqlite] database question

Hi Mark, I am not an expert on SQLite. But I have programming experience, so I can make a suggestion. You did not say what application you are talking and if you did, I might not know about it. What I would do is yes create a simple application that accesses the SQLite database and the table y

Re: [sqlite] Multi table select

Hi, I think that: Nevermind.. I figured it out. I needed a left join. does not cut it as a sollution. We new bees whant a complete solution to learn. Like the complete sql statement that you used to solve your probleme. thanks Guy -- From: "tafte