I have created an updatable view via an ODBC source and also a VFP free table source for confirmation. I can select data from the source and edit it using commands such as replace and the view updates the source fine.

However, if I use the SCATTER NAME and GATHER NAME functions as the way to update the view the view will not update and I have to do a tablerevert().

Any ideas out there ? I am sure I am doing something silly.


Thanks

Joe Walsh