Re: [sqlite] SQL to SQLite

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

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

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

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

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

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

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

> 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

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

[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

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

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

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

> 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

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

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

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

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

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

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