Skip to main content
Known Participant
Sep 1, 2023 7:49 AM UTC
Question

Problem deleting records with a read-only grid

Hi! I have a site page created from a record list (invoices)

When I click in one of the Invoices Id, I access to a summary view (interface), in which I created not only additional information of the record "invoices", but also a read-only grid from another record (Invoice Lines).

My problem here is that, if I try to eliminate the record (related record action) from this interface, it does not occur anything and the following error appears

I suppose it is caused because of the read-only grid generated in the interface (if I add no editable grid, it works fine). How can I solve this and being able to delete the invoices with the read-only grid inside?

    4 replies

    stefanhelzle0001
    Brainy
    Sep 1, 2023 7:59 AM UTC

    That error message has nothing to do with any UI. It is the database trying to convince you that there is a foreign key constraint being violated.

    Known Participant
    Sep 1, 2023 8:08 AM UTC

    I suppose the error occurs in the process model "Delete Invoice". Anyway, the fact is that the process is failing so I cannot delete my invoice rows directly

    How can I afford this?

    stefanhelzle0001
    Brainy
    Sep 1, 2023 8:11 AM UTC

    I cannot really help you with that. You need to analyse the tables, foreign keys and constraints in the cloud database.