Thank you very much, i was spending hours of trying to make it work and yes it 
works fine :)
Maby you could update your Documentation in the first lines of PRAGMA documents 
for such unknowldged like me :/
cause this PRAGMA is a bit confusing in some cases for newbies

Thank you in advance Simon

________________________________________
From: sqlite-users-bounces at mailinglists.sqlite.org <sqlite-users-bounces at 
mailinglists.sqlite.org> on behalf of Simon Slavin <slav...@bigfraud.org>
Sent: Thursday, February 25, 2016 2:34 AM
To: SQLite mailing list
Subject: Re: [sqlite] How to enabled PRAGMA options in c++ app ?

On 25 Feb 2016, at 12:01am, a a <NoCos30 at hotmail.com> wrote:

> PRAGMA secure_delete = true;

SQLite's PRAGMA commands should be executed as if they were SQL commands.  They 
are not C or C++ code.  In other words you can take whatever program structure 
you would use to execute

CREATE TABLE MyTable (a, b)

and use it for the PRAGMA command.  You'll probably do it using sqlite3_exec() 
but you may have other ideas.

By the way, since you wrote that you're new to C++ I warn you of a problem. 
Your project is a C++ project but you have included sqlite3.h and sqlite3.c, 
and they are C files.  So make sure that you have set them as C and not C++ in 
your project.  Depending on which compiler you use, if you don't do this you 
can run into compilation problems.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to