Just a note that might save you some hassle : it is a very good idea when you create a view using all the fields from a table that you reverse the order of two of the fields in the view designer so that the SQL specifies the field names. If not, when you add a field to the underlying table your view is hosed.
Also (for benefit of lurkers) remember that if you are changing the name of a field in a table it is worth considering if any views use that field and to remove the field from the selected fields in the view first. Then, after renaming in the table, go back to the view and select the renamed field as chosen.
>I want to programmatically create an updatable SQL View.
>
>So I went to the View Designer, filled out all the necessary
>fields, including the updates page, and this is the code it
>produced:
>
>
> SELECT *;
> FROM Client!Head;
> WHERE Head.ControlId = ?cControlId;
> ORDER BY Head.Acct_No
>>
>When I run this code in a PRG, and make changes to the resulting
>view, the changes are not reflected in the source table.
>
>So how do I programmatically create an updatable SQL View?
>
>Thanks
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
