I am having terrible problem with a recordset that I am persisting to XML
then turning back into a recordset. The XML is jigged so that it believes
it is a recordset from the current database, even if the database is
different from the one that it comes from.
My problem occurs only with Date/Time fields. A time value is pulled from
the database and the XML is told that it is the original value. The value
does not change, but when a batch update is executed an error occurs
because the database thinks the value has changed. There appears to be no
problems with fields of any other data types and the problem is consistent
with certain values, but only ones that are currently in the database; I
can open the database and type the same value over the top of the problem
value, execute the batch update and it works!!
The same record will update using the ADO data control.
A query on the value will not return anything either, but if the value is
retyped in the database it does.
Any thoughts/ideas would be greatly appreciated as I am completely at a
loss as to what it could be?
Regards,
Phillip