Delphi insufficient base table information for updating or refreshing

Mark"You guys pair up in groups of three, then line up in a circle."- Bill Peterson, a Florida State football coach Mark, Thanks for the reply.I understand your example, however once record has been updated (1st run), it's not going to be included into recordset after requery because there's a selection criteria in my sproc.I have a TAdo Dataset that uses a couple of MS SQL 2k views as the datasource(inner joined). The final resultreturns columns that include the primary key of one of the base tables andthe rows that are returned are absolutley unique. I am able to navigate the grid that displays the datasetwithout any trouble.The grid is not editable of course because the datasource is too complex.There are a couple of instances on this form where Ineed to refresh the dataset.When I do so I get "insufficient key columninformation for updating or refreshing"If I set the dataset to active = false and turn it on again that works finebut I really don't want to do that.

The application works fine with Win98/NT but gives error in accessing some reports(in crystal) having chart components in Windows 2000 and Windows XP.

I received this error, "Insufficient base table information for updating or refreshing," while trying to add a new record using the ADO objects.

I am using the "MS Remote" OLE DB provider and have it pointed to a server that has RDS installed on it.

There are a couple of instances on this form where Ineed to refresh the dataset. I am not sure if this helps, but try to build your view with option WITHVIEW_METADATA, for example: CREATE VIEW All Customers WITH VIEW_METADATAAS SELECT * FROM dbo.

When I do so I get "insufficient key columninformation for updating or refreshing"If I set the dataset to active = false and turn it on again that works finebut I really don't want to do that. The final resultreturns columns that include the primary key of one of the base tables andthe rows that are returned are absolutley unique. Customers And then if you use INSTEAD-OF-Triggers together with your view you caneven directly insert/update/delete data.bye, Helmut wrote in message news:1qbv6ogxbbhjs.1eu057cuz26zy$***@40..

Search for delphi insufficient base table information for updating or refreshing:

delphi insufficient base table information for updating or refreshing-85

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “delphi insufficient base table information for updating or refreshing”

  1. Usually it’s a youngish, male, grad-school degree-holder who has a rather prestigious job which he assumes is his because of superior learning and rational thought.

  2. She instinctively turned around and tried to resist him as he began tearing off her dress and panties, but he smashed her lip with a powerful blow and forced his crying victim to swallow his thick cock and then spread her legs to let him penetrate into her tight slit.