Re: [sqlite] sqlite3 command line utility

2011-01-27 Thread jeff archer
From: BareFeetWare list@barefeetware.com Sent: Thu, January 27, 2011 8:50:15 AM > >INSERT INTO "Microscopes" VALUES(null, 'nSpec', 'default'); > >create temp table "Store" (MicroscopeID); > >insert into "Store" select last_insert_rowid(); > >INSERT INTO "Objectives"(ObjectiveID, MicroscopeID, T

Re: [sqlite] sqlite3 command line utility

2011-01-27 Thread BareFeetWare
On 27/01/2011, at 3:30 AM, Jeff Archer wrote: > INSERT INTO [Microscopes] VALUES(@MicroscopeID, 'nSpec', 'default'); > > INSERT INTO [Objectives](ObjectiveID, MicroscopeID, TurretPos, Name, > Description, Magnification, NA, WD) VALUES( 1, @MicroscopeID, 0, '5X' , 'CFI > LU > Plan Fluor BD 5X'

Re: [sqlite] sqlite3 command line utility

2011-01-27 Thread Igor Tandetnik
Jeff Archer wrote: > Is it possible to use parameter binding from the sqlite3 command line utility? No. > In my code I have tried making 1 bind to @MicroscopeID and I have tried it > with > appending the digits 1 to 6 and making 6 calls to bind with same result. You were making these 6 calls t

[sqlite] sqlite3 command line utility

2011-01-27 Thread Jeff Archer
Is it possible to use parameter bindingĀ from the sqlite3 command line utility? I would like to make a small illustration of my problem but it only seems to have an issue with I am doing an insert and using a bound parameter for a column which is a foreign key. I have foreign key on by: PRAGMA fo

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-18 Thread Jens Miltner
Am 15.04.2006 um 00:50 schrieb Thomas Chust: On Fri, 14 Apr 2006, Will Leshner wrote: On 4/14/06, Thomas Chust <[EMAIL PROTECTED]> wrote: I just downloaded the 3.3.5 distribution tarball and confirmed that the problem occurs with a binary built from that codebase as well. I assume you g

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-14 Thread Thomas Chust
On Fri, 14 Apr 2006, Will Leshner wrote: On 4/14/06, Thomas Chust <[EMAIL PROTECTED]> wrote: I just downloaded the 3.3.5 distribution tarball and confirmed that the problem occurs with a binary built from that codebase as well. I assume you guys are refering to the tip, right. If I download

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-14 Thread Will Leshner
On 4/14/06, Thomas Chust <[EMAIL PROTECTED]> wrote: > I just downloaded the 3.3.5 distribution tarball and confirmed that the > problem occurs with a binary built from that codebase as well. I assume you guys are refering to the tip, right. If I download the "stable" 3.3.5 distribution and build

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-14 Thread Thomas Chust
On Fri, 14 Apr 2006, ThomasChust wrote: [...] I'm using the current CVS version of SQLite 3.3.5 on MacOS X and since a few days (unfortunately I don't remember the exact time of the change in the CVS tree that caused it) the sqlite3 command line program always segfaults upon exit [...] Hello

[sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-14 Thread Thomas Chust
Hello, I'm using the current CVS version of SQLite 3.3.5 on MacOS X and since a few days (unfortunately I don't remember the exact time of the change in the CVS tree that caused it) the sqlite3 command line program always segfaults upon exit with a message from the memory allocation libraries