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
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
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
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
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
5 matches
Mail list logo