At 07:41 6-1-2004 -0800, Buzz Weetman wrote:
I'm using sqlite in an embedded system. Disk I/O is relatively slow. I
am doing a:
SELECT count(*) FROM my_table;
This is taking too much time. I've also tried count(1), as I saw
suggested elsewhere in the mail list... though I'm not entirely sure
At 16:45 6-1-2004 +0100, Danny Reinhold wrote:
> When I try to recompile the shell.c file I get 4 errors, "unresolved
> external" on:
>
> Where can I find the sourcecode for these functions ?
> sqliteOsFileExists
os.h/os.c
> sqliteIsNumber
> sqliteStrICmp
> sqliteStrNiCmp
sqliteInt.h/util.c
All t
When I try to recompile the shell.c file I get 4 errors, "unresolved
external" on:
sqliteOsFileExists
sqliteIsNumber
sqliteStrICmp
sqliteStrNiCmp
Where can I find the sourcecode for these functions ?
thanks,
Hennie
-
To unsubs
to get the number of rows:
select count(*) from testtableint;
or the next on might be quicker:
select count(1) from testtableint;
How can you be sure that the first row contains the lowest rowid when doing:
"select rowid,. from testtableint where rowid>2 limit 1"
Would you need to do:
"select r
At 08:14 1-1-2004 -0500, D. Richard Hipp wrote:
[EMAIL PROTECTED] wrote:
What I am searching for is when I retrieved Row 2, I want to go to Row 3,
and find an efficient way to do this.
What I tried is this
First go to Row 2, doesn't matter how, but I found the RowID belonging to
Row 2
I want to d
Hi All,
I've just started with sqlite, I discovered it a week ago. What I missed
was a program to browse the database and open tables in a grid on a form.
So I built it myself as a project to learn how to work with sqlite.
There is one problem I could not solve and thats an empty recordset. When
6 matches
Mail list logo
