Sorry guy's - belay that.

As they say -when you assume you make an a** out of you and me both :-)

Oh, bugger political correctness...

As far as I'm aware of, the offending word a** with the ss, which I grant may be viewed as slightly obscene if one is an American, in this case merely describes an animal otherwise known as a donkey.

Anyway, it turns out the insert failed because the Id column was defined as NOT NULL but not as Identity(seed,increment).

----

Thank's

Peter


>Let's assume:
>
>A Remote View MyRv with fields MyId, Lastname, Firstname.
>
>MyId is the keyfield defined as Identity(1,1) on the server.
>
>MyId is set as KeyField - not updateable in the MyRv
>
>Lastname, Firstname are updateable.
>
>Insert into MyRv (Lastname, Firstname) Values ('Peter','Pirker')
>
>TableUpdate(.t.,.t.) fails with "Cannot insert the value NULL into column MyId...."
>
>I seem to have read about this somewhere but I just can't remember where,
>so any help is appreciated.
>
>TIA & BR