Re: [sqlite] How do i do this UPDATE in SQLite?

2006-10-15 Thread Kees Nuyt
On Mon, 16 Oct 2006 09:53:19 +0800, you wrote: >update i set val=qty*q.price >from salesrecord i >inner join historicalprice q on i.itemid=q.itemid I would use a correlated subquery which returns one column, instead of the join. I don't think you can use aliasses there. update salesrecord set

[sqlite] How do i do this UPDATE in SQLite?

2006-10-15 Thread Mohd Radzi Ibrahim
update i set val=qty*q.price from salesrecord i inner join historicalprice q on i.itemid=q.itemid thanks. Radzi.

Re: [sqlite] database corrouption during power failure

2006-10-15 Thread Florian Weimer
* jayanth KP: >Please can anybody respond to this question. I am able to hits is >issue pretty often now... You should check that your operating system and hardware actually flush buffers when told to do so. Here's a test you can run:

[sqlite] Document "Compilation Options For SQLite" is outdated

2006-10-15 Thread hongdong
*"Compilation Options For SQLite" page is too old: last modified on 2005/03/19 15:10:45* ,predefine as "SQLITE_OMIT_CHECK" and "SQLITE_OMIT_VIRTUALTABLE" is not listed.