On 24 Feb 2016, at 3:28am, admin at shuling.net wrote: > Is that possible?
No. If you are going to make lots of changes to the table and rarely use SELECT, do the calculation in the SELECT command. If you are going to make few changes to the table but do lots of searching and sorting, create real F3 and F4 columns and do the calculation in your INSERT command. By the way, your questions suggest you're (A) a beginner with SQL and (B) very worried about optimizing your setup so that it runs quickly. This is common and you should not worry so much. SQLite is extremely fast. You can best spend your time creating simple software which is easy to program and easy to debug. Write the program. See how fast it does the things you need doing. Only if you find it is too slow should you worry about improving speed. Simon.
