trying it now. but I was thinking along those lines... and then I remember a few months ago, I was emailing back with Jack nance, and I have some code here how to set up a DSN-less connection, which set these options.... I am looking for them...
Ill let you know if it starts to work with these options, and then, if so, Ill worry about how to do it in code...

thanks !
Bob Lee



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