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 Medca
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::wstr
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
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, ";
wapstr
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 wr
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 it
is. Any help on
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 Develo
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 wrote:
Are the SQLite3 DLLs, in the Precompiled Binaries for Windows, compatible with
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 the
On Sep 1, 2017 2:23 PM, "Papa" 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; //!< Th
database_name.c_str(), //Database name
&db, //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 wrote:
I get an error indicating that binary_sql_
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 sql_statement_request;
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 experience
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 wrote:
Thanks everyone.
The problem was resolved by rebooting the computer, strange ain't it?
Ah, yes, the main "solution" to most W
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 wrote:
First and foremost, I'd like to thank everybody for your replies.
Although I have sound knowledge and understa
y 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 wrote:
Why do I get this error message?
Try having t
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 = sqlite3_open(databese_name.c
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