[sqlite] Working with blob

What is a convenient way to store the path from a external blob (jpg, pdf) ? How can I retrieve this blob ? Is there a Frontend which opens the jpg directly from the listed table-content ? If I store the blob directly in the sqlite, is there a way to open the blob directly with the respective

[sqlite] newest 3 entries

I have a select statement like: "Select id, eventdate, eventtype, FROM eventlog WHERE eventtype in ('special') " Now I like to receive only the newest 3 entries in the table eventlog where the eventtype is 'special' ___ sqlite-users mailing

Re: [sqlite] newest 3 entries

Am 08.11.2012 21:17, schrieb Igor Tandetnik: On 11/8/2012 3:10 PM, deltagam...@gmx.net wrote: I have a select statement like: "Select id, eventdate, eventtype, FROM eventlog WHERE eventtype in ('special') " Now I like to receive only the newest 3 entries in the table even

Re: [sqlite] SQLite Input with validation and lookup

Am 16.08.2013 17:47, schrieb Kai Peters: Stephen, you might want to look at http://dabodev.com/ Among other DBs it does support Sqlite and is fully cross-platform Cheers, Kai Hello Stephen, maybe another alternative is, to run FoxPro on a linux machine with the windows emulator wine.

[sqlite] How to use variables in statements ?

Im using c++ and like to write from within c++ into sqlite3 db. I saw some tutorials on the sqlite pages, but the statements have always been defined in advance and they have been constant. How to add now new data to sqlite if you dont know in advance the data ? I think the statement has to be

[sqlite] How to save images in sqlite3

Hello, is it possible to save images or pdf in sqlite ? Is it possible to just save the path to an image/ binary object an sqlite gets the object then at runtime ? thx in advance ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Insert and select date and time

In the GUI I have an calendar element. Later in the GUI the date-boundaries should be choosen with the calendar element, to show the report only for this timeframe. In a "report window" date and time are 2 different columns. The data itself is determined from another c++ programm and written in

[sqlite] insert in db

I defined in main() my char intype[]="chattinges"; and call the insert_in_db with insert_in_db(intype, 7); but in the db is written only chat instead of chattings. Where is the problem ? void insert_in_db(char const *eventtype, int zaehler) { int rc; char *exec_errmsg; const

Re: [sqlite] insert in db

On Mon, Jun 18, 2012 at 4:26 PM, deltagam...@gmx.net <deltagam...@gmx.net> wrote: I defined in main() my char intype[]="chattinges"; and call the insert_in_db with insert_in_db(intype, 7); but in the db is written only chat instead of chattings. Where is the problem ? void i

[sqlite] How to select from table

Hello, how can i select from sqlite3 db ? How do I retrieve the number of records in a table ? Thx in advance ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to select from table

Am 20.06.2012 12:02, schrieb deltagam...@gmx.net: Hello, how can i select from sqlite3 db ? How do I retrieve the number of records in a table ? Thx in advance Sorry forgot to tell, I'm using the c++ API ___ sqlite-users mailing list sqlite-users

[sqlite] Problem with select

Hello, I have a problem with the selection of the row, errorcode 21 s Indeed I would like to retrieve all rows, but as far as I understand it, this construction will retrieve only the last row/insert. What happens if the db is closed after the insert and reopened then for the

Re: [sqlite] How to select from table

Am 20.06.2012 14:55, schrieb Igor Tandetnik: deltagam...@gmx.net wrote: how can i select from sqlite3 db ? By executing a SELECT statement, of course. See this example: http://books.google.com/books?id=VsZ5bUh0XAkC=PA222 How do I retrieve the number of records in a table ? By running

[sqlite] Does sqlite3_exec work with sqlite3_bind ?

sqlite3_prepare_v2() , sqlite3_step() , and sqlite3_finalize() , From the documentation I saw, that sqlite3_exec "includes" sqlite3_prepare_v2 , sqlite3_step, sqlite3_finalize. But

Re: [sqlite] Does sqlite3_exec work with sqlite3_bind ?

Am 22.06.2012 12:01, schrieb Richard Hipp: On Fri, Jun 22, 2012 at 1:03 AM, deltagam...@gmx.net <deltagam...@gmx.net>wrote: sqlite3_prepare_v2() <http://sqlite.org/c3ref/**prepare.html<http://sqlite.org/c3ref/prepare.html>>, sqlite3_step() <http://sqlite.org/c

[sqlite] Problem with including sqlite3.c into c++ project

Hello, Im using MSVS 2010 for an c++ GUI project. After including sqlite3.h and sqlite3.c from the amalgamation-3071200 and with the Project Properties--> C/C++ --> Precompiled Headers --> Precompiled Header --> Use (/Yu) I get the error sqlite3.c : fatal error C1853: 'Debug\Contegos_UI.pch'

Re: [sqlite] Problem with including sqlite3.c into c++ project

Am 25.06.2012 22:18, schrieb John Drescher: On Mon, Jun 25, 2012 at 4:15 PM, deltagam...@gmx.net <deltagam...@gmx.net> wrote: Hello, Im using MSVS 2010 for an c++ GUI project. After including sqlite3.h and sqlite3.c from the amalgamation-3071200 and with the Project Properties-

[sqlite] How to retrieve number of records

I want to retrieve the number of records in a table, but dont know how to get access to the result of " select count(*) from tablename " #include "db_functions.h" //using namespace std; void select_count( ) { int rc, i, ncols,

[sqlite] access from 2 different programms to same sqlite3-db

I have a c++ GUI application from where the db is read and the content is displayed in a Clistbox. Then I try to delete some rows from the sqlite3-db from the console. After rereading from within the GUI the deleted rows are still there. How is this possible ?

Re: [sqlite] access from 2 different programms to same sqlite3-db

Am 26.06.2012 16:49, schrieb Richard Hipp: On Tue, Jun 26, 2012 at 10:46 AM, deltagam...@gmx.net <deltagam...@gmx.net>wrote: I have a c++ GUI application from where the db is read and the content is displayed in a Clistbox. Then I try to delete some rows from the sqlite3-db from the c

Re: [sqlite] access from 2 different programms to same sqlite3-db

AM, deltagam...@gmx.net <deltagam...@gmx.net> wrote: Am 26.06.2012 16:49, schrieb Richard Hipp: On Tue, Jun 26, 2012 at 10:46 AM, deltagam...@gmx.net <deltagam...@gmx.net>wrote: I have a c++ GUI application from where the db is read and the content is displayed in a Clistbox

Re: [sqlite] access from 2 different programms to same sqlite3-db

Am 26.06.2012 18:00, schrieb Pavel Ivanov: On Tue, Jun 26, 2012 at 11:50 AM, deltagam...@gmx.net <deltagam...@gmx.net> wrote: Am 26.06.2012 17:08, schrieb Pavel Ivanov: You are leaking stmt statement (re-preparing without finaliznig) and your call to sqlite3_close returns SQLITE_ERROR b

[sqlite] convert CString for statement

Hello I have as input parameter CString likeexp but I think in the following statement likeexp hast to be char [] rc = sqlite3_bind_text(stmt, 1, likeexp, strlen(likeexp), NULL); How can i convert likeexp to fit the above statement ? ___

[sqlite] sqlite time is 2 hours to late

Hello, >sqlite3 event.db "select datetime('now')"; gives me a time that is 2 hours too late ( 2012-06-27 15:33:13) than my system time ( win 7 ) 17::33:13 How can this be fixed ? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite time is 2 hours to late

Am 27.06.2012 17:40, schrieb Jay A. Kreibich: On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on the wall: Hello, sqlite3 event.db "select datetime('now')"; gives me a time that is 2 hours too late ( 2012-06-27 15:33:13) than my system time ( win 7 )

[sqlite] database busy error

If I have a pool of external (c++) progs, all writing into the same sqlit3 db, how do i handle this correctly ? Now, sometimes I get db busy error (5) ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] max size of a TEXT field

