>>>Colin,
>>>
>>>
What is the ideal blocksize to allocate?>>>
>>>What's going in the memo?
>>
>>Vaiable length text could be upto 100-200 chars
>
>I suggest you try 256. Be aware that you must a sequence of two COPY TO commands to make the change take effect. A better solution may be to update to VFP9, and use a varchar field. Or you can simply use c(200) field? In general, a memo field is not good for frequently changed/add data.
Tore
We're looking at the VFP9 move at the moment - thanks for your help
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing