>Dear Sir,
>
>Please write some codes to fulfill the purpose.
>
>Thanks in advance
For example, in one case you indicated the combination 9-2, and you wanted to change this to 9-7.
You can use:
replace Field2 with 7 for Field1 = 9 and Field2 = 2
or, using SQL syntax:
update MyTable set Field2 = 7 where Field1 = 9 and Field2 = 2
You have to be careful with the SQL UPDATE syntax - just like with the SQL DELETE syntax: if you forget the WHERE clause, all records will be replaced or deleted!
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
