Re: ODBC...With something like MS Access you can

[Anton Hinxman]

Yep, it LOGICAL is a problem and so are DATES and DATETIME.

You also need to look at the cursor adaptor class in FFC of VFP 8/9.

Basically you hold the cursors in a view and translate between the server data and VFP so as to reduce your front end changes in VFP.

Because your code may not be frendly to SQL (such things requiring SQL views) then it may be better to go all the way and re-write your front end code to handle both.

If you can not afford the time or do not wish to risk the code change, of such an approach, then look at:

http://www.informit.com/articles/article.asp?p=174330

and then adapt to data types/sizes for MySQL.

In my view Pinter's method outlined in Chapter 3 is the best/simplest.

Personally, I automate the conversion of DBC related tables into InnoDB related tables and automatically populate them with the MySQL load statement via exported text files.

Anton Hinxman