hi,
thank you for reply,

i have many fields at my table i need to keep fields char2 , char4 , char7, char8, char9, char13 , char25, char26, char27, char28 only and delet others fields. any idea
thanks.

>Mohammed,
>
>Try:
>

SCATTER MEMO MEMVAR BLANK

>on the line before

scatter memvar memo

>
>While you're at it, I'd also recommend reading this article:
>http://fox.wikis.com/wc.dll?Wiki~DataNormalization~SoftwareEng
>
>
>>hi all,
>>any idea, help,
>>i try via code under to insert those fields only at my table , but i see other fields but empty fields,
>>i don't want to get this fields at my table , just fields i choise ,
>>

>>scan
>> if !seek(char9,'am','char9')
>> * scatter memvar memo
>>**i try as..   scatter fields   char2 , char4 , char7, char8, char9, char13 ,     char25, char26, char27, char28  memvar &&& no data at my table
>>
>> scatter fields except  char2 , char4 , char7, char8, char9, char13 ,     char25, char26, char27, char28  memvar
>>   insert into am from memvar
>>
>> endif
>>endscan
>>

>>
>>thanks.