Guillaume Saumure wrote:
I have to create a small program to track changes done on multiple
machines. The data structure look like :
Structure Notice
PrimaryKeyID.l
Type.l
Date.l
ExecutedBy.s
RequestedBy.s
Description.s
EndStructure
Structure Machine
PrimaryK
On 19 Dec 2012, at 1:21am, Larry Brasfield wrote:
> Is there any reason not to do this?
Don't do it if one statement is a SELECT and another statement interferes with
the normal way that _step() would step through the results. Although the API
will not immediately return an error when you do
If you're talking about multiple Notices for each Machine, then your schema
would be something like this:
create table Machine
( ID integer primary key not null
, Name text
, Location text
)
;
create table Notice
( ID integer primary key not null
, Machine integer no
Hello everyone,
I have to create a small program to track changes done on multiple
machines. The data structure look like :
Structure Notice
PrimaryKeyID.l
Type.l
Date.l
ExecutedBy.s
RequestedBy.s
Description.s
EndStructure
Structure Machine
PrimaryKeyID.l
Name
On 12/18/2012 8:21 PM, Larry Brasfield wrote:
At http://www.sqlite.org/c3ref/stmt.html , there is a weak implication
that SQLite may expect single sqlite3_stmt objects to exist for a
connection.
Not sure what led you to believe this. You definitely may have multiple
prepared statements on one
At http://www.sqlite.org/c3ref/stmt.html , there is a weak implication
that SQLite may expect single sqlite3_stmt objects to exist for a
connection. The pattern I intend to follow instead of the one shown as
"life of a statement object goes something like this" is:
1. Create sqlite3_stmt #1
2.
I believe only WAL mode is sticky.
Not using the pragma seems to generate deletions as normal.
The missing data was from after the file was closed. I am still looking into
rollback, but why would journal mode matter?
Marc
On Dec 18, 2012, at 12:02 PM, "Simon Slavin" wrote:
>
> On 18 Dec 2
On 12/18/2012 12:27 PM, Adam DeVita wrote:
There is a table products where has a location id. Unfortunately
duplicate dictionary names got added to list of locations
products haslocationid and a bunch of other stuff
I can easily get the max (bad) and min (good) location ids
associated wi
Good day,
I'm attempting to fix some bad data:
There is a table products where has a location id. Unfortunately
duplicate dictionary names got added to list of locations
products haslocationid and a bunch of other stuff
I can easily get the max (bad) and min (good) location ids
associate
On 18 Dec 2012, at 3:04pm, Marc L. Allen wrote:
> I also have no additional information as to why having PERSIST mode on
> prevents the database from being updated/correct. I did check the
> sqlite3_close command, and I'm passing it the connection received from
> sqlite3_open. It returns SQ
There is an open source version of entity framework version (EF, version 6.0).
I want to try it out with mono to see how it works but sadly I have this
ADO.netprovider problem here (sqlite 1.0.82.0). I get the following error with
the new EF 6.0:
No Entity Framework provider found for 'Syste
Some additional information.
It appears that setting the journal_mode is not inherited by DBs that are
attached after the PRAGMA journal_mode is executed. So, I added one after the
ATTACH.
It also appears that, as part of the PRAGMA journal_mode execution, the current
journal file is deleted.
Hi,
I am developing a client-only android app using the standard Android SDK
and SQLite. I would like to perform trend analysis (line graphs, pie charts
etc) on the data inputed by the user in the database, is it possible to do
this without building my own content provider? The inputs would be
oh,sorry, i hate 360safe.
在 2012-12-18 下午3:44,"Roy Tam" 写道:
> Hello,
>
> 2012/12/18 Miles Liu :
> > sqlite-shell-win32-x86-3071500
> > when download it , anti-virus said found a Malware.
>
> False positive. VirusTotal report here:
>
> https://www.virustotal.com/file/85fa29a391d7ab8af4736dfd36222a
14 matches
Mail list logo