Re: [sqlite] SELECT question (computing day of week the usingstrftime() function)

> I need to find out how many specific weekdays (e.g., how many > Sundays) I have in any given range of dates. > My problem: How to use the COUNT function in combination with > the strftime() function. > Maybe something like sqlite3 test.db SQLite version 3.6.23 sqlite> CREATE TABLE test (date

Re: [sqlite] sqlite update with joins

> But it is ambigous ... It is not ambiguous when you know how SQL works and it's the only standard way of doing such things. Pavel On Sat, May 1, 2010 at 1:31 PM, wrote: > Yes that works. > But it is ambigous ... > > -Ursprüngliche Nachricht- > Von: Igor Tandetnik

Re: [sqlite] SELECT question (computing day of week the using strftime() function)

>I need to find out how many specific weekdays (e.g., how many Sundays) >I have in any given range of dates. >My problem: How to use the COUNT function in combination with the >strftime() function. > >$ sqlite3 test.db3 >SQLite version 3.6.20 >sqlite> create table test (date VARCHAR(20), money

[sqlite] SELECT question (computing day of week the using strftime() function)

Dear List Members, I do need your wisdom and experience. Thank you very much for sharing these with me ! I have a table into which I import data records from an external source. These imported data records are all containing a date field. I can change the field definitions in this table

Re: [sqlite] scripting language interpreter

On Sat, May 1, 2010 at 12:15 PM, Richard Hipp wrote: > On Sat, May 1, 2010 at 9:25 AM, Tim Romano wrote: > >> I am aware that SQLite supports >> loadable extensions, but would the SQLite architecture also permit the >> integration of an interpreted

Re: [sqlite] sqlite update with joins

Yes that works. But it is ambigous ... -Ursprüngliche Nachricht- Von: Igor Tandetnik Gesendet: 01.05.2010 16:00:01 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] sqlite update with joins wdl...@web.de wrote: > The general problem with this issue is that it is not

[sqlite] Modeling SQLite databases

Hi folks, Any one know if there is any open source software for modeling SQLite databases just like "SQLite Maestro "? P.S. Currently I'm using "SQLite Studio " it's nice editor but it doesn't support

Re: [sqlite] scripting language interpreter

On Sat, May 1, 2010 at 9:25 AM, Tim Romano wrote: > I am aware that SQLite supports > loadable extensions, but would the SQLite architecture also permit the > integration of an interpreted scripting language? An integrated scripting > language makes an already powerful

Re: [sqlite] scripting language interpreter

On Sat, May 01, 2010 at 09:25:54AM -0400, Tim Romano scratched on the wall: > In part, this is a very broad question but I hope it's not unacceptable. > From a birdseye perspective, what is involved in integrating an interpreted > scripting language with a database engine? A number of people

Re: [sqlite] scripting language interpreter

On Sat, May 1, 2010 at 9:53 AM, Tim Romano wrote: > Simon, > > It's not clear to me how this is a result of scripting language support: > > "Another problem with it is that sooner or later you need your inner > language (your SQL engine) to have access to your outer

Re: [sqlite] scripting language interpreter

Simon, It's not clear to me how this is a result of scripting language support: "Another problem with it is that sooner or later you need your inner language (your SQL engine) to have access to your outer environment, for example, to find out if you have lots of filespace free." Could you

Re: [sqlite] scripting language interpreter

On 1 May 2010, at 2:25pm, Tim Romano wrote: > In part, this is a very broad question but I hope it's not unacceptable. > From a birdseye perspective, what is involved in integrating an interpreted > scripting language with a database engine? I am aware that SQLite supports > loadable

Re: [sqlite] sqlite update with joins

wdl...@web.de wrote: > The general problem with this issue is that it is not possible > > to set an alias for the table in an update statement. > That should be implemented because otherwise some necessary statements are > not possible. > > e.g. > > update T x > set x.col1 = ( select sum(c)

[sqlite] scripting language interpreter

In part, this is a very broad question but I hope it's not unacceptable. >From a birdseye perspective, what is involved in integrating an interpreted scripting language with a database engine? I am aware that SQLite supports loadable extensions, but would the SQLite architecture also permit the

Re: [sqlite] sqlite update with joins

cant you do something like this? update tTmp set tTmp.fileName = hTmp.fileName from t tTmp inner join h hTmp on t.id = h.id 1 maj 2010 kl. 14.20 skrev wdl...@web.de: > The general problem with this issue is that it is not possible > > to set an alias for the table in an update statement. >

Re: [sqlite] sqlite update with joins

The general problem with this issue is that it is not possible to set an alias for the table in an update statement. That should be implemented because otherwise some necessary statements are not possible. e.g. update T x set x.col1 = ( select sum(c) from T y where y.id = x.id ) Table T