General information
Category:
Database DAO/RDO/ODBC/ADO
Is there a function in the Lotus Notes side of things that can accept a character and convert it to a date?
Seems like you've covered the options, the most direct being passing the date as a character to the Notes ODBC driver.
>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
Previous
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