Re: [sqlite] Is it Possible in SQL...

#>"Simple" is relative - as you write yourself - your App #>already performs faster using SQL for the right things - and #>that don't have to be only "simple queries" - what you #>already do with all these nice Group By queries - directly #>delivering weekly or monthly stock-data, derived from

Re: [sqlite] Is it Possible in SQL...

On 11 Jul 2009, at 2:39am, Rick Ratchford wrote: > When I read Simon's reply, I did not get the sense that he was > suggesting I > do a Rs-Loop. It appeared to me, and I could be mistaken of course, > that he > was referring to pure programming in by language (VB). The people on this list

Re: [sqlite] Is it Possible in SQL...

"Rick Ratchford" schrieb im Newsbeitrag news:152a3111f1ab4a9891b9158580cb7...@dolphin... > Maybe I misunderstood, but the impression I got was > that I should solve this problem using my VB language > rather than dealing with the DB. I don't understand Simons reply

Re: [sqlite] Is it Possible in SQL...

: sexta-feira, 10 de julho de 2009 23:10 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Is it Possible in SQL... #>I was trying to figuring out if you are doing something of #>graph data analysis, I do it almost everyday in our Stock #>Trader applications... #>

Re: [sqlite] Is it Possible in SQL...

#>I was trying to figuring out if you are doing something of #>graph data analysis, I do it almost everyday in our Stock #>Trader applications... #>I never did this way (direct SQL), cause our graph series #>data sources are implement throught a common interface, that #>could be a SQL query, a

Re: [sqlite] Is it Possible in SQL...

#>"Rick Ratchford" schrieb im #>Newsbeitrag news:c9ce387e92004e7b9c16ddaa2bd36...@dolphin... #> #>> So modifying TmpTable, which will still be needed for other #>> procedures, is not preferred. It would be great if a #>recordset could #>> be derived from it instead

Re: [sqlite] Is it Possible in SQL...

Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rick Ratchford Sent: sexta-feira, 10 de julho de 2009 17:32 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Is it Possible in SQL... Seems there was a question in your reply I

Re: [sqlite] Is it Possible in SQL...

"Rick Ratchford" schrieb im Newsbeitrag news:c9ce387e92004e7b9c16ddaa2bd36...@dolphin... > So modifying TmpTable, which will still be needed for > other procedures, is not preferred. It would be great if > a recordset could be derived from it instead that contains >

Re: [sqlite] Is it Possible in SQL...

#>-Original Message- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin #>Sent: Friday, July 10, 2009 7:41 PM #>To: General Discussion of SQLite Database #>Subject: Re: [sqlite] Is it Possible in SQL... #> #> #>

Re: [sqlite] Is it Possible in SQL...

On 10 Jul 2009, at 11:36pm, Rick Ratchford wrote: > I understand what you're saying Simon. Sorry, Rick. I didn't mean to rail on you personally. Your post happened to be the one that triggered me to post the rant. I understand your reasoning and don't think you personally have done

Re: [sqlite] Is it Possible in SQL...

On Fri, Jul 10, 2009 at 10:15:03PM +0100, Simon Slavin scratched on the wall: > > I don't understand why people keep trying to do these things inside > SQL when they're obviously ysing a programming language anyway. Why wouldn't you? The data is in a database. SQL is how you manipulate

Re: [sqlite] Is it Possible in SQL...

#> #>This will create another table TmpTable (tax, direction), #>using the values from the table MarketTable: #> #>create table TmpTable as #>select tax, #>(select #> case when b.tax < MarketTable .tax #> then "Up" #> when b.tax>=MarketTable .tax #> then "Down" #> else null #> end #>

Re: [sqlite] Is it Possible in SQL...

#>On 10 Jul 2009, at 9:31pm, Rick Ratchford wrote: #> #>> After examining the above, it appears that what this does is modify #>> the table itself. So I suppose then that it is not possible #>to create #>> a recordset instead that meets what I'm trying to do. If #>this is the #>> case, I'll

Re: [sqlite] Is it Possible in SQL...

On 10 Jul 2009, at 9:31pm, Rick Ratchford wrote: > After examining the above, it appears that what this does is modify > the > table itself. So I suppose then that it is not possible to create a > recordset instead that meets what I'm trying to do. If this is the > case, > I'll have to make

Re: [sqlite] Is it Possible in SQL...

This will create another table TmpTable (tax, direction), using the values from the table MarketTable: create table TmpTable as select tax, (select case when b.tax < MarketTable .tax then "Up" when b.tax>=MarketTable .tax then "Down" else null end from MarketTable b where

Re: [sqlite] Is it Possible in SQL...

Seems there was a question in your reply I didn't catch the first time. > #>What do you mean by "previous one"? Records in a table don't #>have any implicit ordering. Do you have some kind of a #>timestamp field that imposes the order? The table, each time, has been in order from oldest Date

Re: [sqlite] Is it Possible in SQL...

If you want to use the rowid to order the rows (or an auto-incrementing primary key field), you could do something like this: update tst set Direction= (select case when b.tax < tst.tax then "Up" when b.tax>=tst.tax then "Down" else null end from tst b where b.rowid=tst.rowid-1)

Re: [sqlite] Is it Possible in SQL...

#>-Original Message- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik #>Sent: Friday, July 10, 2009 2:50 PM #>To: sqlite-users@sqlite.org #>Subject: Re: [sqlite] Is it Possible in SQL... #>

Re: [sqlite] Is it Possible in SQL...

Rick Ratchford wrote: > Is it possible, using SQL, to do comparisions across records? > > Suppose that you had 1 field called TAX and you wanted to compare > each one to the previous one. What do you mean by "previous one"? Records in a table don't have any implicit