Empty rows on Select Part Number


	Applies To

	Product(s):	promis.e, Bentley Substation
	Version(s):	through 08.11.12.xx
	Environment:	N/A
	Area:	promis.e Functionality
	Subarea:	Design Features
	Original Author:	Matt_P, Bentley Technical Support Group

Problem Description

When trying to assign a part number to a symbol using the Select Part Number dialog, rows of empty cells appear in the top pane. Also, some part numbers known to match the applied filter may not appear, and double-clicking on a row causes the focus to jump to a different row or causes an unhandled exception.

Reason

This behavior can be caused by the presence of duplicate values in the Part_Number column in the table used for the parts database. This situation should be impossible since the Part_Number column should be the table's primary key, which requires unique values to be entered. In past cases, a different column or no column was found to be the primary key. In these cases, users had also been entering data using Microsoft Access instead of the Parts Database Manager.

Steps to Resolve

Open the parts database using Microsoft Access.
Use the Find Duplicates Query Wizard or other methods to identify duplicate part numbers in the parts_database table. See Find and remove duplicate data.
Edit or delete records so that no duplicates remain.
Set the Part_Number column to be the primary key. This can be done by opening the parts_database table in Design View, right clicking the Part_Number column, and choosing "Primary Key". This will prevent duplicate part numbers from being entered while using Microsoft Access to enter the data. Consider entering data using Parts Database Manager instead.
Save and close the database.

External Links

"Find and remove duplicate data"
http://office.microsoft.com/en-us/access-help/find-and-remove-duplicate-data-HA010341696.aspx

keywords: Object reference not set to an instance of an object, Bentley.Electrical.UI.PartsDatabase.DSelectPart.gridViewAbove_DoubleClick