The SQLite3 wrapper class and the client class use std::wstring,
however, the wrapper performs the necessary conversion to
std::string::data(), before submitting the requests to SQLite3.
Nice of you to notice this provable cause.
Thanks so much for the help.
On 2017-09-21 5:37 PM, Keith
wapstr += L");";
this->sql_statement = this->wapstr;
db->createTable(this->sql_statement); // exception received here
wapstr.clear();
} catch (std::shared_ptr& e) {
throw e;
}
}
void jme::Person::WriteToDatabase(const std::ws
wapstr += L"email1 TEXT, ";
// Email2 data
wapstr += L"email2 TEXT";
wapstr += L");";
db->createTable(wapstr);
} catch (std::shared_ptr& e) {
throw e;
}
}
For the time being I'd like to leave the schema as it is,
void myClass::CreateTable() {
try {
// Name's data
wapstr = L"CREATE TABLE ";
wapstr += table_name;
wapstr += L"(";
wapstr += L"id INT PRIMARY KEY NOT NULL, ";
wapstr += L"title_name TEXT, ";
wapstr += L"first_name TEXT, ";
I think the problem with this function is my lack of good understanding
of the SQL.
What I intend to do is to write one int64_t to the database, but I don't
know how to write the proper sql statement, making sqlite3_prepare_v2
return a non SQLITE_OK value.
Any help is much appreciated.
void
Outch, that was not a very smart question, sorry folks for the maluse
(this is my own word, mal-use) of the bandwidth.
:-[
On 2017-09-12 9:11 AM, Richard Hipp wrote:
On 9/12/17, p...@arbolone.ca wrote:
I have a file named SQLite3.dll, but I don't know which sqlite version
I have a file named SQLite3.dll, but I don't know which sqlite version it is.
Any help on how to finding that out?TIA
ArbolOne.caUsing Fire Fox and Thunderbird.ArbolOne is composed of students and
volunteers dedicated to providing free services to charitable
organizations.ArbolOne on Java
Thanks Simon for the info.
I am new to NetBeans and I was having a little bit of problems setting
up the IDE, that's all.
On 2017-09-06 1:03 PM, Simon Slavin wrote:
On 6 Sep 2017, at 4:12pm, Papa <p...@arbolone.ca> wrote:
Are the SQLite3 DLLs, in the Precompiled Binaries for W
Are the SQLite3 DLLs, in the Precompiled Binaries for Windows,
compatible with MinGW-64?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Yes, what I do to check for the existance of a database is:
//This method will returns true if the table does not exit, false otherwise.
bool SQLite3_RDB::notExist(const std::wstring& table) {
// SQL statement
sql_statement_request = "SELECT * FROM " + table + " LIMIT 0";
// Feed
On Sep 1, 2017 2:23 PM, "Papa" <p...@arbolone.ca> wrote:
In this snip, I'd like to show a brief description of what the class member
function should do, in order to ask you if the SQL statement has been
properly prepared.
sqlite3* db; //!< Data Base
std::string
database_name.c_str(), //Database name
, //Database object
SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, //
NULL
);
On 2017-09-01 2:45 PM, Jens Alfke wrote:
On Sep 1, 2017, at 11:23 AM, Papa <p...@arbolone.ca> wrote:
I get an error indicating that bina
In this snip, I'd like to show a brief description of what the class
member function should do, in order to ask you if the SQL statement has
been properly prepared.
sqlite3* db; //!< Data Base
std::string database_name; //!< The name of the database
std::string
Thanks everyone for your input.
I am sorry, the error was cause by human error, i.e. my mistake :-P
On 2017-08-31 9:43 PM, Papa wrote:
This is not a SQLite3 problem, it shows to be a MinGW
(mingw32/7.1.0/...) -> Target: 64bit, however, I just wanted to know
if anyone here has experie
This is not a SQLite3 problem, it shows to be a MinGW
(mingw32/7.1.0/...) -> Target: 64bit, however, I just wanted to know if
anyone here has experience the same problem.
std::string sql_statement_request;
...
rc = sqlite3_prepare_v2(db,
sql_statement_request.data(),
:-) LOL, yes, that is the gift from MS to the world, LOL.
On 2017-08-28 2:20 PM, John McKown wrote:
On Mon, Aug 28, 2017 at 1:11 PM, Papa <p...@arbolone.ca> wrote:
Thanks everyone.
The problem was resolved by rebooting the computer, strange ain't it?
Ah, yes, the main "soluti
Thanks everyone.
The problem was resolved by rebooting the computer, strange ain't it?
On 2017-08-27 10:55 AM, Tim Streater wrote:
On 27 Aug 2017, at 15:35, Papa <p...@arbolone.ca> wrote:
First and foremost, I'd like to thank everybody for your replies.
Although I have sound kno
the advice given by you all, so, please, using the code I have
provided in the OP, how can I implement your advice?
Again, thanks ya'll for all the help.
On 2017-08-26 11:28 PM, Simon Slavin wrote:
On 27 Aug 2017, at 2:34am, Papa <p...@arbolone.ca> wrote:
Why do I get this error message
class SQLite3_RDB {
private:
sqlite3* db; //!< Data Base
std::string database_name;
public:
SQLite3_RDB();
~SQLite3_RDB(){sqlite3_close(db); }
};
SQLite3_RDB::SQLite3_RDB(){
databese_name.assign("information.sql3db");
rc =
In my C++ program, I'd like to display the SQLite3 version. To do so,
this is what I have done.
class SQLite3_RDB {
private:
sqlite3* db; //!< Data Base
std::string tmp;
public:
SQLite3_RDB(){}
~SQLite3_RDB(){sqlite3_close(db); }
const std::string&
Would someone please tell me if the following can be done with SQLite?
There's a database file on a SMB share.
Multiple nodes (different boxes) use it.
There is a special node, master, that's the only one that updates certain -cfg-
table. When it updates cfg, all the other nodes currently using
21 matches
Mail list logo