Information générale
Titre:
How to update Notes datetime type field using 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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement