I have the following table
CREATE TABLE Sighting (
SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL,
SpeciesId integer,
LocationIdinteger,
SightingDate date,
Note nvarchar(100)
);
and the following insert
INSERT INTO Sighting
try inserting year/month/day
Emilio
I have the following table
CREATE TABLE Sighting (
SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL,
SpeciesId integer,
LocationIdinteger,
SightingDate date,
Note nvarchar(100)
);
and the following insert
INSERT
lrjanzen wrote:
I have the following table
CREATE TABLE Sighting (
SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL,
SpeciesId integer,
LocationIdinteger,
SightingDate date,
Note nvarchar(100)
);
and the following insert
INSERT INTO Sighting
Scott Baker wrote:
lrjanzen wrote:
I have the following table
CREATE TABLE Sighting (
SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL,
SpeciesId integer,
LocationIdinteger,
SightingDate date,
Note nvarchar(100)
);
and the following insert
INSERT
2008/4/25 lrjanzen [EMAIL PROTECTED]:
I have the following table
...
and the following insert
INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note)
VALUES (3005,22,'2/26/2008','New Note')
the insert works EXCEPT the date keeps coming in as NULL! What am I doing
wrong?
Thanks
On Linux I get
SQLite version 3.5.6
Enter .help for instructions
sqlite CREATE TABLE Sighting (
... SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL,
... SpeciesId integer,
... LocationIdinteger,
... SightingDate date,
... Note nvarchar(100)
... );