[sqlite] Adobe Air do not include on sqlite database

My app Adobe Air try to save some data in a sqlite 3 database, but the app when insert a data, it does without problem, but i cant see the data when browse by the lita or sqlite browser. It look like empty table. select * from table <- adobe air return ok insert into table (values...) <- adobe

[sqlite] Problem with SQLiteCommand.Parameters and CurrentCulture

Hi Look at example from attachement, please. In test InsertDoubleByCommandWithParam you could see problem with storing double by command with parameter. We use Flags=BindAndGetAllAsText. It works: command.CommandText = "INSERT INTO EntA (Id, EntityProperty1, DoubleProperty) VALUES (1,

Re: [sqlite] Adobe Air do not include on sqlite database

On Thu, Jan 2, 2014 at 11:29 PM, Digradi Socobaris wrote: > My app Adobe Air try to save some data in a sqlite 3 database, but the app > when insert a data, it does without problem, but i cant see the data when > browse by the lita or sqlite browser. It look like empty

[sqlite] sqlite3_preupdate functions

Hello, I am using the sqlite3_session module amalgamated into the main sqlite3.c file (3.8.2). I defined both: #define SQLITE_ENABLE_SESSION 1 #define SQLITE_ENABLE_PREUPDATE_HOOK1 but compiler is not able to find all the sqlite3_preupdate* functions. I am missing something? --

Re: [sqlite] sqlite3_preupdate functions

The standard pre-built amalgamation won't work with sessions. You have to pull source code from the "sessions" branch: http://www.sqlite.org/src/timeline?r=sessions On Fri, Jan 3, 2014 at 9:50 AM, Marco Bambini wrote: > Hello, > I am using the sqlite3_session module

[sqlite] Apply a changeset

Documentation is not very clear about this point… in order to apply a change set starting from a session should just I write something like: int rc= sqlite3session_changeset(session, , ); rc = sqlite3changeset_apply (db, pnChangeset, ppChangeset, NULL, NULL, NULL); Is that all? -- Marco Bambini

Re: [sqlite] Apply a changeset

On 01/03/2014 10:54 PM, Marco Bambini wrote: Documentation is not very clear about this point… in order to apply a change set starting from a session should just I write something like: int rc= sqlite3session_changeset(session, , ); rc = sqlite3changeset_apply (db, pnChangeset, ppChangeset,

Re: [sqlite] Problem with SQLiteCommand.Parameters and CurrentCulture

Marcin Szotka wrote: > > In my opinion command parameters should use InvariantCulture when > converting types to string. > Support for doing this (via new connection flags) has now been implemented on trunk, here: https://system.data.sqlite.org/index.html/info/f2f08c2ab7 -- Joe

Re: [sqlite] Adobe Air do not include on sqlite database

If this is on Windows, the UAC might virtualize your file to a different folder so that Adobe Air actually sees a different file. Try to not store DB files inside \program-files\ or other system-folders. The actual file might be typically somewhere inside: