Re: [sqlite] how to update the Moving average value

select id, sales_vol, (select avg(sales_vol) as mavg from tbl b where b.id between a.id - 3 and a.id) from tbl a; --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -Original Message- > From:

[sqlite] how to update the Moving average value

I hace many record of product database,and wanna count the moving average value of sales_vol of last 3 days(id) of value, how to write sql command? id Sales_vol mov_avg 1 1 2 2 3 3 =(1+2+3)/3 4 5 =(2+3+5)/3 5 4

[sqlite] Typo on hwaci.com website (cerod.html)

Hi there, http://www.hwaci.com/sw/sqlite/cerod.html contains the sentence " This utility program (called cerod_build.exe) reads an ordinary, uncompressed and unencrypted SQLite database built by a public-domain version of SQLite and constructs and equivalent compressed and encrypted CEROD

Re: [sqlite] Make System.Data.SQLite 1.0.81.0 work with .NET 4.0. How?

Am 10.08.2012 19:14, schrieb jean.nkengto...@externe.bnpparibas.com: Hello, I bet somebody already managed to make this work. Unhappily I can't access archives. Here is my problem: I'm building a Console Application to load and fill one SQLite DB. We recently decided to switch the application

Re: [sqlite] create table question

On 10 Aug 2012, at 9:14pm, u okafor wrote: > We are doing a CREATE TABLE query; sqlite3_step() is called in shell.c and > along > the way, sqlite3VdbeExec() is called. sqlite3VdbeExec() call is pased with > "p" > pointer which contains "aOp" array. Could you please tell us

[sqlite] create table question

Dear Forum members, We are doing a CREATE TABLE query; sqlite3_step() is called in shell.c and along the way, sqlite3VdbeExec() is called. sqlite3VdbeExec() call is pased with "p" pointer which contains "aOp" array. Could you please tell us where this "aOp" array is created in the code... 

[sqlite] Make System.Data.SQLite 1.0.81.0 work with .NET 4.0. How?

Hello, I bet somebody already managed to make this work. Unhappily I can't access archives. Here is my problem: I'm building a Console Application to load and fill one SQLite DB. We recently decided to switch the application to framework 4.0, from framework 3.5. I've downloaded and deployed

[sqlite] Concurrency and sqlite4

Hello, will there be some improvement regarding concurrency in the new sqlite4 ? Sqlite3 fits quite good to my needs, only the concurrency causes some problems, so I am eager to know about improvements in this area. Thx for your efforts ___