Re: [sqlite] controlling changes

2009-10-10 Thread David Bicking
On Sat, 2009-10-10 at 19:31 +0100, Simon Slavin wrote: > On 10 Oct 2009, at 5:08pm, David Bicking wrote: > > > I have a table: > > CREATE TABLE Assets > > ( ControlDate Date > > , Amt > > ) > > There is no such column type as 'Date' in SQLite. You got TEXT, > INTEGER, REAL. Make sure you

Re: [sqlite] controlling changes

2009-10-10 Thread Simon Slavin
On 10 Oct 2009, at 5:08pm, David Bicking wrote: > I have a table: > CREATE TABLE Assets > ( ControlDate Date > , Amt > ) There is no such column type as 'Date' in SQLite. You got TEXT, INTEGER, REAL. Make sure you know what's going into that field. Also I don't understand your pri

Re: [sqlite] controlling changes

2009-10-10 Thread David Bicking
qlite-users@sqlite.org > Subject: [sqlite] controlling changes > > I have a table: > CREATE TABLE Assets > ( ControlDate Date > , Amt > ) > > Now, the business rules are you can INCREASE the Amt if the Current Date > is the ControlDate in the record. You can

Re: [sqlite] controlling changes

2009-10-10 Thread Harold Wood & Meyuni Gani
You can do it as a constraint. -Original Message- From: David Bicking Sent: Saturday, October 10, 2009 9:08 AM To: sqlite-users@sqlite.org Subject: [sqlite] controlling changes I have a table: CREATE TABLE Assets ( ControlDate Date , Amt ) Now, the business rules are you

[sqlite] controlling changes

2009-10-10 Thread David Bicking
I have a table: CREATE TABLE Assets ( ControlDate Date , Amt ) Now, the business rules are you can INCREASE the Amt if the Current Date is the ControlDate in the record. You can DECREASE the amount if the Current Date is greater than or equal to the ControlDate. Can this be enforced v