>hi,
>thank you,
>i try it before i get only the fields without any data.

Then you did something wrong! Try again, and check that the selected record really contains any data.

>
>>Remove the EXCEPT keyword

>>scatter fields char2 , char4 , char7, char8, char9, char13 ,     char25, char26, char27, char28  memvar

>>
>>>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.