>>I need to populate a grid from a SQL-SELECT with a UNION then be able to update that data then append parts of it to a table. What method can I use to do that? I have discovered that a cursor is read only so that won't do. I am kinda stuck...
>>
>>Thanks
>
>Hi John -
>
>Try using an updatable view - it's like an updatable cursor. The view is stored in your DBC. There is a view designer that can help you with the simple views and then you can modify it outside the view designer for more complex views (i.e. for unions, joins, etcs.). There are a lot of threads on this topic, so you should be able to get some good info.
>
>Sylvia

How do you modify it outside of the view designer?

THanks