On two separate tables today I added some foreign key constraints to my SQL database, then I went to Data>Columns and initiated ‘Regenerate Structure’. Prior to the regenerate action I had a column set to ‘Enum’ type, after the regenerate completed Appsheet magically changed that Enum column to a decimal instead.
I was under the impression that Appsheet was supposed to retain the existing column structures after performing a regenerate. That is why I had previously posted this Question on the board
[Does Appsheet Sometimes Loose it's "Memory"](https://community.appsheet.com/t/does-appsheet-sometimes-loose-its-memory/35503/3) Questions
Hi @Markus_Malessa, so @MultiTech_Visions is a grizzled veteran of many AppSheet years, so he’s giving you pragmatic advice to workaround the occasional oddities of our platform. But as a part of the AppSheet dev team, I think every one of these things sounds like a bug. So my request is — please report it anytime something like this happens. If you have an app where there are two identical virtual columns and they produce different values, I’d love to see it. Because that sure isn’t what is su…
@praveen including you because of your response to that other question.