Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append via select
Message
From
08/12/2005 04:06:41
 
 
To
08/12/2005 04:03:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01076028
Message ID:
01076034
Views:
26
Change WHERE to FOR. And note that Jos did not try to solve your problem, he only wanted to push you in the right direction.

>hi,
>thank you for reply
>i get error message
>Command contains unrecognized phrase/keyword
>
>thanks.
>>>hi all,
>>>
>>>any idea , help
>>>i try to append new records to mytable, as under
>>>
>>>
>>>Select * from rami3 ;
>>> where inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ                                   ") ;
>>> append blank;
>>>   into table rami4 nofilter
>>>
>>>thanks
>>
>>You are mixing your SELECT with your APPEND. Rather do something like:
>>
>>
>>SELECT rami4
>>APPEND FROM rami3 WHERE inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ")
>>
Previous
Reply
Map
View

Click here to load this message in the networking platform