>What I guess I am looking for is the ability to change field widths of cursors or create a new cusror (readwrite) with valus from my old cursor. .. set with proper field widths.?
>
>AM I making any sense. ?
>
>thanks
>Bob Lee
Yes, Bob, do you make sense. The ODBC driver from MySQL is one the worse ODBC drivers ever written.
The only way you can stop this behavior is the define the datasource in ControlPanel, then to go on it and check the 'Pad char to full length', 'Don't optimize column width' and 'Safety (check this if you have problems)'. unfortunatelly, there is no way to accomplish this in code.
Hope this helps.
Grigore Dolghin
Class Software.