[sqlite] SQLite

Hey kids. Looking at the choices given at http://www.sqlite.org/download.html, I would like to know what would be the best way to add SQLite to my app. I am using Windows 7-64bit as the OS and Code::Blocks with MinGW/GNU C++. ___ sqlite-users

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

yap, I agree with you, email better. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mark Schonewille Sent: Tuesday, October 18, 2011 5:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] FW: How about a

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Sorry folks, but it does not matter who is right or wrong, if you want to open a forum... go ahead, you can even announce it here; those interested will follow your idea, but for the time being you are taking a lot of bandwidth, time and creating distraction. Please, I encourage you to open the

[sqlite] Where is my posting?

Hey boys and girls! Anyone knows why is it that I cannot see my own postings, worst yet! Nobody replies to my postings?! How can I know if my email actually is being considered by other members of the list or if it was never posted? TIA ___

Re: [sqlite] Where is my posting?

at 4:48 PM, Arbol One <arbol...@gmail.com> wrote: > Hey boys and girls! > > Anyone knows why is it that I cannot see my own postings, worst yet! Nobody > replies to my postings?! > > How can I know if my email actually is being considered by other members of > the list o

[sqlite] Testing SQLite in C++

Hey kids, I am testing SQLite in the hope that I can use it in my program, but I get this confusing error msg, Can anybody help? Error message D:\dev\sqlitetest\main.cpp:14:10: error: 'sqlite3_api' was not declared in this scope Code ~ #include #include

Re: [sqlite] Testing SQLite in C++

not include sqlite3ext.h. Applications need only sqlite3.h. Pavel On Thu, Oct 20, 2011 at 11:02 AM, Arbol One <arbol...@gmail.com> wrote: > Hey kids, I am testing SQLite in the hope that I can use it in my program, > but I get this confusing error msg, Can anybody help? > >

Re: [sqlite] Using SQLite on Windows 64bit

Yes, compiling to 32-bit is nice. It is like dancing at the tunes of "Earth Wind and Fire", h, those were the days. Like the old good songs, the 32bit apps are a good memory, many people like it, but they are a thing of the past. We are developers and anyone of us who stays behind, is left

[sqlite] Documentation in PDF

Any one knows where I can get the documentation in http://www.sqlite.org/download.html, but in PDF format? TIA ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Learning SQL using SQLite

Hello everyone, I have downloaded the sqlite-amalgamation-3070900.zip file and I have incorporated the source code to a small program I am building. I want to use SQLite as my database, but I have little to nil knowledge of SQL, can anyone

[sqlite] A DLL for my WinXP

Where can I find the DLL file for my winxp? TIA -- This email is for the sole use of the intended recipient and may contain confidential or privileged information. Unauthorized use of its contents is prohibited. If you have received this email in error, please notify the sender immediately via

[sqlite] Fwd: A DLL for my WinXP

Helloo! is any body there??!! nock nock ... Is this group dead??!! Where can I find the DLL file for my winxp? TIA Original Message Subject:A DLL for my WinXP Date: Sun, 20 Jun 2010 20:59:20 -0400 From: Arbol One <arbol...@gmail.com> To: sqlite

Re: [sqlite] insert if in SQL cmd

The analogy you have chosen to explain the algorithm of your program is clear, but it seems to me that you are using a specific computer language to achieve its goal. Perhaps, it would be much easier on us, the helpers, to help you if you provide information that is more tangible; as in a snip of

Re: [sqlite] Getting Error SQLITE_NOTADB

Save yourself some time and show some code, it will make it easy for us to help you. Genius might have limitations, but stupidity is no handicap -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of kritesh tripathi Sent:

Re: [sqlite] MyJSQLView Version 3.40 Released

UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity - Dennis Ritchie Genius might have limitations, but stupidity is no handicap Eat Kosher -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]

[sqlite] VC++ and SQLite

I know this question is not a SQLite question, but I am hoping that someone here has had a similar experience and/or can point me to the right place to ask this question. After years or using Code::Blocks and Dev-Cpp, I have recently installed Visual Studio 10 Express; it is the first time I

