Re: [sqlite] Can it (should it) be done in SQL?

2020-01-20 Thread Keith Medcalf
On Monday, 20 January, 2020 12:42, David Bicking wrote: > Thanks. I figured the solution would use CTE (this is a CTE, isn't it??) >Unfortunately, they were neither in Sqlite, nor mentioned in any of the >sql stuff I read when I taught myself to do SQL.so it took me a while to >figure out how it

Re: [sqlite] Can it (should it) be done in SQL?

2020-01-20 Thread David Bicking
, 18 January, 2020 11:20 >To: SQLite Mailing List >Subject: [sqlite] Can it (should it) be done in SQL? > >I suspect the answer is that it is best to do this in the application >program. However, the platform I want to use is dumb as a brick. >It basically can call sqlite3_get_table,

Re: [sqlite] Can it (should it) be done in SQL?

2020-01-18 Thread Keith Medcalf
0 11:20 >To: SQLite Mailing List >Subject: [sqlite] Can it (should it) be done in SQL? > >I suspect the answer is that it is best to do this in the application >program. However, the platform I want to use is dumb as a brick. >It basically can call sqlite3_get_table, mildly refo

Re: [sqlite] Can it (should it) be done in SQL?

2020-01-18 Thread Keith Medcalf
-users On >Behalf Of David Bicking >Sent: Saturday, 18 January, 2020 11:20 >To: SQLite Mailing List >Subject: [sqlite] Can it (should it) be done in SQL? > >I suspect the answer is that it is best to do this in the application >program. However, the platform I want to use is dum

[sqlite] Can it (should it) be done in SQL?

2020-01-18 Thread David Bicking
I suspect the answer is that it is best to do this in the application program. However, the platform I want to use is dumb as a brick. It basically can call sqlite3_get_table, mildly reformat the data and send it to the display. Anyway, there are two tables CREATE TABLE Goals (period integer pr