Update Date Problem with VB

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

Re: Update Date Problem with VB

Hi, 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

Re: Update Date Problem with VB

Optik Bacik Scheibbs [EMAIL PROTECTED] wrote: 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