Unable to get record: XXX.  The record ID is not unique.

Problem

You get this error when running your application:

Unable to get record: ‘XXX’.  The record ID is not unique.

The primary key value used to fetch a record is not unique and multiple records would be fetched.  This commonly occurs when primary key values are passed into Edit Record or Show Record pages.

Solution

Define a unique primary key for your database table or database view within your database.  Alternately, use the Virtual Primary Key facility in Iron Speed Designer to define a unique primary key for your database table or database view.