Mark,

One more thing. Is buffering enabled on the table? If so you should either turn it off (you shouldn't need it if you're only updating the table through the view) or TABLEUPDATE() the table after you update the view. I've got a good feeling about this one.

>No, the vTest view is based on a table called test.dbf.
>
>>The view isn't based on a view, is it? If so you need to TABLEUPDATE() the view it's based on after you update vTest.
>
> >>Here's my original code...
> >>
> >>lcStatus = "Customer"
> >>SELECT vTest
> >>INSERT INTO vTest (firstname,lastname,status) ;
> >>VALUES ("Joe","Smith","Customer")
> >>= TABLEUPDATE()
> >>= REQUERY('vTest')
> >>BROWSE
> >>
> >>Yes, the where clause has test.status = ?lcStatus, which you can see I set to "Customer" and the values of the INSERT INTO is also "Customer".