> You could pass the values of the new record to a stored procedure,

the SP checks if the PK already

> exists and if so, updates the record. Otherwise, it inserts the

record.

>
>
> Florian

So, if I understand you correctly, you are saying that
(1) it IS the case that I must know in advance whether a record I
want to add is to be INSERTed or UPDATEd; and
(2) a stored procedure would be a more efficient way of doing this
than a query.

Correct??

Thanks,
-- Stan