Re: insufficient key column information for updating or refreshing

Am Mon, 30 Oct 2006 10:45:30 -0500 schrieb Keith G Hicks:

...The views themselves are a bit complex. The final result
returns columns that include the primary key of one of the base tables and
the rows that are returned are absolutley unique. There is no possibility of
duplication. ...
Yes, you know this, but why should TAdoDataSet know this?

... What can I do to get refresh to work? Is there a way to use TBetterAdo here
that would solve my problem?

I am not sure if this helps, but try to build your view with option WITH
VIEW_METADATA, for example:

CREATE VIEW dbo.vwAllCustomers WITH VIEW_METADATA
AS SELECT * FROM dbo.Customers

And then if you use INSTEAD-OF-Triggers together with your view you can
even directly insert/update/delete data.

bye,
Helmut
.