hi,
thank you,
i try it before i get only the fields without 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.