Can I use alter table on a temp cursor, I need to expand field lengths made by a sqlexec command.

or if not,
any suggestions, to get a cursor from sqlexec. which has proper field lengths, using Mysql, the data being send back to VFP is trimmed - becuase it stores it trimmed.
I have tried to change the type of fields on the server to regualr chr(20) instead of varchars() . same result. trimmed results. which dont work all that well for editing.

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