[sqlite] BUG in SQLite? Still the rowid question

Hi, last time I have posted this bug(?) using an C-API. Here is the same bug(?) using only SQL statements: CREATE TABLE Simple (ID integer primary key, Name text); CREATE VIRTUAL TABLE SimpleFTS USING FTS3 (Name); CREATE TRIGGER DeleteTrigger AFTER DELETE ON Simple FOR EACH ROW BEGIN DELETE F

Re: [sqlite] ANN: SQLite 3.6.16.C#

On 01.08.2009 16:19 CE(S)T, Noah Hart wrote: > This is not a driver, dll, or wrapper. This is a port of the underlying > SQLite software. Hm, yes, but isn't the other C# SQLite assembly also the entire DB engine? I mean, there's no client/server driver; if you can access SQLite files, you already

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

Hi Dan, Sorry, my fault. I'm testing in a 32bits Ubuntu 8.10 system running kernel 2.6.28-15-generic. Thanks. Quoting Dan Kennedy : > On Aug 30, 2009, at 12:23 AM, carlos.tas...@farmerswife.com wrote: > >> Hi Dan, >> >> Yes I can confirm it. As more info here is the size of the so >> >> 40734

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

On Aug 30, 2009, at 12:23 AM, carlos.tas...@farmerswife.com wrote: > Hi Dan, > > Yes I can confirm it. As more info here is the size of the so > > 407348 2009-08-29 19:03 tclsqlite-3.6.17.so Are you using 64-bit linux? Dan. ___ sqlite-users mailing l

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

Hi Dan, Yes I can confirm it. As more info here is the size of the so 407348 2009-08-29 19:03 tclsqlite-3.6.17.so Quoting Dan Kennedy : > > On Aug 30, 2009, at 12:08 AM, carlos.tas...@farmerswife.com wrote: > >> Hi Gerry, >> >> That's the first thing I tested. I downloaded this file: >> http:/

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

On Aug 30, 2009, at 12:08 AM, carlos.tas...@farmerswife.com wrote: > Hi Gerry, > > That's the first thing I tested. I downloaded this file: > http://sqlite.org/tclsqlite-3.6.17.so.gz > > Does anyone else have the same problem? I'm using ActiveTcl 8.5.4. Does [puts $tcl_patchLevel] confirm that y

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

Hi Gerry, That's the first thing I tested. I downloaded this file: http://sqlite.org/tclsqlite-3.6.17.so.gz Does anyone else have the same problem? I'm using ActiveTcl 8.5.4. Thanks. Quoting Gerry Snyder : > Carlos Tasada wrote: >> Hi guys, >> >> I'm trying to use sqlite 3.6.17 from a Tcl sc

Re: [sqlite] Problem invoking php functions from a trigger

On Fri, 28 Aug 2009 19:50:56 +0200, Alejandro Ruiz-Oriol wrote: >Thank's Swithun > >but I still have trouble. > >Ok, I find out how to register functions with >PDO_Sqlite extensions. Just in case someone >is in the same situation, the way to do it is this: > >$dbh = new PDO('sqlite:/whatever.sqli

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

Carlos Tasada wrote: > Hi guys, > > I'm trying to use sqlite 3.6.17 from a Tcl script in Linux, but as soon > as I do "load libsqlite3.so" I get an error: "undefined symbol: > Tcl_CreateObjCommand" > > Testing the script in Windows works fine. > > Anyone knows how to solve it? > > Thanks. > Look

Re: [sqlite] AIX performance

What machine runs AIX and what machine runs Linux and what FS are you using on Linux? Ken wrote: > Im looking for some ideas as to why the performance for a select statement > takes roughly 5 times longer on AIX as on a linux system. > > The disk drive on the aix platform is a 10k scsi vs the 72

[sqlite] Undefined Symbol: Tcl_CreateObjCommand

Hi guys, I'm trying to use sqlite 3.6.17 from a Tcl script in Linux, but as soon as I do "load libsqlite3.so" I get an error: "undefined symbol: Tcl_CreateObjCommand" Testing the script in Windows works fine. Anyone knows how to solve it? Thanks. -- Carlos Tasada Software Developer Farmers W

Re: [sqlite] about journal file

On 29/08/2009, at 06:25, Zhanjun You wrote: > I finally understand do not need to deal with journal file. > But I do not know what circumstances led to the journal file, this > time to > read the database file will fail.What may cause such a thing happen? Google is your friend: typing 'sqlite j

Re: [sqlite] about journal file

> > Zhanjun You wrote: > >> I can not find how to implement the method to deal with journal > >> files > > > > What do you mean by "deal" here? What exactly are you trying to do > > with > > them, that you cannot achieve simply by beginning and then > > committing a > > transaction? > > > > Igor Ta

Re: [sqlite] Viable alternatives to SQL?

Some time ago, I constructed a layer to query a Clipper dBASE. Of course, the user interface wasn't as powerful as SQL but do the work and its use was extremely easy to the profane. Suppose a dialog-box that let select each -selectable to the user- field in the table. After each selection, is s