update with composed pirmary key

Jul 3, 2012 at 2:09 PM


I am trying to perform an update for a table where primary key is composed by two fields. Could somebody give me a clue about how to perform this update? I have tryed using mytable(field1:value, field2:value) but it did not work. Some idea?


Jul 24, 2012 at 4:16 PM

You must use it in this form mytable(field1=value, field2=value) equal (=) instead of colon (:).