On 30 May 2015, at 1:26am, Etienne Charland wrote:
> there are requests that are very long because they return a grid where each
> column must be calculated individually, and this crashes with "stack overflow
> error". These queries run fast on a SQL Server database -- and not at all
> with
On 30 May 2015, at 4:48am, Etienne Charland wrote:
> I think I found where the problem is coming from. I did an automated database
> conversion from SQL Server. Most primary keys are GUIDs. In SQLite, these
> columns are still defined as 'uniqueidentifier' which is not a valid data
> type.
Thanks! If I change the column type from UNIQUEIDENTIFIER to TEXT, it works.
Only thing is, the code then maps to String instead of Guid. Is there any way
to keep the .NET code working with Guid classes?
I'm also seeing that BIT data type isn't supported and should be replaced by
INT. However,
Greetings!
I've been experiencing SEGV's from the Sqlite Tcl extension. I
originally started to receive some time ago when Arch Linux upgraded to
Tcl 8.6. Reverting back just Tcl to 8.5 made the dumps go away. I
proceeded to exclude Tcl from updating until Arch "self-destructed" for
me on an
As an update, replacing Guid with String in the database and code worked. I got
everything to work except the "parser stack overflow" error. The application is
much snappier than when running with a SQL Server LocalDB database.
Is there any way to solve this parser error?
One work-around could
On 30 May 2015, at 7:07pm, Etienne Charland wrote:
>
> As an update, replacing Guid with String in the database and code worked. I
> got everything to work except the "parser stack overflow" error. The
> application is much snappier than when running with a SQL Server LocalDB
> database.
The version of SQLite I'm using is the NuGet package System.Data.SQLite
(x86/x64) v1.0.97.0
I tried loading the data in several queries with a cache, but performance was
worse and it added several problems, such as the inability to sort using these
calculated columns! That's not an option. I
On 30-5-2015 02:53, Etienne Charland wrote:
> I'm using SQLiteStudio.
>
> It's not easy to run it manually because of how the parameters must be
> passed, and the function that doesn't exist within the database.
>
> I tried replacing all parameters by their value, and replacing the function
>
Thing is, I have no control over how the query gets generated. Each subquery
(or project) is calculating one of 9 columns.
If you want to try running the query, here's the database
https://www.spiritualselftransformation.com/misc/NaturalGroundingVideos.zip
Here's the query
On 30 May 2015, at 9:41pm, Samuel Tebeka wrote:
> This is the official doc:
>
> 1.Process A starts a read transaction on the database and does one or
> more SELECT statement. Process A keeps the transaction open.
> 2.Process B updates the database, changing values previous read by
>
On 30 May 2015, at 9:59pm, Samuel Tebeka wrote:
> I'm doing a BEGIN EXCLUSIVE before every write statement already, should I
> do it for read steatements as well?
It's worth a try. I'm not sure what's wrong here, I'm just hoping we find a
way to change what's happening enough to figure out a
Etienne Charland wrote:
>
> SQLite error (1): no such function: Substring
> -- Failed in 89 ms with error: SQL logic error or missing database
> no such function: Substring
>
Thanks for the example. This is now fixed on trunk, here:
Hello 'General,
Used to be I could go to the download page:
http://www.sqlite.org/download.html
Click a link then download a zip file with the current version.
What I see now is:
Build Product Names
...followed by some text.
Source Code Repositories
...with links to other pages that
Yep, You will need to download the version best suited for your version
of .NET. If you have a current version of Visual Studio, then I'd use
NuGet to install the correct version and the associated libraries along
with the correct interop dlls
--
Jeff K. Steinkamp (N7YG)
Tucson, AZ
Scud
> From: sqlite at mistachkin.com
> To: sqlite-users at mailinglists.sqlite.org
> Date: Sat, 30 May 2015 14:40:52 -0700
> Subject: Re: [sqlite] String.Substring Generates Error
>
>
> Etienne Charland wrote:
> >
> > SQLite error (1): no such function: Substring
> > -- Failed in 89 ms with error:
Something JUST changed within the last 60 seconds. I saw what the OP said,
but, it reverted back to the list of download links. Weird.
On Sat, May 30, 2015 at 8:44 PM, Jeff Steinkamp wrote:
> Yep, You will need to download the version best suited for your version
> of .NET. If you have a
I am running into an issue with SQLite that I think might be a bug. When I
run the PRAGMA table_info
17 matches
Mail list logo