Hiya Joe,

Don't play the guitar, do you? :-D

Let me elaborate a bit on what Josh posted: REPLACE and other commands may appear to work fine because they span multiple rows and there is an implicit TABLEUPDATE() firing. GATHER, since it affects a single row, will require an explicit TABLEUPDATE().


>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.