Re: [sqlite] VC++ and SQLite

I would also keep this feature, however, in the case of SQLite3 amalgamation, I am really confused. You know how we have to #include the 'stdafx.h' in every declaration file (making it non-portable code), i.e. .c, .cpp, etc., well, I tried doing the same thing with sqlite.c, but VS10 complains

Re: [sqlite] VC++ and SQLite

..@sqlite.org] On Behalf Of Michael Schlenker Sent: Tuesday, November 13, 2012 8:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VC++ and SQLite Am 13.11.2012 14:33, schrieb Arbol One: > I would also keep this feature, however, in the case of SQLite3 > amalgamation, I

Re: [sqlite] VC++ and SQLite

, November 13, 2012 9:19 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VC++ and SQLite why would you need stdafx.h for sqlite ? what is the added benefit ? On 13 November 2012 14:57, Michael Schlenker <m...@contact.de> wrote: > Am 13.11.2012 14:33, schrieb Arbol O

Re: [sqlite] VC++ and SQLite

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Drescher Sent: Tuesday, November 13, 2012 9:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VC++ and SQLite On Tue, Nov 13, 2012 at 8:51 AM, Arbol One <ar

Re: [sqlite] VC++ and SQLite

-users-boun...@sqlite.org] On Behalf Of Michael Schlenker Sent: Tuesday, November 13, 2012 8:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VC++ and SQLite Am 13.11.2012 14:33, schrieb Arbol One: > I would also keep this feature, however, in the case of SQLite3 > amalga

[sqlite] We have a snake in paradise

We have a snake in paradise. Pls Administrator, remove the OP of this message. We cannot afford this kind of distractions from SQLite or distortion of what SQLite is. TIA -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Darko

[sqlite] Good books to lear SQL using SQLite?

I am learning SQL using SQLite, can anyone tell me of a good book to learn SQL using SQLite? TIA ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite and C++

Anyone knows where I can find some examples of how C++ interfaces with SQLite? I just need to see some code that is functional and not just some snips of how it maybe-should-possibly work. TIA ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] C++ programming - int sqlite3_open_v2() question

int sqlite3_open_v2( const char *filename, /* Database filename (UTF-8) */ sqlite3 **ppDb, /* OUT: SQLite db handle */ int flags, /* Flags */ const char *zVfs /* Name of VFS module to use */ ); In my Windows 7 box, using MinGW I am trying to use sqlite in my c++ program, but the parameters

Re: [sqlite] C++ programming - int sqlite3_open_v2() question

but that will be on another email. - Original Message - From: Stephan Beal Sent: 06/17/12 11:25 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] C++ programming - int sqlite3_open_v2() question On Sun, Jun 17, 2012 at 5:14 PM, Arbol One <arbol...@programmer.net>

[sqlite] vfs?

Using C/C++, is there a way to extract which file system is SQLite using? TIA ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] vfs?

Subject: Re: [sqlite] vfs? Arbol One <arbol...@programmer.net> wrote: > Using C/C++, is there a way to extract which file system is SQLite using? You already know that - it's the one you've specified in a call to sqlite3_open_v2. What problem are you trying to solve? -- Igor

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

ion of zSql"). Thanks in advance - Original Message - From: Stephan Beal Sent: 06/17/12 02:35 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] C++ programming - int sqlite3_open_v2() question On Sun, Jun 17, 2012 at 7:39 PM, Arbol One <arbol...@programmer.net&g

Re: [sqlite] C++ programming - int sqlite3_open_v2() question

o: General Discussion of SQLite Database Subject: Re: [sqlite] C++ programming - int sqlite3_open_v2() question On 17 Jun 2012, at 6:39pm, Arbol One <arbol...@programmer.net> wrote: > Now, my next step is to create data tables, but that will be on another email. It helps to read the d

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

d::endl; exit(-1); } however, this gives me a run time error that reads *#0 0x00446642 in ??() (??:??)* What did I do wrong? - Original Message - From: Igor Tandetnik Sent: 06/17/12 05:41 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ programming - int sqlite3_p

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

); std::cout << "error sqlite3_step: " << rc << std::endl; exit(-3); } Any suggestions? - Original Message - From: Igor Tandetnik Sent: 06/17/12 06:41 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question Arbol

[sqlite] C++ programming - sqlite3_column() question

After creating a database, I, now, would like to create a table called 'friend', but for some reason 'sqlite3_column()' reports zero. What elese do I have to do to have the table created, this is what I have so far done. int main() { sqlite3 *db; // Data Base sqlite3_stmt* stmt; int rc; //

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

sqlite3_prepare_v2() question Arbol One <arbol...@programmer.net> wrote: > Continuing with the questions and moving to the step three. > int sqlite3_step(sqlite3_stmt*); > --- > rc = sqlite3_step(stmt); > if(rc != SQLITE_DONE) { > sqlite3_close(db); > std::cout <

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

namespace jme { class Runner : public Gtk::Window { private: jme::Exception* e; // Exception handler sqlite3 *db; // Data Base sqlite3_stmt* stmt; // SQL statement Glib::ustring dbName; // db name Glib::ustring sName; // my name Glib::ustring sAddress; // my address Glib::ustring vfs; //

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

in something that understands what SQLite database is. > Pavel On Thu, Jun 21, 2012 at 12:22 PM, Arbol One <arbol...@programmer.net> > wrote: > namespace jme { > class Runner : public Gtk::Window { > private: > > jme::Exception* e; // Exception handler > sqlite3 *db; //

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

Jun 22, 2012 at 4:34 AM, Arbol One <arbol...@programmer.net> > wrote: > Thanks for the prompt response. > As I stated in my previous email, > I used SQLight Designer to view the database, which application would you > recommend to view my database? Please keep in mind t

[sqlite] C++ programming - SELECT question

A pessimist is one who makes difficulties of his opportunities and an optimist is one who makes opportunities of his difficulties. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] C++ programming - getting data from a table

in a database called 'db' I created a table named 'friend' that looks like this: string create_table( "CREATE TABLE friend (name TEXT, address TEXT, age INT)"); I entered some values in that table and now I would like to extract the values from that table. Shown below is what I have done so far,

Re: [sqlite] C++ programming - getting data from a table

On 24 Jun 2012, at 3:40pm, Arbol One <arbol...@gmail.com> wrote: > I entered some values in that table and now I would like to extract > the values from that table. Shown below is what I have done so far, > but I have hit a wall, I cannot find definitive inform

Re: [sqlite] C++ programming - getting data from a table

@sqlite.org Subject: Re: [sqlite] C++ programming - getting data from a table Arbol One <arbol...@gmail.com> wrote: > Thank you for the prompt response. Now, using simple std::cout, could > you show (give an example) of how to display (out streaming) the data extracted? sqlite3* db;

Re: [sqlite] C++ programming - inserting data in a table

essage- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, June 25, 2012 12:07 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ programming - creating a table Arbol One <arbol...@gmail.com> wrote: >cre

Re: [sqlite] C++ programming - creating a table

tation error. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, June 25, 2012 12:07 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ programming - creating a table Arbol One <arbol...@g

Re: [sqlite] C++ programming - Extracting data

.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, June 25, 2012 9:07 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ programming - creating a table Arbol One <arbol...@gmail.com> wrote: > Q: What are you trying to achieve

Re: [sqlite] C++ programming - Extracting data

//<== Seg fault std::cout << sName << std::endl; ... } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sql

Re: [sqlite] C++ programming - Extracting data

ble(); Setter(); getter(); theDestructor(); return 0; } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-bo

[sqlite] C++ - ISERT from a data object

In my GUI application the user enters a information that will go in a SQLite database table, so statements like: string dbdata = "INSERT INTO friend (name, address, age) VALUES ('Caramba', '490 New Bridge', '49')"; are not very useful in a real life C++ GUI application. I would assume that

Re: [sqlite] C++ - ISERT from a data object

a data object Arbol One <arbol...@gmail.com> wrote: > In my GUI application the user enters a information that will go in a > SQLite database table, so statements like: > > string dbdata = "INSERT INTO friend (name, address, age) VALUES > ('Caramba

[sqlite] Many tables in one database

Using SQLite3.7.8 amalgamation and C++, I would like to create a database with several joined tables. Can SQLite3 have many tables in one database? Freedom of speech does not translate to freedom of insulting ___ sqlite-users mailing list

[sqlite] database AND table already exist?

Is there a way to find out if a certain database AND table already exist? In my C++ program I would like to query SQLite3 to find out if a database already exists and also if a particular table exists in that database. Is there a way to do this? I am using std i/o methods to check for the

[sqlite] sql statement CREATE TABLE

I am getting a run time error that reads = Error 1 Library routine out of sequence = The only things, since I am new on it, that could be causing a problem would be the sql statement CREATE TABLE, maybe the parameters are not right? The code nip - sql_param_tblName =

[sqlite] A matter of UNIQUEness

When using the statement 'UNIQUE INTEGER val', does SQLite3 automatically create a unique integer value for the transaction or would it only ascertain the uniqueness within that column? i.e.: Glib::ustring sql_param_tblName = "CREATE TABLE name(n_id INTEGER PRIMARY KEY, title TEXT, fname

[sqlite] C++ - Creating Table

Using SQLite version 3.7.8 amalgamation, under Win7 with MinGW, I compile the bellow program, but for some strange reason I am getting a runtime error when creating the table. I hope that one of you would be able to tell me what I am doing wrong. TIA === class mySQLite3Class { private:

Re: [sqlite] C++ - Creating Table

e.sql"; string sql_param_tblName = "CREATE TABLE name(n_id INTEGER PRIMARY KEY, title TEXT, fname TEXT, mname TEXT, lname TEXT)"; mySQLite3Class *myDB = new mySQLite3Class(dbName); myDB->createTable(sql_param_tblName); return 0; } Michael D. Black Senior Scientist Advanced

[sqlite] C++ - sqlite3_extended_result_codes(

I would like to turn on the extended result codes, however, the prototype below does not explain what the value for the second parameter should be. Can anybody help? int sqlite3_extended_result_codes(sqlite3*, int onoff); TIA ___ sqlite-users

Re: [sqlite] C++ - sqlite3_extended_result_codes(

++ - sqlite3_extended_result_codes( On Tue, Jul 24, 2012 at 4:13 PM, Arbol One <arbol...@gmail.com> wrote: > I would like to turn on the extended result codes, however, the > prototype below does not explain what the value for the second parameter should be. > > Can any

[sqlite] C++ - nothing has been stored!!??

And here I am again, asking for what you find so easy and I. well, just cannot understand. I am trying to write to a database table previously created by another process like this: void someClass::create_tblName() { sql_param_tblName = "CREATE TABLE name(n_id INTEGER PRIMARY KEY, title

[sqlite] C++ - All the data in ONE row

OK, continuing with the writing to the database, here is the driver method for the class rapper for SQLite3. The problem I have is that I have no control as to the exact location where I want the data to be stored, look the table below to have a better idea of what I mean. My question is, is

[sqlite] C++ - Evaluating a statement

Reading the documentation, it says that 'sqlite3_step(sqlite3_stmt*) ' must be called at least once to evaluate the statement. However, what does it evaluate? Freedom of speech does not translate to freedom of insulting ___ sqlite-users

[sqlite] C++ - Finalizing my SQLite interface

Before calling the destructor, I would like to make sure that all the sqlite3_stmt have been 'finalized', is there a function in SQLite that that can help me do this, or should I just use 'NULL'? tia ___ sqlite-users mailing list

[sqlite] C++ - Installer

I was wondering if there is an 'Installer' for Windows 7 that you would recommend. I want my user to have all the necessary SQLite3 files needed for my application as well as all the gtkmm files. TIA ___ sqlite-users mailing list

Re: [sqlite] SQLite support on windows

I am glad someone asked this question, we are almost finish with a small application that is best suited for a hand held device. Is there a device anyone here could suggest? As I said, the application is very small and uses SQLite as its RDB. The application resembles a questionnaire... fill in

Re: [sqlite] SQLite support on windows

... where could I find a list of these number of devices? Does Microsoft has one? TIA -Original Message- From: Mohit Sindhwani [mailto:m...@onghu.com] Sent: Sunday, August 26, 2012 1:13 AM To: General Discussion of SQLite Database Cc: Arbol One Subject: Re: [sqlite] SQLite support

[sqlite] (no subject)

Does anyone know if there is a mailing list for the STL project? This e-mail is for the sole use of the intended recipient and may contain confidential or privileged information. Unauthorized use of its contents is prohibited. If you have received this e-mail in error, please notify sender

[sqlite] C++ - WHERE clause

As many of you know, I am trying to learn SQL using C++. Below is an error I get when I try using the C++ example below it. Error Code: 1 Error Message: near "VALUES": syntax error Glib::ustring apstr; Glib::ustring sName; int

[sqlite] C++ - WHERE clause - update

rc = sqlite3_step(mystmt); if(rc == SQLITE_ROW ) { The code, in this case, does not process this statement!!?? <<-- apstr = (const char*)sqlite3_column_text(mystmt,pos); std::cout << apstr << std::endl; //<<-- this is not executed } Table: id | tile | fname | mname | lname |

Re: [sqlite] C++ - WHERE clause - update

: [sqlite] C++ - WHERE clause - update What is the value returned from sqlite3_step()? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Arbol One Sent: Thursday, September 06, 2012 12:14 PM To: 'General Discussion of SQLite

[sqlite] C++ - WHERE clause - 2nd update

I got this code to work, however, I am getting a segmentation fault on this code. I pass to SQLite only one statement [db->setStmt(apstr);], I read the first of the 'fname', but I don't know how to get to the second 'fname' in the database. I am not very sure as to what do to tell the program to

Re: [sqlite] C++ - WHERE clause - 2nd update

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Marcus Grimm Sent: Friday, September 07, 2012 3:39 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] C++ - WHERE clause - 2nd update On 07.09.2012 08:58, Arbol One wrote: > I got this code to work, however, I am getting a segmentat

[sqlite] C++ - HOW MANY rows?

I read my newly created database using this method: void Runner::read_tblName() { . sql_statement = "SELECT * FROM name"; db->setStmt(sql_statement); int pos = 0; data1 = db->read_int(pos); db->setStmt(sql_statement); pos = 1; data2 = db->read_str(pos);

Re: [sqlite] C++ - HOW MANY rows?

Thanks Igor for your prompt response. Since the call to the sqlite3_step function is inside the mySQLite3::read_* class-function/method, I call the read_* method from Runner::read_tblName() for each datum I need to retrieve. Now, in a while loop inside Runner::read_tblName() I could call the

Re: [sqlite] C++ - HOW MANY rows?

much for your help and have a wonderful day. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Tuesday, September 11, 2012 11:24 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ - HOW MANY rows? Arbol

Re: [sqlite] C++ - HOW MANY rows?

n...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Arbol One [arbol...@gmail.com] Sent: Tuesday, September 11, 2012 9:44 PM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] C++ - HOW MANY rows? Thanks Igor for your prompt response. Since the call to the sqlite3_

[sqlite] C++ - Sqlite3 and Visual Studio 10

When trying to port my application from Code::Blocks(windows version) to Visual Studio 10, I am getting some error, similar to the one below: 1>my_sqlite3.obj : error LNK2019: unresolved external symbol _sqlite3_prepare_v2 referenced in function "public: bool __thiscall mySQLite3::notExist(class

Re: [sqlite] C++ - Sqlite3 and Visual Studio 10

@sqlite.org Subject: Re: [sqlite] C++ - Sqlite3 and Visual Studio 10 Arbol One wrote: > error LNK2019: unresolved external symbol _sqlite3_prepare_v2 It appears you forgot to include sqlite3.c in your application. Regards, Clemens > This e-mail is for the sole use of the intended recipient a

Re: [sqlite] how to unsubscribe?

Go to: http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users and unsubscribe, that's it. Genius might have limitations, but stupidity is no handicap Eat Kosher -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Álvaro