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

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

2010-02-04T07:43:05.273-08:00

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 to ...

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 data ...

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 ดูทีวี วิทยุ

2009-07-15T01:25:35.877-07:00

thank , i will try it

ดูทีวี

วิทยุ

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

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 using i...

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 itself ,...

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?