>Hi All,
>
>
>I have an older vfp application that accesses a MySQL database on linux and for the most part it works just fine. I wanted to show it to a potential customer of mine and so I download and install the windows version of MySQL and restored the database. When I started testing it failed on the update command something about an invalid dateformat. The table has date fields with nothing special as far as I can see and linux version doesn't have a problem with a blank date field. What am I missing here ? Do I have to write additional code to handle blanks ?
How do you build your update string? If you're using dtoc(), you may get an ambiguous format. From what I remember about MySql (didn't have the need to touch it for a year - time flies and my side project is moved to back burner of third order by now), it should accept a number of formats. Looking at my old code, I was sending dates as dtos(), surrounded by the quotation marks (the chr(95) ones, then), and it didn't complain. And, IIRC, it accepts the empty date, but for that you better check the documentation.