Re: [sqlite] C Code in a trigger supported in 3.3.x?

Solved. Bug in my code. Sorry for the alarm. Russell Leighton wrote: Update. I actually have 2 nearly identical triggers as described below. One works, the other produces "shifted" output...it appears that the sqlite3_column_xxx() functions are returning the wrong data when executing in

Re: [sqlite] TCLSQLITE3: Problem inserting a variable in a eval command

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - - Original Message - From: "Jan Kandziora" <[EMAIL PROTECTED]> To: Sent: Wednesday, January 25, 2006 9:05 PM Subject: Re: [sqlite] TCLSQLITE3: Problem inserting a variable in a eval command > Am Mittwoch, 25.

[sqlite] Copy tables from one memory database to another with no disk access?

Hello, Is it possible to copy tables from one memory database to another without going through an intermediate disk database? Thanks, -Randy

Re: [sqlite] page size and record packing

Thank you. On 1/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > deminix <[EMAIL PROTECTED]> wrote: > > I was curious if a single page of the database was limited to at most > one > > record, aka can records be packed into a single page? > > Multiple small records can fit on one page. Or

Re: [sqlite] page size and record packing

deminix <[EMAIL PROTECTED]> wrote: > I was curious if a single page of the database was limited to at most one > record, aka can records be packed into a single page? Multiple small records can fit on one page. Or a large record can span multiple pages. > > If it does pack records, then the

Re: [sqlite] sqlite and index

Klaus Schären wrote: Hi i have the following table definition: CREATE TABLE Pistor (Nummer INTEGER PRIMARY KEY NOT NULL, Artikel TEXT NOT NULL DEFAULT '', Inhalt TEXT NOT NULL DEFAULT '') In addition, I have created the following index: CREATE UNIQUE INDEX xPistor ON PISTOR(ARTIKEL, NUMMER)

[sqlite] TCLSQLITE3: Problem inserting a variable in a eval command

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, everybody: First let me say that I'm no expert neither with TCL nor with SQLite. I'm trying to convert the underlying database of a TCL script to SQLite. I'm using 3.2.3 (also tried 3.2.8 with the same result) I don't think that all the

Re: [sqlite] GUID in place of AUTO_INCREMENT

On Jan 25, 2006, at 10:00 AM, Kurt Welgehausen wrote: ... but Rails doesn't seem to support composite keys. I don't know much about RoR. How does RoR keep you from creating a multi-column key on an SQLite table? Regards In point of fact, it doesn't prevent me from *creating* a multi-

Re: [sqlite] GUID in place of AUTO_INCREMENT

Mike Ashmore <[EMAIL PROTECTED]> wrote: > So, I've got what I think is a good reason to modify the behavior of > primary keys in my (Ruby on Rails-based) application. > > What I need is a modifier, say 'GUID', that can be applied in place > of (mutually exclusive with) the AUTOINCREMENT

Re: [sqlite] GUID in place of AUTO_INCREMENT

> ... but Rails doesn't seem to support composite keys. I don't know much about RoR. How does RoR keep you from creating a multi-column key on an SQLite table? Regards

[sqlite] GUID in place of AUTO_INCREMENT

So, I've got what I think is a good reason to modify the behavior of primary keys in my (Ruby on Rails-based) application. What I need is a modifier, say 'GUID', that can be applied in place of (mutually exclusive with) the AUTOINCREMENT modifier [1]. On a field with the GUID modifier, if