[sqlite] Bug in SQlite ?

2006-09-06 Thread Mario . Hebert
){ clearSelect(p); sqliteFree(p); } } -- I think it should be: if ( *p ) Mario Hebert Legerity

[sqlite] Strange behavior after database save.

2006-08-16 Thread Mario . Hebert
rieve the records using "order by" in my query, sqlite tells me "no such table" but if I remove "order by" from my query, it works and I retrieve them (unordered of course). Any idea?? Mario Hebert

Re: [sqlite] Sqlite flash and mallocs.

2006-07-31 Thread Mario . Hebert
Agree. Actually, I should have instead created the same database on the windoze port and see if the numbers are the same. Mario [EMAIL PROTECTED] wrote: > > Is it normal it takes 13,000 mallocs > That depends on your database schema and the data you are storing. -- D. Richard Hipp

[sqlite] Sqlite flash and mallocs.

2006-07-28 Thread Mario . Hebert
ll, as you can imagine it takes forever to flash it (even if it works!). Mario Hebert Legerity

[sqlite] update or insert.

2006-06-27 Thread Mario . Hebert
able to update (or insert if it does not exist) profile with a new 'magic_number' while keeping the same 'id' or updating the new 'id' in 'config' table. What is the simplest way (and most efficient) to achieve this ? Regards, Mario Hebert Legerity

Re: [sqlite] Database locked. Any idea ?

2006-06-26 Thread Mario . Hebert
Just wanted to give an update in case someone follows this thread in the message archive later on. I found the problem, it was the silicon that was not doing certain memory accesses properly. As they say, always blame the hardware. Thanks, Mario Hebert [EMAIL PROTECTED] 06/20/2006 03:07

Re: [sqlite] Database locked. Any idea ?

2006-06-21 Thread Mario . Hebert
Sqlite3BtreeCursor wrFlag = 0; Any idea how my table should be unlocked ? Mario Hebert Legerity [EMAIL PROTECTED] 06/20/2006 03:07 PM Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] Database locked. Any idea ? [EMAIL

Re: [sqlite] Database locked. Any idea ?

2006-06-20 Thread Mario . Hebert
, Mario Hebert Legerity > Anyone has an idea of what may be wrong ? Oh yeah, I am running of my own > port using uCos and a memory database. > You say you are using a ":memory:" database and this is happening? Can you provide a test program running under Linux? -- D. Ric

[sqlite] Database locked. Any idea ?

2006-06-20 Thread Mario . Hebert
sqlite3_prepare("select * from ..."); sqlite3_step(...); sqlite3_column_text(...); sqlite3_finalize(...); Anyone has an idea of what may be wrong ? Oh yeah, I am running of my own port using uCos and a memory database. Mario Hebert Legerity

[sqlite] Flashing memory database.

2006-06-05 Thread Mario . Hebert
This is an implementation question but I am pretty sure it applies to many people out there. I am using a memory database which I want to "flash" periodically. I have logically broken down the database into three pieces which have 3 degrees of importance (critical, high and low). I have written

Re: [sqlite] Re: select count(*) and sqlite3_bind_int

2006-05-31 Thread Mario . Hebert
Ok it makes sense, but how can I get the number of rows in my query then ? Thanks, Mario Hebert Legerity > strcpy( query, "select count(*) from dummy"); > rc = sqlite3_prepare( memdb, query, strlen(query), &pStmt, NULL); > rc = sqlite3_bind_text( pStmt,

[sqlite] select count(*) and sqlite3_bind_int

2006-05-31 Thread Mario . Hebert
now how many rows are in my table otherwise ? Mario Hebert Legerity _ char query[1024]; rc = sqlite3_open(":memory:", &memdb); if( rc ) { (void)sqlite3_close(memdb); return ; }

Re: [sqlite] SQLite without callback function

2006-05-30 Thread Mario . Hebert
Have not you forgot the bind ? Mario Hebert Legerity John Stanton <[EMAIL PROTECTED]> 05/30/2006 04:55 PM Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] SQLite without callback function Use sqlite3_prepare, sqlite3_step, sqlite3_res

[sqlite] SQLite without callback function

2006-05-30 Thread Mario . Hebert
I think I know the answer to this but I figured it would be better to ask than to do a major design flaws. :) What is the most efficient way in SQLite (using the C/C++ interface layer) to retrieve the result of a query without using the callback function (setting it to NULL) ? Thanks, Mario

Re: [sqlite] Optimizing SQLite footprint and my misadventure with Lemon

2006-05-19 Thread Mario . Hebert
a difference, I am using a DOS version of lemon which I built with LCC. Mario Hebert Legerity [EMAIL PROTECTED] 05/16/2006 08:35 PM Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] Optimizing SQLite footprint and my misadventure with Lemon

Re: [sqlite] Réf. : Re: [sqlite] Réf. : Re: [sqlite] DB in memory - table create won't work

2006-05-17 Thread Mario . Hebert
your solution is most probably in os_unix.c, have a look at the file system APIs... Mario Hebert Legerity "Night Media LTD" <[EMAIL PROTECTED]> 05/17/2006 01:28 PM Please respond to sqlite-users@sqlite.org To cc Subject [sqlite] Réf. : Re: [sqlite] Réf. : Re: [sqli

Re: [sqlite] Réf. : Re: [sqlite] DB in memory - table create won't work

2006-05-17 Thread Mario . Hebert
Well, I could understand more your situation since it was probably because the sync with the hardware was not ported properly to your platform and data was not being saved to the media. although, I just can't make sense why the opposite happens to me *sigh* Mario Hebert Legerity &

Re: [sqlite] DB in memory - table create won't work

2006-05-17 Thread Mario . Hebert
Actually I forgot to double check with the cygwin version I have. Makes me wonder if I made something goofy in my port, but it should reside in memory so I am puzzled about what could be wrong. The same piece of software works when I write to flash Puzzled Mario Hebert Legerity

[sqlite] DB in memory - table create won't work

2006-05-17 Thread Mario . Hebert
table test ( a int ); 3. I try to do an insert: insert into test values (5); I get the following error, no such table: test what could I do wrong ? Regards, Mario Hebert Legerity

[sqlite] Optimizing SQLite footprint and my misadventure with Lemon

2006-05-16 Thread Mario . Hebert
that I did not do anything stupid. Mario Hebert Legerity