Re: REPLACE single value

2001-07-20 Thread Werner Stuerenburg
Sorry, I didn't use replace yet, I always work with update which is what I want. Are you sure you want to use replace? See the differences in the manual. The syntax for update is UPDATE table_name SET col1 = '$val1', col2 = '$val2', col3 = '$val3' WHERE p

REPLACE single value

2001-07-20 Thread Jane Dennett-Thorpe
I would be grateful if someone could tell me how to replace a single value in a table. What i want to do is something like REPLACE contacts (access) VALUE ('P') WHERE id=x but this doesn't seem to work. (and i can't use REPLACE SELECT becasue this would require selecting on same table as repla