Re: [sqlite] SQLite triggers calling C functions

2004-12-29 Thread D. Richard Hipp
Nathan Conrad wrote: Hi, I am working on a Linux program written in C. I would like to be able to set up a trigger that calls a C function so that my application knows when a certain table has changed so that it can update its UI. Can this be done? Is there sample code somewhere? Use

Re: [sqlite] Are there any plans to support cursors?

2004-12-29 Thread D. Richard Hipp
Jackson, Scott M wrote: Hello, It appears that cursors are not supported in SQLite although there appears to be no mention of this fact in the documentation, lists of unsupported features, etc. Is that correct? Are there any plans to support cursors? The beginnings of support for SQL92 cursor

Re: [sqlite] Are there any plans to support cursors?

2004-12-29 Thread Darren Duncan
At 2:42 PM -0800 12/29/04, Jackson, Scott M wrote: Hello, It appears that cursors are not supported in SQLite although there appears to be no mention of this fact in the documentation, lists of unsupported features, etc. Is that correct? Are there any plans to support cursors? Thank you! Scott

[sqlite] Advice needed for a new group member

2004-12-29 Thread Ahmet Aksoy
Hi, I'm both new to the group, and sqlite. I want to redesign one of my old projects. It is a kind of mapping program, which shows ports on a world map. Map is drawn using geographical coordinates of seashores. Also the coordinates of the ports are used in the program. You can make searches on

[sqlite] Pilgrim seeking wisdom on schemas

2004-12-29 Thread Keith Herold
I am looking for some inspiration on schemas in SQLite. I am trying to decide whether the following is a good idea, because I can't think of a way to do this in SQLite without writing some C++ code. I have a table that consists of warning and error messages that come from two separate (but

Re: [sqlite] A late Christmas gift / early New Year's gift...

2004-12-29 Thread AJ Bourg
I have 6, too. Haven't been able to get rid of them :) If you want them, you're more than welcome to have them. AJ On Wed, 29 Dec 2004 17:03:28 +0100, Nemanja Corlija <[EMAIL PROTECTED]> wrote: > If somebody didn't get an Gmail invite from Joseph, I have 4 more to > offer to SQLite community

Re: [sqlite] A late Christmas gift / early New Year's gift...

2004-12-29 Thread Nemanja Corlija
If somebody didn't get an Gmail invite from Joseph, I have 4 more to offer to SQLite community Cheers, Nemanja On Wed, 29 Dec 2004 07:02:29 -0500, Joseph Stewart <[EMAIL PROTECTED]> wrote: > I'm offering 4 gmail invitations to the first four people on this list > that ask for them. > Thanks

Re: [sqlite] writing results to file in php

2004-12-29 Thread Clay Dowling
D.W. said: > I want to write results of a query in an ascii file. > > In the shell this works: > sqlite> .mode list > sqlite> .separator | > sqlite> .output test_file_1.txt > sqlite> select * from tbl1; > sqlite> .exit > > I tried similar querys in php, but without any success. > It seems that

[sqlite] writing results to file in php

2004-12-29 Thread D.W.
I want to write results of a query in an ascii file. In the shell this works: sqlite> .mode list sqlite> .separator | sqlite> .output test_file_1.txt sqlite> select * from tbl1; sqlite> .exit I tried similar querys in php, but without any success. It seems that Sqlite in php doesn't know the

[sqlite] A late Christmas gift / early New Year's gift...

2004-12-29 Thread Joseph Stewart
I'm offering 4 gmail invitations to the first four people on this list that ask for them. Thanks again for this community! -joe -- Person who say it cannot be done should not interrupt person doing it. -- Old Scottish Proverb