Re: [sqlite] Implementing aggregate user functions

2004-12-06 Thread Roger Binns
new API function. But I am loath to add new API functions without good reason and I do not consider performance optimization of an exception condition a good reason. So you are going to have to argue very hard to get such a thing implemented. My motivation isn't based on performance, but on

Re: [sqlite] Implementing aggregate user functions

2004-12-06 Thread D. Richard Hipp
Roger Binns wrote: xFinal is always called. That makes life easier. Is it possible to tell if xFinal wants real results back versus there was an error earlier and I only need to cleanup. It is not possible at this time. xFinal called for cleanup purposes only is an exception condition. One

Re: [sqlite] Implementing aggregate user functions

2004-12-06 Thread Roger Binns
xFinal is always called. That makes life easier. Is it possible to tell if xFinal wants real results back versus there was an error earlier and I only need to cleanup. Roger

Re: [sqlite] Implementing aggregate user functions

2004-12-06 Thread D. Richard Hipp
Roger Binns wrote: It isn't 100% clear to me what the semantics are for implementing aggregate user functions. The sqlite3_create_function call shows that they are done via xStep and xFinal callbacks. I assume that xStep is called for each relevant row. When is xFinal called? If xFinal is

[sqlite] Implementing aggregate user functions

2004-12-06 Thread Roger Binns
It isn't 100% clear to me what the semantics are for implementing aggregate user functions. The sqlite3_create_function call shows that they are done via xStep and xFinal callbacks. I assume that xStep is called for each relevant row. When is xFinal called? I would at least assume xFinal

Re: [sqlite] Parameter syntax

2004-12-06 Thread D. Richard Hipp
Tim McDaniel wrote: Sorry if this has been answered previously, but I couldn't find the answer searching the mailing list archive... What are the implemented syntax for specifying parameters in an SQL statement for sqlite3_prepare? Apparently the sqlite3.h header file and the online documentation

[sqlite] Parameter syntax

2004-12-06 Thread Tim McDaniel
Sorry if this has been answered previously, but I couldn't find the answer searching the mailing list archive... What are the implemented syntax for specifying parameters in an SQL statement for sqlite3_prepare? Apparently the sqlite3.h header file and the online documentation are out of sync,

Re: [sqlite] Display Of Numbers

2004-12-06 Thread D. Richard Hipp
Jeff Flowers wrote: I have a database that contains a dollar value column but I have noticed that SQLite drops the trailing zero. For example, "1.50" is displayed as "1.5". I know that it is mathematically equivilent but is there a way to make the second zero appear? I am using SQLite 3.0.8 on Mac

Re: [sqlite] sqlite and windows shares

2004-12-06 Thread Steve D. Perkins
Ditto that... There is no problem using a windows share. On Mon, 06 Dec 2004 17:20:46 +0100, Gregory Letellier <[EMAIL PROTECTED]> wrote: > this works fine on windows, i've use it > > Christian Kienle a écrit : > > > > > Hi all, > > > > I would like to write an app with C++ which uses

[sqlite] Display Of Numbers

2004-12-06 Thread Jeff Flowers
I have a database that contains a dollar value column but I have noticed that SQLite drops the trailing zero. For example, "1.50" is displayed as "1.5". I know that it is mathematically equivilent but is there a way to make the second zero appear? I am using SQLite 3.0.8 on Mac OS X 10.3.6. I am

Re: [sqlite] sqlite and windows shares

2004-12-06 Thread Clay Dowling
Christian Kienle said: > I would like to write an app with C++ which uses sqlite. > We will soon have a windows network here. Is it possible to place the > sqlite database files on one server and to let the client apps access > the sqlite db file through a windows share which is "mounted" like a

Re: [sqlite] commas in columns and temporary tables

2004-12-06 Thread Dennis Cote
Taj Morton wrote: > "The database connection is closed"...means...? If I'm using the > SQLite DLL, when is a connection closed? Is it started when I call > Open, and closed when I call Close (that would mean that a connection > only lasts for one query)... Can you please explain? > Taj, I'm not

[sqlite] Can SQLite access a FileMaker Pro database (Mac OS X)

2004-12-06 Thread Mirna Pena
I like to be able to use SQLite to enter and retrieve data from a FileMaker Pro data base on Mac OS X. Is it possible?

Re: [sqlite] sqlite and windows shares

2004-12-06 Thread Christian Kienle
Thx. On Dec 6, 2004, at 5:20 PM, Gregory Letellier wrote: this works fine on windows, i've use it Christian Kienle a écrit : Hi all, I would like to write an app with C++ which uses sqlite. We will soon have a windows network here. Is it possible to place the sqlite database files on one server

Re: [sqlite] sqlite stored procedure

2004-12-06 Thread Sid Liu
Hi, This probably has been discussed many times. Is it difficult to add stored procedure support in sqlite? Or is there any such plan? What is involved in supporting stored procedure aside from parser change to compile a stored procedure to VM? Sid

[sqlite] sqlite and windows shares

2004-12-06 Thread Christian Kienle
Hi all, I would like to write an app with C++ which uses sqlite. We will soon have a windows network here. Is it possible to place the sqlite database files on one server and to let the client apps access the sqlite db file through a windows share which is "mounted" like a normal drive - like