Follow up.

The insert is working but the data is getting blown away by a REPLACE statement. What is a mystery is why it only happens the second time. I have tried recreating the view but to no avail. I can get around it by closing and reopening the view each time but this is not a long term solution.

This problem has only just started happening today.

Does anyone have any idea why a

REPLACE myfield WITH m.cVar IN myremoteview ALL

would clear all the fields in that record and only the second time?

The view is a remote view.

Regards
Geoff Scott

>Hi
>
>I am getting a weird problem when inserting into a view from an object. I requery to get an empty view. The secont time I do this the record gets created but has no data (values).
>
>Any ideas why this might be happening?
>
>Regards
>Geoff Scott