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
In the beginning, there was a command prompt, and all was well.