Inline editing doesn't work for primary keys which include spaces

[janmottl]

Inline editing doesn't work for primary keys which include spaces. In line editing is not displayed.

I have a primary key "OP žadatele o ÚL". It resulted into a snippet "snippet-acomplDatagrid-item-OP žadatele o ÚL" which was not processed successfully. I have to to create redundant alternative key.

[dakorpar]

First flaw I see here is that you should not really have such a primary key. IMHO your best solution for this is to add autoincrement id field in table as pk and set thisyour current pk field as unique if you need it unique. You could make up some virtual private key for table but this will allways cause issue since it's going to be hard to connect it with real row and you need to make sure it won't happen that two are same. I don't really see that datagrid should support this...

[janmottl]

Hi, thanks for your opinion. It's clear that alternative generated key solves described Datagrid problem and its limitations. I have described this workaround already in last sentence my first post.

There are only two requirements on primary key from data modeling point of view. It must be NOT NULL and UNIQUE. From data modeling point of view:

• there are no limitations on primary key content. Primary key can contain any character including space, tab, (,{,[ characters including diacritics etc.
• it is just normal to have a lookup table with primary key having more words including diacritics. Content is up to user.
• primary key can be modified by user. There are only limitations to keep foreign key constraint.
• primary key can be composed from more columns. That's usual in associative tables.

I recommend to extend documentation and describe Datagrid data model limitations:

• primary key must not contain white spaces and probably special characters. It's limitation of inline editing because primary key is used as identifier.
• it's prohibited to modify primary key. Inline editing doesn't identify source snippet in this case.
• primary key must contain just one database column. Primary key containing more columns are not supported

Its reccomended to have a numeric unique key containing one column. Add generated numeric alternative key if you have:

• non numeric primary key (VARCHAR, DATE etc)
• primary key containg more columns
• mutuable primary key That's a way how to prevent datagrid limitations.