Integrity constraint violation - no parent SYS_FK_194 table: Student

[latoureiffel44]

I am trying to update a database with SQL code that I have used many times:

UPDATE "Student" SET "Current Class" = "Current Class"+1 WHERE "Termination Date" IS NULL AND "Repetition" = FALSE

This code was working just a couple days ago. It's supposed to update all the students to the next class according to certain parameters. When I try to run the code now I get this error:

Integrity constraint violation - no parent SYS_FK_194 table: Student

I have tried running the code on previous versions of the same database but still get similar errors.
I updated to the most recent version of LibreOffice and am running version 24.8.4.2 on Windows 11 operating system.

Thank you for the help!

[UnklDonald418]

Perhaps one of the fields in table: Student contains an incorrect value, possibly a link to a record in another table but that record doesn't exist.
Open table: Student in the Edit Mode
From the menu select Tools>Indexes
Select SYS_FK_194
That should give you a hint as to which field contains for the problematic value.

[latoureiffel44]

Thank you so much. Yes, there is no SYS_FK_194. Only SYS_FK_195 which is the primary key. How can i fix this?

[UnklDonald418]

The error message indicates that SYS_FK_194 exists somewhere in your database. If not in the Students table then check your other tables in the same manner.
I'm not sure how much further help we can provide without a sample of your database
How to attach a document here

[Villeroy]

Code: Select all

UPDATE "Student" SET "Current Class" = "Current Class"+1 WHERE "Termination Date" IS NULL AND "Repetition" = FALSE

"Current Class"+1 has no such entry in the table of classes.