[sqlite] new callback for needed functions
I think it would be useful to have a function like sqlite3_function_needed called from the parser (or whatever module) to give the application an opportunity to register the needed function seen in a SQL statement. The idea came up from the sqlite3_collation_needed function which registers a callback when a not already registered collation is seen/needed. Having this new function, only the used funtions so far would be registered (like collations) thus saving time and memory. Sqlite internals (func.c) could also benefit from this api. This would speed up the sqlite3_open call (which registers all the built in functions.)
RE: [sqlite] sqlite with visual basic?
Scott Chapman wrote: > Thanks Steve. > > Anyone have guidance on which of these will work (well) with > the latest > version of VB and SQLite? > > Steve O'Hara wrote: >> Check out the WIKI, there's a myriad of possibilities. >> >> >> -Original Message- >> From: >> [EMAIL PROTECTED] >> > [mailto:sqlite-users-return-7016-sohara=pivotal-solutions.co.u > [EMAIL PROTECTED] rg]On Behalf Of Scott Chapman Sent: 11 August 2005 18:43 > To: sqlite-users@sqlite.org > Subject: [sqlite] sqlite with visual basic? > > > I am having a look at Visual Basic Express 2005 Beta. I haven't > programmed VB since version 3.0 on Windows 3.1 many years ago. I > didn't do any database with it then. > > All of my programming these days is in Python with Postgresql or > SQLite. > > Has anyone gotten VB and SQLite working together? > > Are there some examples of this available? > > Scott http://sourceforge.net/projects/adodotnetsqlite google on finisar sqlite.net reid
Re: [sqlite] sqlite with visual basic?
use ags sqlite wrapper it works fine with .net Scott Chapman a écrit : I am having a look at Visual Basic Express 2005 Beta. I haven't programmed VB since version 3.0 on Windows 3.1 many years ago. I didn't do any database with it then. All of my programming these days is in Python with Postgresql or SQLite. Has anyone gotten VB and SQLite working together? Are there some examples of this available? Scott
Re: [sqlite] mixing GROUP and non-GROUP columns in a query
On Aug 11, 2005, at 10:48 AM, Vladimir Zelinski wrote: Sqlite does return some kind of result for incorrect SQL queries. I consider that this is a non-critical bug that should be fixed in future I think I might submit this as a bug, then. Thanks.
Re: [sqlite] mixing GROUP and non-GROUP columns in a query
On Aug 11, 2005, at 10:19 AM, [EMAIL PROTECTED] wrote: In any case, there's no defined way to determine *which* row the non-group data will be returned from, so at best, it's an unreliable query. I was kind of hoping it might be a "compile"-time error. That seems to be what MySQL is doing.
Re: [sqlite] mixing GROUP and non-GROUP columns in a query
On Aug 11, 2005, at 10:19 AM, [EMAIL PROTECTED] wrote: This must be typo. You probably mean that you get back 3|3. Oops. That's right. That's what I get for typing it in by hand :)
Re: [sqlite] sqlite with visual basic?
Thanks Steve. Anyone have guidance on which of these will work (well) with the latest version of VB and SQLite? Steve O'Hara wrote: Check out the WIKI, there's a myriad of possibilities. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of Scott Chapman Sent: 11 August 2005 18:43 To: sqlite-users@sqlite.org Subject: [sqlite] sqlite with visual basic? I am having a look at Visual Basic Express 2005 Beta. I haven't programmed VB since version 3.0 on Windows 3.1 many years ago. I didn't do any database with it then. All of my programming these days is in Python with Postgresql or SQLite. Has anyone gotten VB and SQLite working together? Are there some examples of this available? Scott
RE: [sqlite] sqlite with visual basic?
Check out the WIKI, there's a myriad of possibilities. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of Scott Chapman Sent: 11 August 2005 18:43 To: sqlite-users@sqlite.org Subject: [sqlite] sqlite with visual basic? I am having a look at Visual Basic Express 2005 Beta. I haven't programmed VB since version 3.0 on Windows 3.1 many years ago. I didn't do any database with it then. All of my programming these days is in Python with Postgresql or SQLite. Has anyone gotten VB and SQLite working together? Are there some examples of this available? Scott
Re: [sqlite] mixing GROUP and non-GROUP columns in a query
I noticed this strange behavior on Sqlite since I
started using it. This kind of SQL is not correct and
normally any DB should return an error. For example,
Oracle would return this error: "ORA-00937: not a
single-group group function".
Sqlite does return some kind of result for incorrect
SQL queries. I consider that this is a non-critical
bug that should be fixed in future
Thank you,
Vladimir
--- Will Leshner <[EMAIL PROTECTED]> wrote:
> Say I have a table defined and populated as follows:
>
> CREATE TABLE test (a TEXT);
> INSERT INTO test (a) VALUES ('hello');
> INSERT INTO test (a) VALUES ('hello');
> INSERT INTO test (a) VALUES ('hello');
>
> And I perform the following query:
>
> SELECT rowid,count(a) FROM test
>
> In SQLite I get back:
>
> 3|hello
>
> But in MySQL I get back an error:
>
> #1140 - Mixing of GROUP columns
> (MIN(),MAX(),COUNT()...) with no
> GROUP columns is illegal if there is no GROUP BY
> clause
>
> I'm wondering if MySQL isn't right to treat this as
> an error?
>
[sqlite] sqlite with visual basic?
I am having a look at Visual Basic Express 2005 Beta. I haven't programmed VB since version 3.0 on Windows 3.1 many years ago. I didn't do any database with it then. All of my programming these days is in Python with Postgresql or SQLite. Has anyone gotten VB and SQLite working together? Are there some examples of this available? Scott
Re: [sqlite] mixing GROUP and non-GROUP columns in a query
I would certainly think the way MySQL treats this is correct. SQLite
may be trying to assume what you meant, and interpreting. Which may
confuse the client if they don't know what they're asking.
Will Leshner wrote:
Say I have a table defined and populated as follows:
CREATE TABLE test (a TEXT);
INSERT INTO test (a) VALUES ('hello');
INSERT INTO test (a) VALUES ('hello');
INSERT INTO test (a) VALUES ('hello');
And I perform the following query:
SELECT rowid,count(a) FROM test
In SQLite I get back:
3|hello
But in MySQL I get back an error:
#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP
columns is illegal if there is no GROUP BY clause
I'm wondering if MySQL isn't right to treat this as an error?
--
Scott Baker
Canby Telephone - Network Administrator - RHCE
Ph: 503.266.8253
Re: [sqlite] mixing GROUP and non-GROUP columns in a query
Will Leshner <[EMAIL PROTECTED]> writes:
> Say I have a table defined and populated as follows:
>
> CREATE TABLE test (a TEXT);
> INSERT INTO test (a) VALUES ('hello');
> INSERT INTO test (a) VALUES ('hello');
> INSERT INTO test (a) VALUES ('hello');
>
> And I perform the following query:
>
> SELECT rowid,count(a) FROM test
>
> In SQLite I get back:
>
> 3|hello
This must be typo. You probably mean that you get back 3|3.
> But in MySQL I get back an error:
>
> #1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no
> GROUP columns is illegal if there is no GROUP BY clause
>
> I'm wondering if MySQL isn't right to treat this as an error?
Even sqlite can't quite decide what to do in this case. sqlite3 returns, in
this case, the highest row number (it seems). sqlite2 returns NULL for the
rowid given the same inserts and query.
In any case, there's no defined way to determine *which* row the non-group
data will be returned from, so at best, it's an unreliable query.
(It'd be nice if you got back three rows from the above query:
1|3
2|3
3|3
but that's not what happens with either version of sqlite.)
Cheers,
Derrell
[sqlite] mixing GROUP and non-GROUP columns in a query
Say I have a table defined and populated as follows:
CREATE TABLE test (a TEXT);
INSERT INTO test (a) VALUES ('hello');
INSERT INTO test (a) VALUES ('hello');
INSERT INTO test (a) VALUES ('hello');
And I perform the following query:
SELECT rowid,count(a) FROM test
In SQLite I get back:
3|hello
But in MySQL I get back an error:
#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no
GROUP columns is illegal if there is no GROUP BY clause
I'm wondering if MySQL isn't right to treat this as an error?
[sqlite] sqlite3_step() question
Hi, I'm making a database navigator bar using wxWindows and Sqlite3. How as it can handle a lot of rows, then i need take one row per time. But the user could back or go to a specific record. So, My question is how i query at specific position of a prepared stmt? If a call sqlite3_step() how can I take the old row? I need to use a pointer to all steps of a stmt?? There's the possibility of make a function called sqlite3_step_at_position()?! I need some ideas. Thank's []'s Victor "Só existem 10 tipos de pessoas, as que sabem e as que não sabem binário." __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/
[sqlite] Announcement: ARMed SQLite database library
Hello everybody, below is our announcement about the availibility of an ARM instrumented SQLite database library. In the last month we instrumented the SQLite source to operate with the ARM 4.0 OpenGroup measurement standard. You can find detailed information about ARM on the OpenGroup web-site (See reference section below). We would like to provide the instrumentation to the sqlite community and want to integrate it into the cvs repository if you think thats useful. For any questions or feedback please feel free to contact us. Regards, Stefan -- Stefan Ruppert <[EMAIL PROTECTED]> Web: http://www.ruppert-it.de/ http://www.myarm.de/ Announcement: ARMed SQLite database library === SQLite goes ARM 4.0 --- The popular database engine SQLite [1] now exists in an ARM [2] instrumented version. Therefore any application using the SQLite database can now measure database transaction using ARM 4.0 standard just by replacing the SQLite shared library or by linking against the instrumented archive. The SQLite instrumentation -- Each SQLite database query is measured through the ARM 4.0 instrumentation. Special properties are attached to the transaction measurement like database name and SQL query string. Currently we support SQLite version 2.8.16 used by Qt and the latest main release 3.2.2.For a detailed description please read our SQLite instrumentation [3] web section. For more information or support to the SQLite ARM instrumentation please contact us. Contact --- MyARM GbR Neue Str. 4 63571 Gelnhausen-Roth Germany email: [EMAIL PROTECTED] Web: http://www.myarm.de/ References -- [1] SQLite web site: http://www.sqlite.org/ [2] OpenGroup ARM web site: http://www.opengroup.org/management/arm/ [3] SQLite instrumentation page: http://www.myarm.de/solutions/sqlite.html
