[sqlite] new callback for needed functions

2005-08-11 Thread Miguel Angel Latorre Díaz
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

RE: [sqlite] sqlite with visual basic?

2005-08-11 Thread Reid Thompson
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]

Re: [sqlite] sqlite with visual basic?

2005-08-11 Thread Gregory Letellier
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

Re: [sqlite] mixing GROUP and non-GROUP columns in a query

2005-08-11 Thread Will Leshner
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

2005-08-11 Thread Will Leshner
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

Re: [sqlite] mixing GROUP and non-GROUP columns in a query

2005-08-11 Thread Will Leshner
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?

2005-08-11 Thread Scott Chapman
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

RE: [sqlite] sqlite with visual basic?

2005-08-11 Thread Steve O'Hara
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

Re: [sqlite] mixing GROUP and non-GROUP columns in a query

2005-08-11 Thread Vladimir Zelinski
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

[sqlite] sqlite with visual basic?

2005-08-11 Thread Scott Chapman
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?

Re: [sqlite] mixing GROUP and non-GROUP columns in a query

2005-08-11 Thread Scott Baker
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

Re: [sqlite] mixing GROUP and non-GROUP columns in a query

2005-08-11 Thread Derrell . Lipman
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: > >

[sqlite] mixing GROUP and non-GROUP columns in a query

2005-08-11 Thread Will Leshner
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:

[sqlite] sqlite3_step() question

2005-08-11 Thread victor...
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

[sqlite] Announcement: ARMed SQLite database library

2005-08-11 Thread Stefan Ruppert
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