Re: [sqlite] Can't seem to create DB with unvacuumed data [ for testing ]

On Fri, 11 Oct 2013 23:15:24 -0500 Drake Wilson wrote: > Quoth Paul L Daniels , on 2013-10-12 > 13:57:00 +1000: > > I've tried the pragma autovacuum=0 and journalling set to none to > > no avail. Every time I exit from the command line SQlite3

Re: [sqlite] Can't seem to create DB with unvacuumed data [ for testing ]

Quoth Paul L Daniels , on 2013-10-12 13:57:00 +1000: > I've tried the pragma autovacuum=0 and journalling set to none to no > avail. Every time I exit from the command line SQlite3 tool I find > that the data I explicitly deleted has genuinely been removed. > > Any

[sqlite] Can't seem to create DB with unvacuumed data [ for testing ]

I'm trying to create a sqlite3 db with unvacuumed data in it so I can verify the functionality of my SQLite deleted data recovery tool "Undark", but would you believe, other than the iPhone databases that I've pulled from my phones I cannot seem to create a DB that has persistent deleted rows in

Re: [sqlite] SQLite with Windows Phone 8

Did you add the Community.CsharpSqlite.WinPhone.dll as a dependency to your project? On Fri, Oct 11, 2013 at 5:09 AM, Tola Fasoyiro wrote: > > I am attempting to use SQLite with Windows Phone. I have successfully > installed SQLite for Windows and sqlite-net. I get

Re: [sqlite] Segmentation Fault With Trigger

It is giving same trace what i have sent last time. It is possible by some one to send test code snapshot of scenario of selecting user defined function while trigger execution. Thanks a lot... On Fri, Oct 11, 2013 at 7:41 PM, Richard Hipp wrote: > On Fri, Oct 11, 2013 at

Re: [sqlite] Segmentation Fault With Trigger

Data Info is not an problem.I am passing data information for building query before passing to sqlite exec function.If i remove trigger for insert then my code is working perfectly fine. My assumption is it is due to selecting function during trigger.Please suggest hint by looking sequence

Re: [sqlite] Inserting or replacing in the same db based on one key

"James K. Lowden" wrote... On Thu, 10 Oct 2013 12:29:21 -0400 "jose isaias cabrera" wrote: > INSERT INTO SimplePrices > SELECT cust || '1', class, slang, tlang, TransferCost, Price > FROM SimplePrices WHERE cust = 'XEROX'; > > Kudos for the primary key declaration,

Re: [sqlite] Segmentation Fault With Trigger

On Fri, Oct 11, 2013 at 4:06 PM, techi eth wrote: > > #4 0x778e1127 in SqliteTestInsert (SQLitePrivate=0x602300, > > TableName_p=0x4019a0 "dbTestTbl", DataInfoList=0x4) > There's the problem: DataInfoList is an invalid pointer. i have no idea what that is, but it's

Re: [sqlite] Segmentation Fault With Trigger

On Fri, Oct 11, 2013 at 10:06 AM, techi eth wrote: > Please provide some hint. > Recompile with -O0 and -g and then post the stack trace after the segfault. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Segmentation Fault With Trigger

Please provide some hint.I have added some more details about function definition & query. /* Create function definition */ static void Test(sqlite3_context *context, int argc, sqlite3_value **argv) { printf ("Trigger Function Called\n"); if (argc == 1) { char *text =

Re: [sqlite] Segmentation Fault With Trigger

Please find below : #0 0x7fffe0b8 in ?? () #1 0x776988f6 in ?? () from /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 #2 0x7769e451 in sqlite3_step () from /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 #3 0x776a1e4c in sqlite3_exec () from

Re: [sqlite] SQLite DateTime issue

On 11 Oct 2013, at 4:05am, tpalumbo wrote: > Have a strange issue. Creating a Windows Phone 8 app, (c#, xaml), using > SQLite. I have a simple table that has 3 fields defined in database as > follows > RecordID (int) > Name (nvarchar) > RecordDate (DateTime) > > In the in

Re: [sqlite] sqlite3_blob_open issue

On Fri, Oct 11, 2013 at 3:02 AM, Deepika Sathawane < deepika.sathaw...@igate.com> wrote: > > As per the help the database name is not the filename that contains the > database but rather the symbolic name of the database that appears after > the AS keyword when the database is connected using

[sqlite] SQLite with Windows Phone 8

I am attempting to use SQLite with Windows Phone. I have successfully installed SQLite for Windows and sqlite-net. I get an error in SQLite.cs as follows: type or namespace "Community" could not be found #if USE_CSHARP_SQLITE using Sqlite3 = Community.CsharpSqlite.Sqlite3; using

Re: [sqlite] Bug report.

On Fri, Oct 11, 2013 at 7:57 AM, Alexander Syvak wrote: > Hello, > > I am using the @ as a column name delimeter. For instance, if there's a > table named woman, then a column describing the size of hips should be > named woman@hip_size. > > There's a table created using

Re: [sqlite] Segmentation Fault With Trigger

On Fri, Oct 11, 2013 at 7:57 AM, techi eth wrote: > Hi, > > I am getting segmentation fault while executing query in sqlite3. [Linux > OS]. > Can you send us a stack trace? > > Find below sequence. > > // Getting SQLiteHandler > > OpenConnection (); > > //Creating user

[sqlite] Bug report.

Hello, I am using the @ as a column name delimeter. For instance, if there's a table named woman, then a column describing the size of hips should be named woman@hip_size. There's a table created using CREATE TABLE country ( 'country@id' INTEGER, 'country@name' TEXT,

[sqlite] sqlite3_blob_open issue

Hi, I am facing issues while reading the data from blob column. I am not able to open the blob. I am using sqlite3_blob_open function. Can someone provide the sample code for the same. int sqlite3_blob_open( sqlite3*, const char *zDb, const char *zTable, const char *zColumn,

[sqlite] SQLite DateTime issue

Hi All, Have a strange issue. Creating a Windows Phone 8 app, (c#, xaml), using SQLite. I have a simple table that has 3 fields defined in database as follows RecordID (int) Name (nvarchar) RecordDate (DateTime) In the in the app the model is defined the same. The table does have 5 records in

[sqlite] pragma foreign_keys;

Hello, there's a need to make delete on cascade, update on cascade work. I am using the next code for a test => int main() { sql_q_raw_ptr = "pragma foreign_keys = 1;"; mms::db db_; db_.open(path); db_.insert(sql_q_raw_ptr); sql_q_raw_ptr = "pragma foreign_keys;"; auto

[sqlite] Segmentation Fault With Trigger

Hi, I am getting segmentation fault while executing query in sqlite3. [Linux OS]. Find below sequence. // Getting SQLiteHandler OpenConnection (); //Creating user defined function “Test” sqlite3_create_function(SQLiteHandler, "Test",1, SQLITE_UTF8, NULL, , NULL, NULL) //Creating table,Below

Re: [sqlite] Consistent reads

On 10/11/2013 02:29 PM, Paul Harris wrote: Hi again, I am wondering if there is any performance benefit in *not* wrapping multiple SELECT calls in a BEGIN/END transaction? As I understand it, with wrapping: BEGIN -- does nothing (yet) SELECT1 -- creates a SHARE-ONLY lock on the DB SELECT2 --

[sqlite] Consistent reads

Hi again, I am wondering if there is any performance benefit in *not* wrapping multiple SELECT calls in a BEGIN/END transaction? As I understand it, with wrapping: BEGIN -- does nothing (yet) SELECT1 -- creates a SHARE-ONLY lock on the DB SELECT2 -- nothing extra SELECT3 -- nothing extra END --