Insert error

HCL Domino Domino Forum
1

this TimeType insert unsuccessfully.sql:insert into t(num1,datetime1,varchar1,text1) values(218,‘1980-02-15’,‘gg1’,‘gg’).

I executed it successfully,but data do not be inserted into Notes DataBase…The Field ‘datetime1’ is empty and anther field is successful…

num1:218

datetime1:[empty]

varchar1:gg1

text1:gg

for ODBC cmd.ExecuteNonQuery(),VS.Net(C#),NotesSql

The Example is in IBM Site.

e.g.

INSERT INTO STAFF VALUES (‘000001’, ‘Zambini’, ‘Rick’, ‘1980-02-15’, ‘Los Angeles’, ‘000000’, 6000, 5.0)

http://www-12.lotus.com/ldd/doc/notessql/3.0.2f/notessql.nsf/66208c256b4136a2852563c000646f8c/3927c37a14cf909985256dd7004d83d1?OpenDocument

New discover: update t set datetime1=‘2007-12-19 08:43:26’

this SQL could execute successfully!!

I don’t know what is difference between “Insert” and “Update”?

who can help me??thanks.

2

Subject: insert error

The SQL command INSERT is used to create a new record in your database. The command UPDATE is used to modify an existing record.