NotesSql_ODBC_TimeField data 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: NotesSql_ODBC_TimeField data insert error??

Notes may be failing while parsing out the date string.Change the format of date string to the one Domino understands better.

Try:

sql:insert into t(num1,datetime1,varchar1,text1) values(218,‘15/02/1980’,‘gg1’,‘gg’)

Regards,

Litty Joseph

3

Subject: RE: NotesSql_ODBC_TimeField data insert error??

Thanks Litty Joseph.But I try to execute the SQL and had a Exception( ERROR [42000] [Lotus][ODBC Lotus Notes]Incompatible data types in comparison)

The Example is in IBM Site.

e.g.Examples

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

4

Subject: RE: NotesSql_ODBC_TimeField data insert error??

In Notes form create one Text field to receive whatever is coming SQL side. Then for actual date field, create computation formula which parse out the text value added by SQL.

Regards,

Litty Joseph

5

Subject: RE: NotesSql_ODBC_TimeField data insert error??

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”?