U++ forum: Welcome to the forum

Re: 607-Dev3 Errors (worked previously) [message #4309 is a reply to message #4308]

Tue, 01 August 2006 04:28

rbmatt
Messages: 90
Registered: July 2006
Location: Tennesse, USA

Member

I've found out its not just my code.
reference/SQL_SQLite3 gives the same error (if you fix line 79 to be bdate instead of date).

Sql insert("insert into SIMPLE_TEST1(name,bdate) values(?,?)",sqlite3);
	insert.Run("joseph",19990101);
	insert.Run(  "neel",19990102);
	insert.Run(   "bob",19990103);
	insert.Run(    "al",19990104);

ERROR SQL logic error or missing database: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (0, 'Joe', 'Smith', 20000101)
ERROR PRIMARY KEY must be unique: Resetting statement: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (0, 'Joe', 'Smith', 20000101)
ERROR SQL logic error or missing database: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (1, 'Mike', 'Smith', 20000102)
ERROR PRIMARY KEY must be unique: Resetting statement: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (1, 'Mike', 'Smith', 20000102)
ERROR SQL logic error or missing database: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (2, 'Jon', 'Goober', 20000103)
ERROR PRIMARY KEY must be unique: Resetting statement: insert into SIMPLE_TEST1(ID, NAME, LASTNAME, BDATE) values (2, 'Jon', 'Goober', 20000103)

Report message to a moderator