[sqlite] rowid increment

The rowid looks to reuse numbers when a row is deleted, how can i stop this? For example, i insert 3 rows, then i delete row 2, when entering a new row after that the rowid is 2 rather than 4. I want the rowid to be 4. ~Shaun ___ sqlite-users mail

Re: [sqlite] database is locked

it wont it was a quick example, that prep is suppose to be sqlite3_step ~Shaun ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] database is locked

I have some code that i'm having problems with. i open the database, prepare, and the step through. During each step i'm trying to run a seperate exec which is attempting to update a row. I keep getting a error that says database is locked. I tried creating a additional open to just use on

[sqlite] strcpy and sqlite3_column_text

I'm getting this warning when doing the following warning: pointer targets in passing argument 2 of 'strcpy' differ in signedness strcpy(result->ip_address,sqlite3_column_text(plineInfo, 2)); result->ip_address is from struct result { char ip_address[17]; }; Anybody know what needs to be done

[sqlite] sqlite3_step and column name

I'm trying to understand a bit how this works. For my example i just simply want to set a column value to a char. If i know the name of the column how can id o this. For example the column name i want is 'fname'. I know the section below with setting myname and then printing it doesnt really

[sqlite] getting data by the column name.

Anybody help me out here, trying to grab column info based on the columns name. Examples i keep seeing people seam to use the colunm number but cant you access these values by the name? int main(void) { char myname[50]; sqlite3 *db; sqlite3_stmt *plineInfo = 0; if(sqlite3_open("my.