Re: [sqlite] LEMON Examples

2004-08-02 Thread John Cohen
Date: Mon, 02 Aug 2004 23:51:15 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Aha! =) The last suggestion worked great (thanks!). But still, I still have a small problem. It won't accept more than one 'statement'. I know why, but can't fix it. Take a look: $ ./a.out 7 +

RE: [sqlite] Charting data in VB?

2004-08-02 Thread Frederic Faure
>> You will more than likely need a commercial control to do what you are asking Right, but since everyone seems to recommend _against_ the MSChart control that comes free with VB, I was looking for comments on commercial alternatives. There are so many, that I'm a bit lost. >> How are you

RE: [sqlite] Charting data in VB?

2004-08-02 Thread James
You will more than likely need a commercial control to do what you are asking, I can't think of any way to do all of what you are asking easily with what the control comes with. In each way, however, those different chart controls will have their different (or same) methods of accepting data. How

[sqlite] Charting data in VB?

2004-08-02 Thread Frederic Faure
James >> Plain graphs? Saving? Printing? How is data passed to the chart control? Thx for the reply. All the above, I guess. We'd like to add a Output section in our software so that customers can print pretty graphs from some of the data in SQLite, and that includes bars, lines, and pies, as

Re: [sqlite] force unlocking?

2004-08-02 Thread Tito Ciuro
Hello Ara, On 2 ago 2004, at 9:59, Ara.T.Howard wrote: the simplest way to do this is to create a file for each db, say db.lock, and to apply a blocking read/write to this file depending on the intent of your operation. the contents of this file are not important - it is merely used as a mutex

Re: [sqlite] force unlocking?

2004-08-02 Thread Ara.T.Howard
On Mon, 2 Aug 2004, Oliver Harvey wrote: hello all, we have many thousands of sqlite databases reporting 'database is locked'. then your access is occuring at a moment when another process is also using the database in a way that prevents aquiring the correct type of lock. sqlite uses

Re: [sqlite] LEMON Examples

2004-08-02 Thread Doug Currie
Monday, August 2, 2004, 12:49:50 AM, John Cohen wrote: > My problem is the fact I cannot use the start token on the right hand of the > rule. [...] > How can I get this to accept things such as: > 5 + 5 + 5 > 5 + 6 > ? [I have never used lemon, but perhaps something like...] expr := term |

Re: [sqlite] using.NFS + APACHE2.0 + SQLITE, apache enters inifinite loop....

2004-08-02 Thread D. Richard Hipp
Oliver Harvey wrote: > anyone know if these are signficant though - we're seeing them too: > > >> access("/mail_nas1/maildb/69/35/41/rux3/mail.db-journal", F_OK) = -1 ENOENT >> (No such file or directory) > > Every time you try to access an SQLite database, the library checks to see if there is a

Re: [sqlite] concurrent insert?

2004-08-02 Thread Daniel Franke
Am Sonntag, 1. August 2004 17:47 schrieb D. Richard Hipp: > Why don't you post your complete schema (the output of the ".schema" > command in the command-line shell) and the query that you are > running. That will help us to better understand your problem. I assumed I did something really stupid

[sqlite] force unlocking?

2004-08-02 Thread Oliver Harvey
hello all, we have many thousands of sqlite databases reporting 'database is locked'. we are in a production environment with a large volume of data coming through our systems - and need access to those databases! there are no stale nfs locks, to it must be locking at some other level. is

RE: [sqlite] using.NFS + APACHE2.0 + SQLITE, apache enters inifinite loop....

2004-08-02 Thread Oliver Harvey
anyone know if these are signficant though - we're seeing them too: > access("/mail_nas1/maildb/69/35/41/rux3/mail.db-journal", F_OK) = -1 ENOENT (No such > file or directory) -Original Message- From: John Dean [mailto:[EMAIL PROTECTED] Sent: 02 August 2004 08:11 To: [EMAIL PROTECTED]

Re: [sqlite] using.NFS + APACHE2.0 + SQLITE, apache enters inifinite loop....

2004-08-02 Thread John Dean
This looks like a question for the Apache mailing list Regards John Dean co-author of Rekall, the alternative to MS Access - Original Message - From: "반영록" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 02, 2004 7:28 AM Subject: [sqlite] using.NFS + APACHE2.0 +