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

Re: [sqlite] controlling changes

2009-10-10 Thread David Bicking
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 can INCREASE the Amt if the Current Date > is

Re: [sqlite] controlling changes

2009-10-10 Thread Harold Wood & Meyuni Gani
You can do it as a constraint. -Original Message- From: David Bicking <dbic...@yahoo.com> 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

[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