[DiscordArchive] <@200677690838220800> Thank you, I start to understand. Any idea where I could have a look in the
[DiscordArchive] <@200677690838220800> Thank you, I start to understand. Any idea where I could have a look in the
Archived author: bandysc • Posted: 2022-10-09T12:04:39.212000+00:00
Original source
The editors needs a way to uniquely identity the row, in order to properly support: undo/redo, save original values and more
Archived author: Krutok • Posted: 2022-10-09T12:05:27.044000+00:00
Original source
it's useful for editing existing entries, you just can't add anything
Archived author: Krutok • Posted: 2022-10-09T12:07:33.475000+00:00
Original source
you just have to remove the query that checks if there is a primary key for this table
Archived author: bandysc • Posted: 2022-10-09T12:08:25.011000+00:00
Original source
It will not solve the problem, without being able to uniquely identity a row, the editor can't function properly.
Archived author: Krutok • Posted: 2022-10-09T12:09:28.754000+00:00
Original source
phpmyadmin or other mysql database tools can do that too
Archived author: Tea • Posted: 2022-10-09T12:10:24.544000+00:00
Original source
these tools simply use all columns in WHERE when there is no PK
Archived author: Krutok • Posted: 2022-10-09T12:12:46.127000+00:00
Original source
And the editor can certainly also be programmed so that it does the same thing with the summon grpoups as other tools
Archived author: Krutok • Posted: 2022-10-09T12:13:29.914000+00:00
Original source
It will take a little effort, but it's definitely possible
Archived author: bandysc • Posted: 2022-10-09T12:13:43.791000+00:00
Original source
Yes and I certainly don't want to do this, because this can affect multiple rows, which is not only confusing for the user, but it is also confusing for detecting it in the editor
Archived author: bandysc • Posted: 2022-10-09T12:14:11.494000+00:00
Original source
The solution is to introduce a PK in the table ♂️