What is the table definition? Have you got a primary index?
I work with date fields without problems in this way:
Update table set Date_Field = '2003-08-01' Where Date_Field = '2003-01-19'
Lourdes.
Optik Bacik Scheibbs escribió:
Hey!
So this is my first time here...
I am using myODBC 3.51 Server 4.0.14
So I created a table with one columm called "GebDat" - format Date
I connect to this DB using VB6 (SP5) with ADO. OK - So when I add a new data it works fine. But when I will update any one data I always get an error! I ´ve tried to set the string with a format like = FORMAT(Now, "yyyy-mm-dd"), but it also won´t work.
Thanks for helping
--
Sus tiendas favoritas, útiles herramientas de compra y grandes ideas para regalos. ¡Compre en línea cómodamente con [EMAIL PROTECTED] http://shopnow.netscape.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
