Re: [sqlite] found a Malware , when download sqlite-shell-win32-x86-3071500.zip

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: > >

[sqlite] SQLite and Java - Trend Analysis and Graphing

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

Re: [sqlite] PERSIST Journal Mode

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

[sqlite] Entity Framework 6.0 alpha 2

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

Re: [sqlite] PERSIST Journal Mode

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

[sqlite] complex update

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

Re: [sqlite] complex update

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

Re: [sqlite] PERSIST Journal Mode

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"

[sqlite] multiple outstanding sqlite3_stmt objects

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

Re: [sqlite] multiple outstanding sqlite3_stmt objects

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

[sqlite] How to manage Table inside Table scenarios

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

Re: [sqlite] How to manage Table inside Table scenarios

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

Re: [sqlite] multiple outstanding sqlite3_stmt objects

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

Re: [sqlite] How to manage Table inside Table scenarios

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