using composite key as ID error when update in mssql

Questionsusing composite key as ID error when update in mssql
Norman asked 7 years ago

Hi,

i'm using composite key for the mssql database.
unfortunately it error when i'm updating database. while others are ok like insert,delete or list grid.

thx

2 Answers
Norman answered 7 years ago

Hi,

delete also no go…
this seems like composite primary key column name problem.

Abu Ghufran answered 7 years ago

When using composite keys, you need to consider few points:

In your SELECT statement (select_command), you may try to select a first column as special concat value that is based on composite keys. This will handle the listings as first column data must be unique.

For insert/update/delete, you will need to use custom events on_update/on_insert/on_delete to parse the posted id and perform desired operation. Refer demos/editing/custom-events.php for help.

Your Answer

7 + 13 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?