insufficient key column information for updating or refreshing

I have a TAdoDataset that uses a couple of MS SQL 2k views as the datasource
(inner joined). 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. I am able to navigate the grid that displays the dataset
without any trouble. The grid is not editable of course because the data
source is too complex. There are a couple of instances on this form where I
need to refresh the dataset. When I do so I get "insufficient key column
information for updating or refreshing"

If I set the dataset to active = false and turn it on again that works fine
but I really don't want to do that. I just need to refresh it so that a
couple of the columns are updated with new numbers. What can I do to get
refresh to work? Is there a way to use TBetterAdo here that would solve my
problem?

Thanks,

Keith


.

Relevant Pages

  • Re: Clear Grid Content
    ... I wrote the refreshing code for that grid in an isolated sub procedure ... I want it refresh anytime page loaded but if I call the sub during the page ... the contet inside the grid are the combination of first DataSource and New ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Child grid woes
    ... pointer), but only with the wait statements running. ... in the grid refresh I've issued a NODEFAULT. ... insert into kid values ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Child grid woes
    ... row of the child grid, then click the refresh button (which issues a form ... insert into kid values ...
    (microsoft.public.fox.programmer.exchange)
  • "Cannot change ReadOnly property of the expression column"
    ... DataSource). ... and displays it in the grid. ... calling a refresh on the grid) and two, I am getting a Cannot change ... For the column refresh problem, I added code to manually fill in that ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Clear Grid Content
    ... I wrote the refreshing code for that grid in an isolated sub procedure ... I want it refresh anytime page loaded but if I call the sub during the page ... the contet inside the grid are the combination of first DataSource and New ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)