Re: [sqlite] Percentile function in SQLite 3.8.0 (for the .NETversion)

Hayden Livingston wrote: > > Ok great. Do you know if the 1.0.90.0 will be out anytime soon? That is, > this month or so ...? > The approximate date for the next release is normally available on the System.Data.SQLite web site:

Re: [sqlite] Percentile function in SQLite 3.8.0 (for the .NET version)

Yeah they were going to the spam folder! Thanks. I've got a few suggestions to work through. I'm going to wait a bit for the PERCENTILE function already present in future SQLite releases for .NET If it takes a while to get released, I might venture into this! On Mon, Dec 2, 2013 at 9:35 AM,

Re: [sqlite] Percentile function in SQLite 3.8.0 (for the .NET version)

Ok great. Do you know if the 1.0.90.0 will be out anytime soon? That is, this month or so ...? On Mon, Dec 2, 2013 at 11:54 AM, Joe Mistachkin wrote: > > Hayden Livingston wrote: > > > > (A) How do I create a Percentile Query? > > > > First, the percentile extension

Re: [sqlite] VB.net project using Windows CE and SQLite on a handheldPsion terminal

J Trahair wrote: > > 1. Error 5 Reference required to assembly 'System.Data, Version=2.0.0.0, > Culture=neutral, PublicKeyToken=b77a5c561934e089' containing the base > class 'System.Data.Common.DbConnection'. Add one to your project. C:\My > Documents\Psion\PTMPsion\Tickets.vb 7112 24

Re: [sqlite] SQLite ver: 1.0.89 issue

Nikola Boyadjiev wrote: > > Out App was working file until we changed the version to 1.0.89 and then we > started having weird behavior. We checked the database and out code for couple > of days trying to find where the problem is. We ran integrity check on the > database and its fine. I'm

Re: [sqlite] Percentile function in SQLite 3.8.0 (for the .NET version)

Hayden Livingston wrote: > > (A) How do I create a Percentile Query? > First, the percentile extension function needs to be loaded into SQLite, either statically or dynamically, as described here: https://www.sqlite.org/loadext.html The necessary source code can be found in the repository,

Re: [sqlite] Percentile function in SQLite 3.8.0 (for the .NET version)

There have been a few responses to your question, I count at least 3 from different people all with working suggestions. Are you sure you are getting the list emails? Maybe check spam folders etc. Or are you unsatisfied with the responses? On 2013/12/02 19:30, Hayden Livingston wrote: Is

[sqlite] Percentile function in SQLite 3.8.0 (for the .NET version)

Is there any documentation or use case for percentile queries? I've only seen the source code checked in by "drh". Is it like the EXCEL 2013 function? I have a table {operationId, latency) with a set of rows that have floating values for latencies of a given operation. I want to find the 25th

[sqlite] SQLite ver: 1.0.89 issue

Hello, Sorry, I should have checked about sending files first.. Here is a link to the files: https://drive.google.com/file/d/0B9OOxcfUpwq2SWlkMmFTSUtFN2M/edit?usp=sharing Out App was working file until we changed the version to 1.0.89 and then we started having weird behavior. We

Re: [sqlite] SQLite ver: 1.0.89 issue

On Mon, 2 Dec 2013 13:56:33 +0200 (EET), Nikola Boyadjiev wrote: > > Hello, > I'm very sorry, the files did not attach to the previous e-mail i sent, I > will attach them to this one. > Hope this doesn't cause any issues.. > Thanks, > Nikola The list doesn't

Re: [sqlite] SQLite ver: 1.0.89 issue

On 2 Dec 2013, at 11:56am, Nikola Boyadjiev wrote: > I'm very sorry, the files did not attach to the previous e-mail i sent Sorry, you cannot attach files to posts to this forum. We don't want everyone sending us their homework. First execute the SELECT in the SQLite

Re: [sqlite] SQLite ver: 1.0.89 issue

This list does not allow attachments - Could you upload them to a file-host site somewhere and paste the links kindly? Thanks, Ryan On 2013/12/02 13:56, Nikola Boyadjiev wrote: Hello, I'm very sorry, the files did not attach to the previous e-mail i sent, I will attach them to

[sqlite] VB.net project using Windows CE and SQLite on a handheld Psion terminal

Hi Everyone I am using VS2008 to put a VB.Net application onto a Psion handheld, WindowsCE. In the development mode there are 3 errors which prevent the project from compiling. They seem to be in connection with the System.Data.dll which is the version referenced in the C:\Program

[sqlite] SQLite ver: 1.0.89 issue

Hello, We just updated System.Data.SQLite to ver 1.0.89 and we started to have issues with some of our queries. We cannot locate the issue, so I'm attaching the database and a query so it can be recreated. In the Query: 1. we select Products from [Products] table, we join

[sqlite] SQLite ver: 1.0.89 issue

Hello, I'm very sorry, the files did not attach to the previous e-mail i sent, I will attach them to this one. Hope this doesn't cause any issues.. Thanks, Nikola ___ sqlite-users mailing list sqlite-users@sqlite.org