Hello,
Can I somewhere find a descriptions about SQL errors?
For a moment I am trying to get form which is updating subform according entered form data.
I am getting an error:
SQL Status: 23000
Error code: -8
Integrity constraint violation SYS_FK_198 table: Brokas1 in statement [UPDATE "Gaminys" SET "Gaminys" = ? WHERE "Gaminys" = ?]
Sometimes it is difficult to found clear description about errors.
[Solved] SQL Errors
[Solved] SQL Errors
Last edited by minrub on Thu Sep 24, 2015 1:21 am, edited 1 time in total.
OpenOffice 5.2 on Windows 7
Re: Errors
"Integrity constraint" is a foreign key. You try to violate a foreign key, e.g. having a relation between invoices and clients you try to send an invoice to a client-ID that does not exist in the client table.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice