Yes, I downloaded the amalgamation and included it into my project. Since it is an embedded system with a not out of the box supported operating system, I wrote my own vfs. Insert, select, delete operations properly work on a database and as desired.
I've changed the stmt to "SELECT 'Hello World !!';" In this case, sqlite3_step() returns SQLITE_ROW sqlite3_column_text() returns 'Hello World !!' That, looks right. Unfortunately, I can't run the shell tool on the es and try the same sequence of cammands. If you think that there's something wrong with the compilation process, should then also standard SQL instructions do not work? -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Freitag, 17. April 2015 12:34 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On 17 Apr 2015, at 11:12am, Janke, Julian <julian.janke at capgemini.com> wrote: > I changed my code again: Move the DROP TABLE command on line 5 to after the _finalize() call. But I don't think it'll make any difference. You should not be getting SQLITE_DONE back from your call to _step(). The documentation says that that PRAGMA command should return a row of data. Please try changing the PRAMGA command to sqlite3_prepare_v2(db, "SELECT 'Hello World !!';", 24, &stmt, NULL); and see what you get back from it. > It looks as if all PRAGMA instructions are completely ignored, since > the query for the status of the JOURNAL_MODE returns no result. > > Is it possible that I have turned off PRAMAs by anything or something is > missing, so PRAMAs can run? No. I'm coming to the conclusion that there's something wrong with your compilation process. How are you getting your sqlite3 library ? Have you downloaded the amalgamation source code and included it in your project ? If not, please try doing this. Can you download the sqlite3 shell tool and try the same sequence of commands ? You can find it here: <https://www.sqlite.org/download.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ________________________________ Firma: Capgemini Deutschland GmbH Aufsichtsratsvorsitzender: Antonio Schnieder ? Gesch?ftsf?hrer: Dr. Michael Schulte (Sprecher) ? Jost F?rster ? Dr. Peter Lempp ? Dr. Volkmar Varnhagen Amtsgericht Berlin-Charlottenburg, HRB 98814 This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.