This is a bug in the View Designer which is a real PIA. Hope they fixed this in VFP7. Anyway, issuing the DBSETPROP() function once from the command window will do it as in the example below:
DBSETPROP("rv_lineitem.crntstart_note", "FIELD", "DATATYPE", "C(50)")
Just remember that if you make any changes to the view, you may have to repeat this.
>I've been trying to create remote views from VFP 6.0 sp5 on a couple of tables in MySQL using the MySQL ODBC driver for Win95.
>
>The problem I have is that when you look at the field properties for character fields the largest size I can set is 20 characters even though it is 35 characters in the table. Even Access manages to connect (with the same DSN) and get it right.
>
>Anybody got any ideas what I need to change in VFP to make it work?
>
>Barry
- Jeff