>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