>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.
>

It seems very inconsistent. Creating a number of identical views from the same base table some fields come over correctly some don't and it's not always the same field(s) that are wrong. I can find no way of reproducing the errors consistently.

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

I'm using the odbc dsn from the control panel
>
>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 "pending" at the moment waiting for the moderator to approve me!

Barry