Primary Key Restrictions

[Patrick Hampton]

I was wondering if there are restrictions on what values are valid when being used as a primary key?

I have a grid that is bound to a sql datasource that lists documents and details about those documents. I use the document name as the primary key, and it appears that when I have certain special characters (such as +, %, and ;) in the document name, I can not select that document in the grid. To complicate things further if the top most document in the list contains one of these characters the grid goes into an infinate loop trying to select the first document on the page load. Has anyone seen this before or have any thoughts on how to get around this? I do not have access to restrict what these documents are named before they are saved to the database.

[Administrator]

Hi Patrick, Here is a sample, which shows the primary column with special characters ( +, % , ; ) and selection of data’s goes fine. Please modify the sample reproduce the issue here. Sample : GGC_PrimaryColumn Best regards, Madhan