Thanks for all the advice about using Visual Foxpro 6 with MySQL. I have started to create my application and have come across a strange problem. In MySQL i have a field in a table called Address1, it is VARCHAR(40) ... when i create my view i can run the sql and see the results no problem. As soon as I save the view and then try to browse the view I get a datatype is invalid error. Looking at the properties of Address1 it seems to have been bought into the fox view a CHAR(1) ... any ideas ???? Regards Chris. I have the latest win32 version of mysql (binary) the latest mysqlodbc driver and visual fox 6 (sp5)<br clear=all><hr>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br></p>
