Hi Joel,

What do you mean by "transferrable to a table with a key based on one
column"?

It seems to me that you just need to:
UPDATE mytable SET value1 = 'somevalue', value2 = 'someothervalue' WHERE
PRIMARYKEYFIELD1 ='something' AND PRIMARYKEYFIELD2='something2';



On 2001.10.24 19:00 Joel Wickard wrote:
> I have some tables in my database that have primary keys based on 2
> columns,
> and some that have primary keys that are based on a single column, I need
> to
> formulate a single UPDATE query that will be based on the primary key
> only,
> so that it would be transferrable to a table with a key based on one
> column
> or a table with a key based on two columns.  i.e.   UPDATE mytable SET
> value1 = 'somevalue', value2 = 'someothervalue' WHERE PRIMARYKEY 
> 'something';
> 
> is this possible, and if so, can someone point me at the correct syntax?
> 
> Thanks in advance
> 
> -Joel
> 
> 
> 
> 
> 
> 
>