Re: [sqlite] SQL to SQLite

2019-12-03 Thread Keith Medcalf
On Tuesday, 3 December, 2019 05:39, gideo...@lutzvillevineyards.com wrote: >My query is : >UPDATE wbridge_history >SET yearclass = >( >SELECT D.wynklas >FROM >( >SELECT LidNo, PlaasNo, BlokNo, oesjaar, wynklas, >ROW_NUMBER() OVER (PARTITION BY LidNo, PlaasNo, BlokNo, oesjaar ORDER BY >COUNT(*) D

Re: [sqlite] SQL to SQLite

2019-12-03 Thread Warren Young
On Dec 3, 2019, at 5:38 AM, gideo...@lutzvillevineyards.com wrote: > > The squigly red line starts at (PARTITION .. PARTITION BY is a valid SQLite window function: https://www.sqlite.org/windowfunctions.html#the_partition_by_clause but that feature is only about a year old in SQLite:

[sqlite] SQL to SQLite

2019-12-03 Thread gideon.e
Hi Simon My query is : UPDATE wbridge_history SET yearclass = ( SELECT D.wynklas FROM ( SELECT LidNo, PlaasNo, BlokNo, oesjaar, wynklas, ROW_NUMBER() OVER (PARTITION BY LidNo, PlaasNo, BlokNo, oesjaar ORDER BY COUNT(*) DESC, SUM(ton) DESC) AS row_num FROM wbridge_history GROUP

Re: [sqlite] SQL to SQLIte

2019-12-02 Thread Warren Young
On Dec 2, 2019, at 11:22 AM, Simon Slavin wrote: > > Please post again, this time with the query. The table schema might also help: sqlite> .schema TableName ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.s

Re: [sqlite] SQL to SQLIte

2019-12-02 Thread Simon Slavin
On 2 Dec 2019, at 5:52pm, wrote: > I am having extreme difficulty to convert the above SQL query to SQLite. Please post again, this time with the query. Note that this mailing list strips attachments, so paste the query into your message. ___ sqlit

[sqlite] SQL to SQLIte

2019-12-02 Thread gideon.e
I am having extreme difficulty to convert the above SQL query to SQLite. Can someone please help me. I need to udate the table using the most used text In a column for each row that has the same data. Regards ___ sqlite-users mailing list sqli

Re: [sqlite] SQL to SQLite

2016-07-21 Thread Robby Helperin
Thanks, Dana. Yes, that's vb.net. -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of dmp Sent: Thursday, July 21, 2016 11:58 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] S

Re: [sqlite] SQL to SQLite

2016-07-21 Thread dmp
> Thanks Dana, > I think you're talking about doing what I did, but I'm not 100% sure. > Below is my solution. Could you let me know if yours is the same or > something more elegant? Hello, I'm not sure of the programming language, VBasic, ?, but generally looking through it looks like essenti

Re: [sqlite] SQL to SQLite

2016-07-21 Thread Tim Streater
On 20 Jul 2016 at 23:14, Robby Helperin wrote: > Thanks, Simon, this looks promising! > > Is this something that can be done programmatically in code (vb.net) or only > from the command prompt? > > If programmatically, could you shoot me a quick syntax example? Here's an example of what I do in

Re: [sqlite] SQL to SQLite

2016-07-21 Thread Robby Helperin
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, July 20, 2016 6:46 AM To: SQLite mailing list Subject: Re: [sqlite] SQL to SQLite On 20 Jul 2016, at 12:21am, Robby Helperin wrote: > Any SQLite string is going to refer to just one database, so you ca

Re: [sqlite] SQL to SQLite

2016-07-21 Thread Robby Helperin
command.ExecuteNonQuery() dbConnection.Close() Catch ex As Exception If ex.Message = "constraint failed" & vbCrLf & "UNIQUE constraint failed: SongVersionsTEST.SongVerID" Then Debug.WriteLine("T

Re: [sqlite] SQL to SQLite

2016-07-20 Thread R.A. Nagy
n Behalf Of R.A. > Nagy > Sent: Wednesday, July 20, 2016 7:25 AM > To: SQLite mailing list > Subject: Re: [sqlite] SQL to SQLite > > There are several ways to work with other databases. From the SQLite, we > can > always attach another file so as to work with > 1 databas

Re: [sqlite] SQL to SQLite

2016-07-20 Thread Robby Helperin
te.org] On Behalf Of R.A. Nagy Sent: Wednesday, July 20, 2016 7:25 AM To: SQLite mailing list Subject: Re: [sqlite] SQL to SQLite There are several ways to work with other databases. From the SQLite, we can always attach another file so as to work with > 1 database file at a time. >From a progr

Re: [sqlite] SQL to SQLite

2016-07-20 Thread dmp
> Message: 2 > Date: Tue, 19 Jul 2016 15:01:55 -0700 > From: > To: > Subject: [sqlite] SQL to SQLite > Message-ID: <004d01d1e209$2a356360$7ea02a20$@spotlightmusic.com> > Content-Type: text/plain; charset="us-ascii" > > What's the best way

Re: [sqlite] SQL to SQLite

2016-07-20 Thread R.A. Nagy
users-boun...@mailinglists.sqlite.org] On Behalf Of R.A. > Nagy > Sent: Tuesday, July 19, 2016 3:32 PM > To: SQLite mailing list > Subject: Re: [sqlite] SQL to SQLite > > Surely the best way to routinely & autocratically copy a set of data from > one database to another SQ

Re: [sqlite] SQL to SQLite

2016-07-20 Thread Simon Slavin
On 20 Jul 2016, at 12:21am, Robby Helperin wrote: > Any SQLite string is going to refer to just one database, so you can't write > an INSERT command that will take from one database and write to another, or > can you? How would this normally done? See the ATTACH command:

Re: [sqlite] SQL to SQLite

2016-07-20 Thread Robby Helperin
16 3:32 PM To: SQLite mailing list Subject: Re: [sqlite] SQL to SQLite Surely the best way to routinely & autocratically copy a set of data from one database to another SQL technology would be to use a programming language - like Java, C/C++, C#, or Python for example - so as to copy data between

Re: [sqlite] SQL to SQLite

2016-07-19 Thread Hick Gunter
6 00:02 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] SQL to SQLite What's the best way to Insert or Update records from a connected SQL database to the connected SQLite database? I don't mean just once, but to do every so often. Thanks. ___

Re: [sqlite] SQL to SQLite

2016-07-19 Thread R.A. Nagy
Surely the best way to routinely & autocratically copy a set of data from one database to another SQL technology would be to use a programming language - like Java, C/C++, C#, or Python for example - so as to copy data between two different database connections. The only other way would be to crea

[sqlite] SQL to SQLite

2016-07-19 Thread tmp11
What's the best way to Insert or Update records from a connected SQL database to the connected SQLite database? I don't mean just once, but to do every so often. Thanks. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://ma