On Thu, Jun 12, 2008 at 5:50 AM, Harold Wood <[EMAIL PROTECTED]> wrote:
> Hello Igor > the create table statement: > > CREATE TABLE Items > ( > ID INT NOT NULL PRIMARY KEY ASC, > SubCatId INT NOT NULL, > Description VARCHAR(60) NOT NULL, > LastUnitPrice NUMERIC(6,2) DEFAULT 0.0, > AvgUnitPrice NUMERIC(6,2) DEFAULT 0.0, > MinUnitPrice NUMERIC(6,2) DEFAULT 0.0, > LastPurchaseDate DATETIME, > LastQtyPurchase NUMERIC(6,2) DEFAULT 0.0, > PurchaseUnit VARCHAR(20), > NumTimesPurchased INT DEFAULT 0, > NeedIt BIT DEFAULT 0, > FOREIGN KEY (SubCatId) REFERENCES Subcategory(ID) > ); > where is DateCol ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
