Guriddo » Topic: How to delete row if composite primary key is used

How to delete row if composite primary key is used

Guriddo
How to delete row if composite primary key is used

This topic has 9 replies, 2 voices, and was last updated 15 years ago by OlegK.

Creator

Topic
May 11, 2011 at 11:53 pm #78359

kobruleht
Participant

Table contains composite primary key which are passed as _id1 , _id2
Creator

Topic

Viewing 9 replies - 1 through 9 (of 9 total)

Author

Replies
May 12, 2011 at 12:25 am #97964

OlegK
Participant

You have many possibilities to do this: serializeDelData, delData, onclickSubmit. The event handle serializeDelData

May 12, 2011 at 12:52 am #97966

kobruleht
Participant

As I wrote composite key components are text strings. They can contain any characters including spaces and _ characters. Due to jqGrid bug spaces and maybe some other characters are not allowed in ids.

May 12, 2011 at 10:41 am #97968

OlegK
Participant

First of all I suggesed you 4 implementation ways. If you have problem with one or another way you can use other ways. The way with serializeDelData

May 12, 2011 at 12:36 pm #97969

kobruleht
Participant

Will serializeDelData, delData work also in row edit mode ? They are documented in form editing chapter so I expected that they will not work in row editing mode.

URL limit may be too short so onClickSubmit cannot used. Db structure change requires lot of changes in existing application, it is too expensive.

So only way seems to use base64 to create id1_id2

May 12, 2011 at 12:54 pm #97970

OlegK
Participant

Hello Andrus,

I suppose that under row edit mode you mean inline editing mode. It has serializeRowData which lay the same role as serializeDelData for the form editing. If you use both editing modes together in the grid you can share the code of the function which implement seriaization in both cases.

I am sure, that if you use id which is several kilobytes long than you should make modification in your database model. The usage of such “key” is almost the same as to use the full row data. It will be slow and ineffective. The

May 12, 2011 at 1:15 pm #97971

kobruleht
Participant

This is dictionary table contianing different languages in columns. Primary key is phrase in source language. This table is used for translations. Surrogate id will be used then only by jqGrid.

I'm not sure that adding surrogate id to this table is reasonable for this.

Base64 encoding makes id too long and unreadable in packet dumps when debugging.

How to create encoder/decoder which masks only characters which are not allowed in jqGrid ids? Where to find list of such characters ? Are most unicode characters allowed in ids ? Should only spaces encoded or other characters also ?

May 12, 2011 at 2:15 pm #97973

OlegK
Participant

The dictionary tables use typically MD5 hash as the key insead of the full phrase in source language.

I don't understand how you implement packet dumps and why you have the requirements at all. The

May 15, 2011 at 12:59 pm #97994

kobruleht
Participant

I created method below to encode/decode jquery ids. This will also handle the case if id is empty. Will thoser methods encode all characters which are not alowed in jquery ids?

Is it resonable to use those methods instead on md5 or base64 ?

May 16, 2011 at 12:25 pm #98014

OlegK
Participant

I find encoding of large texts not the best way. With respect of Encoding.UTF8.GetBytes or Encoding.ASCII.GetBytes you can get byte representation of any string and with respect of MD5CryptoServiceProvider.ComputeHash you can calculate the MD5 from the bytes. Then you can convert the MD5 value to HEX or to Base64. In the database you can save the MD5 directly as binary and in HTML use the values converted to HEX or to Base64. So instead of the usage long (even encoded) texts as id you can use short values.

Regards
Oleg
Author

Replies