General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
How to update Notes (R5) datetime type field with ADO
Hi All,
I am having trouble updating the notes datetime type field. If i change type
to text then i can write no problem.
Column name is DATE type datetime
code that it fails
rs.FIELDS("Date").VALUE = datetime()
it actually fails on rs.UPDATE
The error is that OLEDB Provider for ODBC driver
Lotus Notes ODBC driver " Data value is not valid date, time or timestamp."
I tried putting the character, converting DateTOCharacter(datetime()) to no
avail.
Only if i change in Notes designer DATE type field from datetime to text I
can write to it.
I am using Notes R5 designer and Client and Lotus Notes ODBC ver 3.00 driver
on Win NT machine.
Testing with VFP6 and VB6 using ADO 2.5
Please help.
Thanks
Dejan
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only