Cetin,
>You might indirectly change datatype to memo with SPT. If usememosize is less then your varchar column length then VFP would automatically use a memo column. After initial select it wouldn't do any good for you but you could set it before initial select using system cursor (0) as cursor. ie:
>lnHandle = ....
>cursorsetprop('UseMemoSize',1,0)
>SQLExec(lnHandle,'select....
>* Now any varchar field wider than 1 char is memo field.
:) You're right! You could also have written RTFM <g>. I looked for that in the help file, since similar things can be done with SQLSETPROP(0, ...) to set default values, but have totally overseen that sentence with work area 0. I tried setting cursorsetprop('UseMemoSize',1,'') but didn't try 0.
Thanks again for the information,
Armin