Multi fields primary keys in database manager and editing data

OS info

Problem description

overwriting every line in database with the same data

Steps to reproduce

  1. change data in one colomn could only get the first line
  2. click save
  3. all posts will change to the same data as the first one. Just for that coloumn.

Debuging of sql call will be added soon.

the database viewer is not using primary key. So if the primary key has several columns thte database viewer isnot using them

Her is the SQL that ruined my database
update timeliste
set tid_inn = ‘2020-11-10 22:03:43’,
km_inn = 99999
where brsted = 1
it should have been
update timeliste
set tid_inn = ‘2020-11-10 22:03:43’,
km_inn = 99999
where brsted = 1
and kunde = 45
and id = 123

Community Page
Last updated: