Comments on EarthBrowser: SQLite C++ wrapper, so you don't have to

Romantic pink is a tender pretty girl can best emb...

2010-11-15T19:57:00.320-08:00

Romantic pink is a tender pretty girl can best embody the links of london color; the stars also began to become followers of links london pink. The summer of passion and energy links of london bracelet and romanticpink, aroused a sweet and romantic agitation. See below nine groups sweetie bracelet pink star.

thank , i will try it ทีวีออนไลน์

Matt, Works great so far but I think u mixed up r...

2010-01-11T23:00:02.038-08:00

Matt,

Works great so far but I think u mixed up reset and finalize so binding of new variables for the insert example don't work.

Add a finalize function and rework reset as follows:

/// Delete a statement.
void sql::finalize()
{
if(stmt_)
sqlite3_finalize(stmt_);
stmt_ = 0;
ipos_ = opos_ = icol_ = ocol_ = 0;
}

/// Reset the statement to allow new bindings to existing statement or rewind DB.
void sql::reset(void)
{
if (sqlite3_reset(stmt_) != SQLITE_OK)
throw new sd::db_error("Failed to reset statement");
}

Again great wrapper otherwise.

thanks Matt, I've been kludging my own wrapper...

2010-01-11T22:03:09.489-08:00

thanks Matt, I've been kludging my own wrapper to date but this is much cleaner and more complete.

Great, it's just what I want! but the insert d...

2009-09-30T00:56:19.491-07:00

Great, it's just what I want!
but the insert data in the example doesn't work for me, I'm using gcc version 4.0.1 (Apple Inc. build 5493) under MacOS. I checked the code but could not find when did you do the sql.step(), the only place is sql << end, but I don't know how to do it, and could not find the code in your example.

so I changed the test code to :
sd::sql insert_query(database); // build an sql query
insert_query << "insert into work (first_name, last_name, hours) VALUES(?, ?, ?)";

database << "begin transaction";// create a transaction for speed

// insert data (sdsqlite will auto-detect data type and execure query)
insert_query << "Joe" << "Smith" << 1 ;
if(!insert_query.step()){
cout << "error insert 1" << endl;
};

insert_query << "insert into work (first_name, last_name, hours) VALUES(?, ?, ?)" << "tom" << "pet" << 2.5 ;
if(!insert_query.step()){
cout << "error insert 2" << endl;
};

after that, it works, is that a problem? thanks for the great wrapper, it will save me a lot of time.

The SQLite API is quite straightforward to begin w...

2009-09-06T14:44:31.646-07:00

The SQLite API is quite straightforward to begin with. It is not much more complicated than learning fopen/fclose/fread/fwrite in Posix.

If C++ is not your thing, there are lots of bindings to other languages. Check out my site at http://www.squidoo.com/sqliteprogramming for more details.

thank , i will try it ดูทีวี

วิทยุ

You would probably want to use the standard "...

2009-06-09T07:57:07.896-07:00

You would probably want to use the standard "alter table" command for SQLite which is described here. A simple example would be "alter table mytable add column newcolumn integer".

can you write me that as those examples?

2009-06-09T07:50:19.146-07:00

can you write me that as those examples?

ya..i know that those are examples.But I'm usi...

2009-06-09T07:49:17.083-07:00

ya..i know that those are examples.But I'm using it my application,in which I have to add a column in existing table making sure that it doesn't exists before.Can you tell me,how can I do this?

The wrapper doesn't contain any fields by itse...

2009-06-09T07:45:53.002-07:00

The wrapper doesn't contain any fields by itself , those statements you see are just examples. You can specify any sql statement you like, with whatever fields your table has, to extract and/or insert data into your table.

how can i add a column in the table if the column ...

2009-06-09T01:26:09.634-07:00

how can i add a column in the table if the column doesn't exists using your wrapper?

Comments on EarthBrowser: SQLite C++ wrapper, so you don't have to

Romantic pink is a tender pretty girl can best emb...

thank , i will try it ทีวีออนไลน์

Matt, Works great so far but I think u mixed up r...

thanks Matt, I've been kludging my own wrapper...

Great, it's just what I want! but the insert d...

The SQLite API is quite straightforward to begin w...

thank , i will try it ดูทีวีวิทยุ

You would probably want to use the standard "...

can you write me that as those examples?

ya..i know that those are examples.But I'm usi...

The wrapper doesn't contain any fields by itse...

how can i add a column in the table if the column ...

thank , i will try it ดูทีวี

วิทยุ