I have a simple ADO Delphi app that reads one table record and splits it into two other tables. Then I get the following message: "Key column information in insufficient or incorrect.
Insufficient base table information for updating or refreshing??? Insufficient base table information for updating or refreshing 3.
The tables are as such; Appts Appts Index int NOT_NULL IDENTITY PRIMARY KEY .... Emp Appts Emp Appts Index int NOT_NULL IDENTITY PRIMARY KEY Appts Index int NOT_NULL The relationship I created was; Appts. This is the code for the stored procedure that gets called to supply the recordset.
CREATE PROCEDURE Single Resource Appt @starting Date datetime, @ending Date datetime, @res Index int AS SET NOCOUNT ON SELECT Appts.
Both tables have primary, table A has one field primary key, but table B has 4 fields composite key.
I only use table A to primary key to link primary B.
Insufficient base table information for updating or refreshing. Insufficient key column information for updating or refreshing 10.