){
clearSelect(p);
sqliteFree(p);
}
}
--
I think it should be:
if ( *p )
Mario Hebert
Legerity
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
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
ll, as you can imagine it takes
forever to flash it (even if it works!).
Mario Hebert
Legerity
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
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
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
,
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
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
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
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,
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 ;
}
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
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
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
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
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
&
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
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
that I did not do anything stupid.
Mario Hebert
Legerity
20 matches
Mail list logo