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 tool I
> > find that the data I explicitly deleted
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 suggestions?
PRAGMA secure_del
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 it
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 an error in SQLite.cs
> as fo
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 10:06 AM, techi eth
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 provid
"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, btw. :-)
Thanks for the k
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 not part of sqlite3's
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
sqlite-users@sqlite.org
http
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 = sqlite3_value
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
/usr/lib/x86_64-linux-gnu/li
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 the app the model is
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 ATTA
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 Sqlite3Datab
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
> CREATE TABLE country
> (
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 defined function “Test”
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,
'country@printabl
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,
sqlite3_in
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 i
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 se
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, &Test,
NULL, NULL)
//Creating table,B
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 -- no
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 -- c
23 matches
Mail list logo
