Hi David,
Yes this view uses 4 tables, but only 1 is updatable. The other 3 are used just for filtering.
I fixed my problem by :
1. Going into the view designer and Check-Mark the 2 fields.
2. Save the view (the 2 fields show up on CURSORGETPROP('UpdatableFieldList')
3. Going into the view designer and UN-Check the 2 fields.
4. Save the view (the 2 fields DID NOT show up on CURSORGETPROP('UpdatableFieldList')
Thanks for pounding away until I got it.
>Bill,
>
>Are you sure the view is set to Send SQL Updates? Do you have PKs? You know this might be an issue that you've got a multitable updateable view. I have never used one of those beasts, I prefer to stay with single table read/write views and only multitable views for read access.
>
>You might check out eView (from Erik Moore) and another view maintenence tool that Steve Sawyer has written.
>
>>Yeah I'm still having trouble with this.
>>I ran your code, and sure enough it works the way you said.
>>I added the primary keys and check marked c1 to update and c2 did not show up on CURSORGETPROP('UpdatableFieldList')
>>
>>My problem: I've triple checked my view. I have 2 fields that keep showing up on CURSORGETPROP('UpdatableFieldList'), but they ARE NOT check marked in the view designer. After looking closer they are the only 2 fields in that table that show up, all the rest of the fields in that table don't show up. Always before, I saw those 2 fields, so assumed that it didn't work the way I thought and quit looking further. So now I guess there's something wrong with my view and the way VFP 7.0 is storing it in the DBC.
Bill Morris