Re: [sqlite] Table question

What you envisage was realized by the Pick database system from the 1970s. It had a "dictionary" to each table, and virtual fields could be defined in the dictionary as expressions. With SQL you might find that VIEWs and user defined functions might adapt to your application. JS Eugen Stoia

Re: [sqlite] Table question

My ideea was to create some database structure where some tables would store the real data (the actual values of the columns) and some other tables that have the values i need to work with calculated based upon the data stored in the first tables. Triggers seem the way to go, but i was wonderin

Re: [sqlite] Table question

Eugen Stoianovici wrote: Is there a way o creating tables that have fields that are expressions rather than values? Those expresions would return a value based on values stored in other fields of some other table (or the same table if that's necessary). If the expressions do not vary per row,

Re: [sqlite] Table question

Eugen Stoianovici a écrit : Is there a way o creating tables that have fields that are expressions rather than values? Those expresions would return a value based on values stored in other fields of some other table (or the same table if that's necessary). Hi, i think the best way to do that