>>>I've used views of views before without issue, but apparently they were all non-updateable and I didn't realize it. I'm trying to do an updateable view of an updateable view, and the View Designer isn't having it. The view was using v_otherview as an apparent free table, but the DBSETPROP statements use Database!lv_otherview. Manual changes to "v_otherview" were undone when saved.
>>>
>>>Can this be done, or do I need to change lv_otherview to do what I created lv_viewofview for?
>>
>>Can you use CursorAdapter instead?
>
>Not at this stage of the game.
I would suggest to not use view based on another view - can you convert your view to be based on tables directly?
If it's not broken, fix it until it is.
My Blog