Norman asked 10 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 10 years ago
Hi,
delete also no go…
this seems like composite primary key column name problem.
Abu Ghufran answered 10 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
