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.
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 list
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 eventlog
where
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
___
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,
, 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 = Select mydetails from mytable
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
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
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
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
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
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
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
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 ) 17::33:13
How
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, id;
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 ?
Am 26.06.2012 16:49, schrieb Richard Hipp:
On Tue, Jun 26, 2012 at 10:46 AM, deltagam...@gmx.net
deltagam...@gmx.netwrote:
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
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.netwrote:
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
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 because
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 ?
___
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'
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-- C/C
Am 22.06.2012 12:01, schrieb Richard Hipp:
On Fri, Jun 22, 2012 at 1:03 AM, deltagam...@gmx.net deltagam...@gmx.netwrote:
sqlite3_prepare_v2()
http://sqlite.org/c3ref/**prepare.htmlhttp://sqlite.org/c3ref/prepare.html,
sqlite3_step()
http://sqlite.org/c3ref/step.**htmlhttp://sqlite.org/c3ref
sqlite3_prepare_v2() http://sqlite.org/c3ref/prepare.html,
sqlite3_step() http://sqlite.org/c3ref/step.html, and
sqlite3_finalize() http://sqlite.org/c3ref/finalize.html,
From the documentation I saw, that sqlite3_exec includes
sqlite3_prepare_v2 , sqlite3_step, sqlite3_finalize.
But if the
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
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
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
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=VsZ5bUh0XAkCpg=PA222
How do I retrieve the number of records in a table ?
By running
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 a
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 char
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 insert_in_db(char const
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
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
33 matches
Mail list logo