rosqlite aims to be a front end GUI configurable to do database
applications using SQLite (Windows). It is a work in progress
Visit http://ar.geocities.com/rosqlite/ for more details and try
I will appreciate your opinion.
Leif:
There may be better solutions, but you don't need to scan the SQL, just
put it as subquery:
sqlite3_printf "Select Count(*) from (%s)", pSQL
will do the work for you.
Remember what i said about Group by clauses.
Anyway i think a function like sqlite3_row_count(hStmt) would be fantastic.
Mar
Hi Leif:
Will "Select Count(*) from (Your_SQL)" give you what you want?
Be careful if Your_SQL includes Group By clause, don't know if work as
expected.
Marcelo
Dennis Cote wrote:
If you can tell us what CPU and compiler you are using, we may be able
to help.
I use 486 and above CPU and RosAsm PEs builder (GPL,
http://www.RosAsm.org) on win OS. And i do not compile sqlite but just use
provided dll.
Thank you.
Marcelo.
--
Hi
I'm very interested in "runing-functions"!
If the order is a problem, it seems to me that can be solved adding one
more level of subqueries:
SELECT val, period
FROM (
SELECT val, period, running_total(val) AS runner
FROM (
SELECT val, period
FROM t1
ORDER BY perio
Hi!
Supose i have a table like this:
Table
-
X Y Z
1|1|1
1|2|2
1|3|3
2|1|2
2|2|4
2|3|6
3|1|3
3|2|6
3|3|9
As far as i know there isn't a SQL statment to get next result in sqlite:
Result
---
M|1|2|3
1|1|2|3
2|2|4|6
3|3|6|9
I think the best approach is create a temporary table, so i can use
I've got it: in c doubles are passed to a function by pushing its two
dword parts: first the high and then the low part, and when it's the
result of a double type function is returned in the ST0 of the FPU.
Thank you!
Marcelo.
Clay Dowling said:
double sqlite3_column_double(sqlite3_stmt*, int iCol);
returns a double, not a pointer to a double.
Thank you Clay.
Excuse me, i'm not good programming in c. A double is 8 bytes width. How
does a function return anything other than 4 bytes (in eax register) if
not in a pointe
Hi everybody!
I need a tip about how sqlite3_column_double works. I hoped it returns a
pointer to a 8-byte-real, but it don't.
Here is what i do:
CREATE TABLE [tblTyped] ([a] TEXT, [n] NUMERIC, [i] INTEGER, [b] BLOB)
Insert into tblTyped values('helo,,,', 1.1121, '8.0001', 'blob!!!')
then sqlite
Hi!
Is there a list of improvements coming in SQLITE 3?
Is there a target date to it release?
Thanks!
MZ
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
10 matches
Mail list logo