OOPS. thanks for the clarification Cetin.
>>
>>scan for puncharcactualdata.jobnum=punchheader.jobnum
>> scatter MEMO NAME lotable
>> insert INTO punchactualdata FROM NAME lotable
>> delete
>>endscan
>>
>>
>>
>>>I am using the following to populate/copy data to another table.
>>>
select puncharcactualdata
>>>scan for puncharcactualdata.jobnum=punchheader.jobnum
>>> scatter MEMO memvar
>>> insert into punchactualdata from memvar
>>> delete
>>>endscan
>>>
>>>However, the memo field is not getting populated, How can I force the memo field to get populated.
>
>Tracy,
>In VFP8 only. "Insert .. from memvar" works with memo too, probably his problem is fieldnames do not match (one is Longfield orher not?)
>Cetin
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"