General information
Category:
Forms & Form designer
>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only