SQLite Forum

Serious problems with STORED columns
Login
> But a STORED column can never be restored!!!

Yes, and a letter knife can never fly a plane. So?

You need a screw-driver, but you insist on using a hammer and then complain of the fact that the hammer cannot undo a screw for you.

If you want persistent data, please use a persistent column. ANY form of Calculated column, with "STORED" privileges or otherwise, isn't persistent storage and never will be.

Why the insistence on using the wrong tool for the job? Change that column to a persistent storage column and all your troubles will go away.

We have a saying in my country: "If a monkey wore a golden ring, it still remains an ugly thing."

Just because a hammer can also make a screw go into a block of wood, doesn't make it a screwdriver - as will become painfully clear when you try to undo that screw.  
Similarly, just because your calculated column also stores it's data (given some givens) like the big-boy real columns, doesn't make it a big-boy real column.

Your need is for a real column, not a calculated column. And if you think the "calculated" part of the column brought you some advantage that you do not have with a real column, please state that clearly, and someone here will show you how to make that happen with your real column.