Inserting data into a column

[StacyStacy]

How do I insert data into a column of numereous records?

Thanks

 

[DSummZZZ]

Are you trying to add a column to the table or replace data within an existing column or field?


-Dave Summers-

Even more Fox stuff at:

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

 

[StacyStacy]

I have already added a column to the table. I want to simple add the word, "WRIS" into a column named, "WRISID". How do I write that?

Thanks!

 

[DSummZZZ]

Here are some examples for 1 record, all records, and a subset of records. Just for future reference:

*... for one record
REPLACE wrisid WITH "WRIS"

*... for all records
REPLACE ALL wrisid WITH "WRIS"

*... for records that meet a certain criteria
REPLACE wrisid WITH "WRIS" FOR lastname = 'SMITH'


-Dave Summers-

Even more Fox stuff at:

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