>>I have a table and I need to transfer the memo fields to character
>>base fields. I do not want to loose any information.
>>How do I change a MEMO field to a CHARACTER field?
>The only way to assure of no data loss would be to create a child dbf with multiple records. I would do something like...
>
>create a dbf with an id field and a char 80 field
>set memowidth to 80
>select olddbf
>scan
>store memlines(olddbf.memo) to linecount
> store id to m.id
> for i=1 to linecount
> store mline(olddbf.memo,i) to m.charfield
> insert into newdbf from memvar
>endfor
>endscan
thanks Larry for the help..rob