#>"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
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 of
"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 that way (to either use one
or
Ratchford
Sent: 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
#>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
#>"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 the DIRECTION
ginal 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
"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
> the DIRECTION results. Once t
Rick
#>-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...
#>
#>
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
anyt
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 da
#>
#>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
#>
#>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 ha
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 a
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 b.row
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 to
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)
Wes
#>-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...
#>
#>Rick Ratch
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 ordering. Do you have some ki
19 matches
Mail list logo