Sean,

> I believe that Jim had once posted that in Netfrastructure he had create
> a new keyword REPLACE, which updated a record if it existed, otherwise
> it inserted a new row.

I'm aware of that but if I am not mistaken, that was where metadata items
were concerned was it not? That wouldn't be possible with data unless there
was a built-in semantic for unique record identification as there is with
metadata updates. I presume it would only be possible with tables containing
a primary or unique key. Otherwise, there is a potential element of
ambiguity which might have some painful consequences.

Anyway, lets not detract from my suggestion by zeroing in on the simple case
I used to present it.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com