Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Web Development
Expertise: Beginner
Oct 22, 1999

Insufficient Key Field Information Error With RDS

Question:

I am using the Dataspace and DataControl objects to interact with a database through Internet Explorer 4 using form elements. The data displays perfectly when I use this query:

SELECT Employee.*, Courses.* 
FROM Course INNER JOIN Employee ON Employee.courseid=Course.courseid 
WHERE Employee.id IN (" & strEmployeeList & ")

When I edit the one field that is bound to a form element and initiate:

ADF.SubmitChanges dsn=idp2.mdb",ADC.Recordset

I get an error:

'Insufficient key field information for updating or refreshing.'

Answer:

Your database needs a unique, primary key that will be used to identify the record that is to be updated. The message that you mentioned appears when no unique key for the update field can be identified. Ensure that the recordset that you are working with contains a single, unique primary key and that the primary key and the field you are updating originate from the same table.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date