Re: [sqlite] How to make this calculation in VIEW

Thank you, Simon and Owen. I have tried and both solutions work equally well.  I have actually used C code to make the calculation as I pull out the data. But to help further my understanding of SQL/SQLite, can anyone comment on potential performance differences of the 2 SQL solutions. CREATE V

Re: [sqlite] How to make this calculation in VIEW

Owen -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jeff Archer Sent: Wednesday, November 17, 2010 10:14 PM To: SQLite-user.org Subject: [sqlite] How to make this calculation in VIEW First let me say thank you to all for the

Re: [sqlite] How to make this calculation in VIEW

On 17 November 2010 22:13, Jeff Archer wrote: > First let me say thank you to all for the very good support that receive here. > > I have the these tables and view > . . . > > I would like to add these calculated columns to my view but not sure how to > make > this work. > >    Patterns.wMicr

[sqlite] How to make this calculation in VIEW

First let me say thank you to all for the very good support that receive here. I have the these tables and view // Patterns table CREATE TABLE IF NOT EXISTS [Patterns] ( PatternID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Name  VARCHAR NOT NULL UNIQUE, Description   VARCHAR NOT NULL