[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    strange thing om Win98 / MyODBC / Access 97
From:       "Lieven Van Acker" <lieven () logistiek ! sintlucas ! wenk ! be>
Date:       2000-01-19 17:18:28
[Download RAW message or body]

Seems like 

the update query, generated by access, to update the current record, compares each \
field with it's current value in the where clause.

Datetime fields are compared as

mydatetimefield = 19940901000000 (on win98)

and

mydatetimefield = '19940901000000' (on win95)

The former doesn't work, the latter does.
As a side effect, as the former doesn't match a record, access tells me that another \
user has modified the record.

Is there a way to work around this problem? Any other experiences?

Lieven
------------------------------------------------------------------------------
Lieven Van Acker	        Tel:	09/2252000 (0477/614167)
Sint-Lucas Logistieke Diensten	Fax:	09/2251379
Informatica			e-mail:	lieven@logistiek.sintlucas.wenk.be
------------------------------------------------------------------------------
                    


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread1097@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.


[prev in list] [next in list] [prev in thread] [next in thread]