Hello, I couldnt find in the documentation what the max size of TEXT field/column is. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] using SQLITE_BUSY

In http://ideone.com/7lhIh is my example code. I would like to know if this would be an appropiate implemetation/use of BEGIN IMMEDIATE and sqlite3_busy_timeout. As I understood from the documentation and literature about Transaction and locks the sqlite3_step is the action state part so I

[sqlite] using the SQLITE_BUSY and BEGIN IMMEDIATE

In http://ideone.com/eWPWD is my example code. I would like to know if this would be an appropiate implemetation/use of BEGIN IMMEDIATE and sqlite3_busy_timeout. As I understood from the documentation and literature about Transaction and locks the sqlite3_step is the action state part so I

[sqlite] Selecting NULL

Hello, how to process if the select-statement selects a column with NULL ? == char *mydetails; char *sql; sqlite3_stmt *stmt; sqlite3 *db; const char dbname[] = "mysqlite.db"; sql = "Select mydetails from mytable"; rc = sqlite3_prepare(db, sql,

Re: [sqlite] Selecting NULL

, deltagam...@gmx.net <deltagam...@gmx.net> wrote: Hello, how to process if the select-statement selects a column with NULL ? == char *mydetails; char *sql; sqlite3_stmt *stmt; sqlite3 *db; const char dbname[] = "mysqlite.db"; sql = "

[sqlite] how many rows deleted

Can I retrieve how many rows are affected from a delete statement like std::string delete_stmt("DELETE FROM mylog WHERE strftime('%Y-%m-%d',thedate) BETWEEN ? AND ? "); ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how many rows deleted

Am 12.07.2012 01:36, schrieb Igor Tandetnik: On 7/11/2012 7:21 PM, deltagam...@gmx.net wrote: Can I retrieve how many rows are affected from a delete statement sqlite3_changes Thx Igor ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Concurrency and sqlite4

Hello, will there be some improvement regarding concurrency in the new sqlite4 ? Sqlite3 fits quite good to my needs, only the concurrency causes some problems, so I am eager to know about improvements in this area. Thx for your efforts ___