Re[2]: [sqlite] adding years,months, days with decimals using datetime function

I faced the same problem recently (before I joined this newsgroup). I backed off from SQL to C++ level, which was very uncomfortable. It would be very handy if you implement the same decimal-point parsing for years too ;) Best Regards, Ivailo Karamanolev On Wednesday, January 31, 2007, 6:04:14

Re: [sqlite] Re: Re: An SQL question (Not directly related to SQLite)

On Saturday, January 27, 2007, 10:10:27 PM, Igor Tandetnik wrote: > [EMAIL PROTECTED] wrote: >> Actually, my query is something like >> SELECT ... FROM ... WHERE `pid` = (SELECT `id` FROM ...); >> if i put that group by... will it group all rows, or only those with >> the

Re[2]: [sqlite] Re: An SQL question (Not directly related to SQLite)

On Saturday, January 27, 2007, 6:09:59 PM, Trey Mack wrote: >> Actually, my query is something like >> SELECT ... FROM ... WHERE `pid` = (SELECT `id` FROM ...); >> if i put that group by... will it group all rows, or only those with >> the same pid? > Use a subquery >

Re: [sqlite] Re: An SQL question (Not directly related to SQLite)

On Saturday, January 27, 2007, 4:59:49 PM, Igor Tandetnik wrote: > [EMAIL PROTECTED] wrote: >> I've got a query, let's say query "A" which returns data in the >> following form: >> >> price | count >> 3 5 >> 3 8 >> 4 2 >> 4 9 >> 4 12 >> 6

[sqlite] An SQL question (Not directly related to SQLite)

Sorry for the previous trash message I've got a query, let's say query "A" which returns data in the following form: price | count 3 5 3 8 4 2 4 9 4 12 6 10 What I want to do is get unique prices and sum the count of the duplicates, so it gets price | count

[sqlite] An SQL question (Not directly related to SQLite)

I've got a query, let's say query "A" which returns data in the following form: Best Regards, Ivailo Karamanolev - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] UPDATE with join on ROWID

On Sunday, January 21, 2007, 1:17:09 PM, RB Smissaert wrote: > Need to do an UPDATE on one table, based on values in another table where > this other table is joined to the first table on rowid of table 1 = column > value of table 2, so: > UPDATE > table1 > SET col2 = >

Re[2]: [sqlite] Fix for sqlite3.h in version 3.3.10

On Sunday, January 21, 2007, 11:03:32 AM, Florian Weimer wrote: >> Having SQLITE_TRANSIENT point to a real function is perhaps a >> good idea. The problem is such a change would break backwards >> compatibility of the API. Somebody who compiled against an >> older

[sqlite] Re: Re: Table Schema

On Saturday, January 20, 2007, 11:29:51 PM, RB Smissaert wrote: > As said you can run > pragma table_info(table) > in C as a query against the database table and it will give you all the info > you need without any awkward parsing. > RBS > -Original Message- >

[sqlite] 1. Table Schema; 2. Using this list

Mark Richards wrote: > [EMAIL PROTECTED] wrote: > > What is the easiest way to retrieve the structure of a table? The only > > thing i have found so far is by parsing the `sqlite_master`.`sql` > > which seems to be too much coding. I want them as (char** > > column_names), (char **column_types) or

[sqlite] Retrieve Table Structure

What is the easiest way to retrieve the structure of a table? The only thing i have found so far is by parsing the `sqlite_master`.`sql` which seems to be too much coding. I want them as (char** column_names), (char **column_types) or something similar. thanks in advance Ivailo Karamanolev