June 21st, 2000, 04:26 AM
I need to modify record.pls tell me how....
June 21st, 2000, 06:04 AM
Please be more specific!
However you can modify a record like this using SQL:
UPDATE (tablename) SET (column_name) = '(Original_Name)' WHERE (column_name) = '(New_Name)';
The pieces in brackets you'll have to replace with something of your own. This will modify ALL the records whose names are Original_Name and change the name to New_Name
June 21st, 2000, 08:40 AM
Actually, Alex, you got that backwards. The way you have written the query it will change column_name to original_name where column_name = new_name
June 21st, 2000, 10:26 AM
Let's say that you have a table called "table1", which has a column called "column1".
In this column you want to update all rows containing the value "Value1" in "column1" to contain the value "Value2"
UPDATE table1 SET column1='Value2' WHERE column1='Value1';
[This message has been edited by releasedj (edited June 21, 2000).]
June 22nd, 2000, 11:37 PM
how if the value we going to change is a string...