Re: [sqlite] Create table - Error code: 21

   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,

Re: [sqlite] Create table - Error code: 21

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

Re: [sqlite] Create table - Error code: 21

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

[sqlite] SQL prepare statement - help

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

[sqlite] Create table - Error code: 21

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, ";    

[sqlite] GCC and DLL

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

Re: [sqlite] GCC and DLL

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

[sqlite] SQLite 3.20, are you sure?

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

Re: [sqlite] SQLite 3.20, are you sure?

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

[sqlite] C++ sqlite_version()

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&

[sqlite] My 1st C++ SQLite3 program

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 =

Re: [sqlite] My 1st C++ SQLite3 program

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

Re: [sqlite] My 1st C++ SQLite3 program

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

Re: [sqlite] My 1st C++ SQLite3 program

:-) 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

[sqlite] Yes, NULL is zero, is it?

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(),   

Re: [sqlite] Yes, NULL is zero, is it?

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

Re: [sqlite] Is the file I'm about to open an SQLite Database

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

Re: [sqlite] SQL statement and C++

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

Re: [sqlite] SQL statement and C++

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

[sqlite] SQL statement and C++

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

[sqlite] multi-node triggers

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