Simple Replace program 2

[Peter10]

I need a simple three or five line program and can't recall the structure.

I have a table with a field city. In many of them I've entered SLC rather than Salt Lake city. I want to open the table exclusive and replace that field where it is SLC with Salt Lake City. Replace all works great, but I only want to replace it where the field holds SLC. Help!!!!

Got brain freeze.

Thanks

 

[DSummZZZ]

Try this:

REPLACE ALL city WITH 'Salt Lake City' FOR city = 'SLC'

Dave S.

 

[Guest_imported]

You da man. Where do I send the check....

Thanks. It's the little things in life that make it sooo much easier.

Muchichasmas Gracias it was the = sign I was missing.

Pete

 

[repete]

just my 2 cents worth....

i have found in a multiuser application where there is a large database that the 'replace all' locks the header of the file, and prompts the 2nd user to wait. of course if the user misses the prompt, and presses the esc key as they often do, then problems occur.

instead of 'replace all', i use a scan... endscan as follows

scan FOR city = 'SLC'
REPLACE city WITH 'Salt Lake City'
endscan

of course if you are just updating from the command window, then 'replace all' is the way to go


Pete Bloomfield
Down Under