replace with a list

[Kerbouchard]

This is probably a simple answer but I can't seem to find it anywhere.

If I want to use replace based on a list of data for a field how do I do it?

Example which doesn't work but you'll see what I'm trying to do--

replace all;
cust.salsmn1 with "ART003", cust.comrate with 10, cust.terr with "03" for cust.zip="06430" and type in ("REST","CLUB","CRUI/AIR")

Thanks in advance for the help!!

 

[DSummZZZ]

If I understand correctly, try this instead:

replace all;
  cust.salsmn1 with "ART003", cust.comrate with 10, cust.terr with "03" ;
  for cust.zip="06430" ;
  AND [COLOR=blue]INLIST(type , "REST","CLUB","CRUI/AIR")[/color]

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[JRB-Bldr]

If I understand your question about "type in ...", you should be looking at using Macro Substitution.

Something like:

* --- User enters the following somehow ---
mcTypeIn = "'REST,CLUB,CRUI/AIR'"

mcVFPCommand = "REPLACE ALL cust.salsmn1 WITH 'ART003',";
   + " cust.comrate WITH 10,";
   + " cust.terr WITH '03'";
   + " FOR cust.zip='06430'";
   + " AND ALLTRIM(cust.type) $ " + mcTypeIn
 
* --- Now Execute Command ---
&mcVFPCommand

NOTE: Be cautious of use of single and double quotes as coordinated 'pairs' so as to keep the string working properly.

If I didn't include too many typos, that should work.

Good Luck,
JRB-Bldr

 

[Kerbouchard]

Perfect they both seem to work. Thanks!!!