Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

Hide Intro Register

Deleting directly in sql does not update related sum

Par

Marta

sur 21/06/2021 10:16 • 1 350 Vues

I have two tables that are related, one of which has a related sum over the other's data. I did the import of the table through excel but I put the wrong values, so directly in sql I deleted the table, but when I go to another table the related sum has values and does not update to 0 and when I go back to importing the other table it sums about that value. Is there a way to get around this without having to also delete the related sum value in sql?

Signaler

Répondre
Commentaires
Partager

Álvaro Damas

Activé 26/11/2021 12:11

Genio cannot be expected to recover from all situations where there is data handling directly in the persistent support. Mainly where relationships between tables are involved.

Be very careful when manipulating data directly in persistent support without involving the Genio API.
However, in this situation described, the Genio in a future version will have to correct the data, but always in a system maintenance mode.

Commentaires
Signaler

Ask a Question

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

41 follower(s)

Stats

Asked: 21/06/2021 10:16
Seen: 1350 times
Last updated: 26/11/2021 12:11