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.
I haven't actually tried it, but just by inspection I would guess that a view
can't refer to another column within itself, so there are 2 options.
Create a second view on top of the first view. (I've not tested this - note how
the view name is aliased to just 'Patterns' because I'm
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
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
Mail list logo