Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: Updatable Recordset Not finding record - value is unchanged


Message #1 by "Phillip Johnson" <phillip.johnson@e...> on Fri, 12 Apr 2002 09:23:41
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


  Return to Index