Skip to main content
C
carlosp5114
September 1, 2023
Question

Problem deleting records with a read-only grid

  • September 1, 2023
  • 4 replies
  • 0 views

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
    stefanhelzle0001
    Brainy
    September 1, 2023

    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.

    C
    carlosp5114Author
    September 1, 2023

    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
    stefanhelzle0001
    Brainy
    September 1, 2023

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

    Terms & ConditionsAccessibility statement