RE: [sqlite] return table data without fields

That would be true if for example I only had to dump the array to text or Excel or some other simple manipulations, but I have to do quite a few different and complex things with these arrays and it would be much simpler if these arrays didn't have the fields in the first place. Now with the

RE: [sqlite] return table data without fields

Since you know how many columns are in the result set, can't you just ignore the first row when referencing your data? It seems to me at that point you won't have any significant performance penalties. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original

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

[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 same pid? GROUP BY works on whatever rows remain after WHERE test. Igor Tandetnik

Re: [sqlite] Version 3.3.12

On Sat, 27 Jan 2007, Rich Shepard wrote: I have a Slackware-11.0 package available for anyone who wants a copy. It includes the md5 sum for integrity checking. They are available using wget: wget http://www.appl-ecosys.com/temp-files/sqlite3-3.3.12-i486-1rbs.tgz wget

Re: [sqlite] Version 3.3.12

On Sat, 27 Jan 2007, [EMAIL PROTECTED] wrote: Version 3.3.12 is now available on the website I have a Slackware-11.0 package available for anyone who wants a copy. It includes the md5 sum for integrity checking. Rich -- Richard B. Shepard, Ph.D. |The Environmental

Re: [sqlite] enforcing Foreign Keys

So...anyone? On 1/25/07, Martin Jenkins <[EMAIL PROTECTED]> wrote: Dan McDaniel wrote: > Can someone tell me how to unsubscribe. I have sent > two messages to the link and have had no luck thank > you. > --- Mag Gam <[EMAIL PROTECTED]> wrote: > Send a mail to [EMAIL PROTECTED] - it has

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] return table data without fields

Thanks for that information. Taking the first row out of the array will have a big performance penalty as you say as you will have to write a whole new array. I know near enough nil about C, so altering the source will be difficult. Will think of something. Didn't know about the NULL handling and

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

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 SELECT price, sum(count) FROM ( -- your original query here SELECT price, count FROM ... WHERE

[sqlite] Version 3.3.12

Version 3.3.12 is now available on the website http://www.sqlite.org/download.html This version fixes another bug in the IS NULL optimization that was introduced in 3.3.9. And there is an enhancement to PRAGMA integrity_check that limits the amount of output. -- D. Richard Hipp <[EMAIL

Re: [sqlite] return table data without fields

I cannot find a PRAGMA for turning column names on/off either. You may be thinking of ".headers on/off" in the SQLite shell.. I don't think there's a way to turn this off, except rewriting the code for sqlite_get_table (which, thankfully, he's provided). Maybe to include a 4th parameter that

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] Re: An SQL question (Not directly related to SQLite)

[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 10 What I want to do is get unique prices and sum the count of the duplicates, so it gets price | count 3 13

[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]

[sqlite] return table data without fields

Using the VB wrapper dll from Todd Tanner: http://www.tannertech.net/sqlite3vb/index.htm and it has this function to return table rows: Private Declare Function sqlite_get_table _ Lib "SQLite3VB.dll" _ (ByVal DB_Handle As Long, _

Re: [sqlite] Last call for bugs...

>I plan to release 3.3.12 later today or tomorrow. >If you know about any unreported problems, please >get those bug reports in quickly. Tnx. My vote for ticket #2183: It causes SQLite to crash with an access violation. I am keeping my fingers crossed ... Regards, Ralf