Re: [sqlite] How do i do this UPDATE in SQLite?
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 val = qty * (select price from
historicalprice where historicalprice.itemid ==
salesrecord.itemid); {untested}
It depends on the version if you can use this.
>thanks.
>
>Radzi.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[sqlite] How do i do this UPDATE in SQLite?
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
* 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: http://cvs.danga.com/browse.cgi/wcmtools/diskchecker/diskchecker.pl?rev=HEAD - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Document "Compilation Options For SQLite" is outdated
*"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.
