On 11/26/2014 8:58 PM, Sam Carleton wrote:
The question is how to make the trigger work for both cases.
Experimentally, when EventNodeId is omitted from INSERT statement,
new.EventNodeId == -1 in the trigger. So I think something like this
INSERT INTO EventNode ( EventNodeId,
There are two different types of insert that need to happen into a table,
one is where the rowid (EventNodeId) is part of the actual insert, the
other it is excluded so that AUTOINCREMENT will fill it in. There is an
insert triggers to set the audit fields on the table during the insert.
I have rather a long answer for you. I'm not confused about the
difference between logical and physical types, but I am confused about
what you meant and what you're hoping to accomplish.
On Wed, 26 Nov 2014 03:22:03 -0800
Darko Volaric wrote:
> A 64 bit floating
Try? Don't use a network. It isn't safe due to file locking mechanisms
(As you've noted) at the server side, not the client side. The other
option is to either build a SQLite server where the local database store
is, or, get MySQL/MSSQL up and running.
a type column to go with variant data would probably be best... how many
columns do you have that are actually self-described type required?
could just serialize it to a blob; include type, and the value... kinda
hard to select for a value that way... at least if it's a parallel type the
I still get the crashes even after adding the pragma.
My connection string looks like:
public static string OMconnectionString = "URI=file:omm.db; PRAGMA busy_timeout
Is there anything else I can try?
On Wednesday, November 26, 2014 10:34 AM, Simon Slavin
"From the tone of your last post (if I am reading correctly) I understand
that you have your mind set on finding a way that you have thought about a
lot lying in your bed late at night, you have rolled it around in your head
and you just "feel" this should be doable and will be so
On 26 Nov 2014, at 4:20pm, Mike McWhinney wrote:
> Are there any other PRAGMA or connection string
> statements that can help with this concurrency issue?
If you haven't set a busy timeout then SQlite won't retry when there is a
network clash, it will immediately return
I am continuing to have sporadic problems with SQLite and a WinForms
application that I'm developing.
The program is a Winforms app using the System.Data.SQLite class. I am running
this off a network. There
are a small number of users which read and write to a database stored on a
On 2014/11/26 15:58, Darko Volaric wrote:
I'm not looking for confirmation of ideas, on the contrary, people seem to want to push their own ideas about a database should be
used and how I'm not using it correctly, when that is irrlevent to the issue I'm discussing. Maybe more focus on the
> Thanks for reporting this. I think it should be fixed here:
Thanks for the fix! I confirm it fixes the issue I saw.
sqlite-users mailing list
The person I replied to cross posted, not I, and I didn't realise this
before I replied to his cross post and the I couldn't change it then, so
maybe take that up with him.
I'm not confusing anything. You, and the other posters, are confusing the
representation of values and the concrete value
We observe very similar problem.
#1 0x087ec9f7 in sqlite3VXPrintf ()
#2 0x087f816d in sqlite3MPrintf ()
#3 0x088781e5 in sqlite3VtabFinishParse ()
#4 0x0885190f in yy_reduce ()
#5 0x0884d4d8 in sqlite3Parser ()
#6 0x087fc0ce in sqlite3RunParser ()
#7 0x088aa396 in sqlite3Prepare ()
Firstly, kindly keep this to the sqlite-users forum and not on the dev forum (the devs read this too, the difference being simply
that this one exists to help you, the other one is to discuss development stuff, not to help anyone).
Secondly, you are confusing two things. You are
That's not true. A 64 bit floating point number and an 64 bit integer can
be represented by the exact same 64 bit pattern, and no-one would suggest
they're the same value. You can have those two differently typed although
identical bit values in the same SQLite column. The data identifying the
Mail list logo