Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Confused with APPEND FROM a TO b FOR x = varx
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00230396
Message ID:
00230558
Views:
18
AFAIK, this "feature" only affect appending from a table, where the field on which the FOR part is based do not exist on the destination table.

>I have not experienced that! When I have run APPEND FROM with a FOR clause, it has worked correctly. For example, I used the following code to create a cursor of the Procedure/Function and Parameter statements from one of my procedure files:
>
>CREATE CURSOR Prg (Line C(254))
>APPEND FROM Mc_procs.Prg TYPE SDF ;
> FOR UPPER(LEFT(ALLTRIM(prg.line),4))=="PROC" ;
> OR UPPER(LEFT(ALLTRIM(prg.line),4))=="FUNC" ;
> OR UPPER(LEFT(ALLTRIM(prg.line),4))=="LPAR" ;
> OR UPPER(LEFT(ALLTRIM(prg.line),4))=="PARA"
>
>Perhaps using a cursor as the destination or the TYPE SDF has some effect, I don't know. Do you name the destination alias in the FOR clause that fails?? (BTW, I got help creating this code from Christof Lange)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform