Re: [sqlite] Replicating table data from sqlite to ms sql server

The scenario would be the sqlite database is managed using CGI C, resides in Linux environment, and accessed through the web. Then the sql server would be replicating whatever changes would occur in the sqlite database (both sqlite and sql server have the same tables). This will also happen vice

Re: [sqlite] RE: Question regarding INTEGER PRIMARY KEY (zero value in column) ?

On Thu, 2007-07-12 at 23:38 -0700, RohitPatel wrote: > Hi > > I have a Question regarding INTEGER PRIMARY KEY (zero value in column) ? > > Example table => create table {id INTEGER PRIMARY KEY, name TEXT}; > > Is it ever possible that value 0 (zero) will be inserted in a column > declared

Re: [sqlite] Milliseconds

Scott Baker uttered: Christian Smith wrote: If you use the julianday representation, the integer component is the number of days since "noon in Greenwich on November 24, 4714 B.C", with the fractional part being the fraction of that day. Hence, the resolution is determined by the fractional

[sqlite] Re: Help with order-by query

Alberto Simões <[EMAIL PROTECTED]> wrote: I have this simple schema for news: sqlite> .schema CREATE TABLE news (year,month,day,title,text); CREATE INDEX date ON news(year,month,day); And this query results not as expected... sqlite> SELECT * FROM news ORDER BY year DESC,month DESC,day DESC;

[sqlite] Re: Help with order-by query

Ok, my fault. Integers versus string values. Cheers Alberto On 7/15/07, Alberto Simões <[EMAIL PROTECTED]> wrote: Hi I have this simple schema for news: sqlite> .schema CREATE TABLE news (year,month,day,title,text); CREATE INDEX date ON news(year,month,day); And this query results not as

[sqlite] Help with order-by query

Hi I have this simple schema for news: sqlite> .schema CREATE TABLE news (year,month,day,title,text); CREATE INDEX date ON news(year,month,day); And this query results not as expected... sqlite> SELECT * FROM news ORDER BY year DESC,month DESC,day DESC; 2007|7|7|Novo design|...