In my experience, the odbc driver for Mysql, will by default only send over to a vfp cursor, the field length of the largest field So if in your field, you have a char(50) field, and the largest alltrim(field) is only 20 you will get back a cursor with only char(20) in a vfp cursor.

are you using the odbc dsn in the control panel, or are you using a connection string ?

Bob
ps.. yahoo membership to the mysqlvfp group is open, if you have been validated within yahoo, you should have no problem with the group.
>


>I'm waiting for membership of Yahoo group to see the first tip but the second one hasn't made any difference. I'm at a loss as to why it doesn't return the full field size (I've even tried changing from varchar to char without success!)
>
>I cant even manually change the property to the right size as the view designer just puts it back to 20.
>
>TIA
>
>Barry