Re: [sqlite] Math Update with two tables

"aj" wrote in message news:95d3c7350812201131l1cd87998k55595f77fecc0...@mail.gmail.com > I would like to use math with more then one table, for example > I know how to do this > > > (Factors & Potential = columns) > > UPDATE Records > SET Factors= (Factors * Potential) > >

Re: [sqlite] Trigger UPDATE based on a different row

On 12/20/08, jose isaias cabrera wrote: > > Greetings! > > Imagine these rows in a table named LSOpenJobs: > > id, PID,subject, bdate, edate, lang,job > 1, 232,2008-01-01,2008-01-10,es,trans > 2, 232,2008-01-01,2008-01-10,fr,trans > 3,

Re: [sqlite] Sharing a database / Replication

On Sat, 20 Dec 2008 07:03:48 -0500, Simon wrote in General Discussion of SQLite Database : >> Use transactions, ref: >> http://www.sqlite.org/lang_transaction.html >> and program proper lock/error handling. The archives of this >> mailing list contain

[sqlite] Trigger UPDATE based on a different row

Greetings! Imagine these rows in a table named LSOpenJobs: id, PID,subject, bdate, edate, lang,job 1, 232,2008-01-01,2008-01-10,es,trans 2, 232,2008-01-01,2008-01-10,fr,trans 3, 232,2008-01-01,2008-01-10,it,trans 4, 232,2008-01-01,2008-01-10,es,val 5, 232,2008-01-01,2008-01-10,fr,val 6,

[sqlite] Math Update with two tables

I would like to use math with more then one table, for example I know how to do this (Factors & Potential = columns) UPDATE Records SET Factors= (Factors * Potential) but i don't know how with an additional table, i came up with UPDATE Records,Table2 SET Factors= (Factors * Potential

Re: [sqlite] confusing with how to to this in sqlite

On 12/20/08, Simon Davies wrote: > 2008/12/20 Rachmat Febfauza : > > > > > i have to change 'FOOD ' to 'FOOD', but the result is not that i hope. > > > > Rachmat: If what Simon says is correct (and I have no reason to doubt > > it) you

Re: [sqlite] confusing with how to to this in sqlite

2008/12/20 Rachmat Febfauza : > > i have to change 'FOOD ' to 'FOOD', but the result is not that i hope. > > Rachmat: If what Simon says is correct (and I have no reason to doubt > it) you might also get your query to work by specifying a collating > sequence of RTRIM on the

Re: [sqlite] Sharing a database / Replication

> Use transactions, ref: > http://www.sqlite.org/lang_transaction.html > and program proper lock/error handling. The archives of this > mailing list contain several good examples. Yes, ok, I'll have to work that way... I believe there should also be some time spent on a good design for these