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
May all your weeds be wildflowers