Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert fields
Message
From
08/09/2005 07:10:37
 
 
To
08/09/2005 07:07:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01047638
Message ID:
01047642
Views:
8
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform