The basic rule is that the result of any comparison involving a
NULL value (including comparing against another NULL) is NULL.
See the following for the details:
http://www.sqlite.org/nulls.html
Dan.
On Tue, 2007-01-30 at 16:41 -0800, Clark Christensen wrote:
> I've read through numerous discu
On Wed, 2007-01-31 at 20:04 -0600, Jay Sprenkle wrote:
> On 1/31/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > > Please pick a pseudo algorithm of your choice and give us the ability to
> > > seed it?
> > >
> >
> > You already have this capability. Use the redefinably I/O feature
> > to
On Thu, 2007-02-01 at 21:18 +0100, Info wrote:
> If I use the following inner join of 3 tables:
>
> SELECT T1.A
> FROM(T1 INNER JOIN T2 ON T1.A=T2.A) INNER JOIN T3 ON T1.B=T3.B
>
> SQLite returns an error message saying that the column T1.A does not exist.
> If I run this statement on MysQL,
On Sat, 2007-02-03 at 00:53 -0600, P Kishor wrote:
> how do I add a constraint to a column so neither null nor empty
> strings ("") are allowed?
>
create table tbl(col CHECK (col IS NOT NULL AND col != ''));
-
To un
On Wed, 2007-02-07 at 09:37 -0800, Dave Gierok wrote:
> I would like to attach a :memory: database to another :memory: database. How
> is this possible since the ATTACH command requires the database's file name?
>
> ATTACH [DATABASE] database-filename AS database-name
>
> -Dave Gierok
I don't
; like ':memory:2'? Nothing that I've tried works.
> -Dave Gierok
>
> -Original Message-
> From: Dan Kennedy [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 07, 2007 9:56 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ATTACH and :memory: da
On Sun, 2007-02-11 at 22:38 -0800, tolson wrote:
> Hello,
>
> I just finished reading through the help files and I am unclear as to when
> database should be used to prefix the pragma call (i.e. PRAGMA
> [database.]cache_size;).
For pager pragmas not specifying a database where it is optional is
On Tue, 2007-02-13 at 11:58 +0200, DragonK wrote:
> Hi,
>
> I have a table containing a text field, which is UTF-8 encoded data. I want
> to know if I use sqlite3_column_text16() to retrieve the contents
> of the field, would the data be automatically converted to UTF-16, or would
> the character
On Tue, 2007-02-13 at 16:18 +, Paul Simpson wrote:
> rc = (sqlStepAdd)(&pStmt);
rc = (sqlStepAdd)(pStmt);
-
To unsubscribe, send email to [EMAIL PROTECTED]
> wxString getDBVersion = "PRAGMA user_version = 2;";
> rc = (sqlPrepareAdd)(newdb,getDBVersion.c_str(),getDBVersion.length(),
> &pStmt, &pzTail);
>
> if(rc != SQLITE_OK){
> wxString msg;
> msg.Printf(wxT("Can't process database:
> %s"),(sqlErrMsgAdd
On Thu, 2007-02-15 at 11:49 +0100, Pavan wrote:
> Hi,
>
> Can anyone tell me what is the difference between sqlite and sqlite3.
By itself, "sqlite" probably means SQLite version 2. Same concept as
version 3 - a client library to access an SQL database stored in a
single file -, but a different fi
I think with a virtual table all you can do is:
SELECT * FROM vtable WHERE x = 'a' UNION
SELECT * FROM vtable WHERE x = 'b'
Virtual tables cannot supply an index for WHERE clauses of the form
"x IN ('a', 'b')" or "x = 'a' OR x = 'b'" the way normal tables
can.
Dan.
On Fri, 2007-02-16 at
On Sat, 2007-02-17 at 00:38 -0800, Tom Olson wrote:
> Hello,
>
> If a REPLACE INTO statement is executed and the there is an existing row
> that is replaced will sqlite3_last_inserted_rowid return the rowid of the
> record that was changed?
REPLACE INTO doesn't change records. It replaces them. W
On Tue, 2007-02-20 at 00:29 -0500, Jim Crafton wrote:
> If I have a simple table without an index column, and have multiple
> rows with the same data, is it possible to *only* delete one row? In
> other words, is there anything like the LIMIT syntax that's found in
> the SELECT command for DELETEs?
> I'm quite interested in hearing people's reasoning for going the blob route,
> when you have a perfectly good "database" format for "blobs" already (various
> filesystems).
Three technical reasons for me personally:
* Can include blob operations as part of atomic transactions.
* In SQLite
On Sun, 2007-02-25 at 22:48 +0100, Jakub Ladman wrote:
> Dne neděle 25 únor 2007 19:25 Martin Jenkins napsal(a):
> > Jakub Ladman wrote:
> >
> > You want "make -f Makefile.linux-gcc"
> Oh, of course, sorry.
>
> And how to fix this?
>
> [EMAIL PROTECTED] ~/src/sqlite-3.3.13 $ make -f Makefile.linu
On Mon, 2007-02-26 at 11:37 +0100, Jakub Ladman wrote:
> > It's seems a bit strange to me that Makefile.linux-gcc includes tcl in
> > the build by default, but it does. Maybe that should change...
> >
> > If you add "-DNO_TCL" to the OPTS variable in Makefile.linux-gcc this
> > error should go away
On Mon, 2007-02-26 at 09:15 -0500, Samuel R. Neff wrote:
> The SQLite optimization faq [1] mentions a PRAGMA default_temp_store which
> should set temp_store on a per-database level. However this doesn't seem to
> be correct--the official docs [2] don't mention default_temp_store and
> calling "PR
On Mon, 2007-02-26 at 17:05 -0800, Travis Daygale wrote:
> I'll do that. I was troubled enough by that bug report and this new testing
> info to be so motivated. :-)
This would be handy for Tcl developers.
In case you haven't noticed it yet, the SQL quote() function
in func.c will help with th
On Tue, 2007-02-27 at 10:48 +0100, Michael Schlenker wrote:
> Hi all,
>
> for some uses its nice to query the PRAGMA and the sqlite_master table
> with a single query instead of multiple PRAGMA statements.
>
> Could the Pragmas to query the database schema be converted to virtual
> tables? (tha
On Wed, 2007-02-28 at 13:13 +0100, Pavan wrote:
> Hi Lucas,
>
> >Shouldn't it be "sqlite3_open16(L"test.db",&db)" ?
>
> I tried this call. It works. But, the db file is created only with the first
> character name
> and the extenstion is also missing. (its like 't')
>
> Also, can you point to me
On Thu, 2007-03-01 at 05:35 +0100, daan wrote:
> I'm compiling a SQL statement (consisting of multiple statements separated
> by semicolons) using sqlite3_prepare_v2 into a series of sqlite3_stmt
> pointers, later to be executed with sqlite3_step().
>
> A statement such as:
>
> DROP TABLE IF EX
On Thu, 2007-03-01 at 15:13 -0800, jp wrote:
> Hi, I have a custom collation sequence (e.g.
> mycollate). Are there any advantages in terms of
> performance of declaring this collation at the table
> level, instead of just at the index level?
>
> For example, if I have:
>
> CREATE TABLE peopl
On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote:
> I found the nifty ODBC driver for SQLite and have been trying to use
> it to replace a 2.8 SQlite implementation in some desktop software.
> It's working very well except for a rather large problem of not being
> able to call the last_id
On Sat, 2007-03-10 at 14:11 +0900, Brownie wrote:
> Hi,
>
> I have two questions about shared cache mode of SQLite.
>
> 1. When is shared cache of SQLite deallocated?
> A last call of sqlite3_close()? Or end of thread procedure?
The former. The shared cache (and shared schema) are reference
cou
ase of each connections are irrelevant ?
Shared cache mode does not apply to :memory: databases. It is not
currently possible for more than one database handle to access a
single in-memory database.
Dan.
> Regards,
>
> 2007/3/10, Dan Kennedy <[EMAIL PROTECTED]>:
> > On Sat, 20
On Mon, 2007-03-12 at 10:51 +0100, Jef Driesen wrote:
> I was planning to use the sqlite3_update_hook function to notify my GUI
> about changes. The idea was that every part of the GUI can update itself
> when a database change is detected. But during testing, I encountered
> some problems with thi
> My Intentions are towards exploring the reason behind these differences; and
> what can be
> done to counter these performance differences. I'm seeking some pointers
> from the Community.
Version 3 has a different default safety-level (default FULL) to
version 3 (default NORMAL). So if you did
On Tue, 2007-03-20 at 02:44 +0200, Rafi Cohen wrote:
> Hi, I'm calling system from a C application in order to invoke sqlite3
> database, then continue with commands: .separator "," and .import file
> table, all in a single string as argument to system.
> sqlite3 is indeed invoked with the correct
On Fri, 2007-03-23 at 18:53 +0100, stephan nies wrote:
> Hi I read about a "strict affinity mode"
> on http://www.sqlite.org/datatype3.html.
>
> But from searching the net, i get the impression
> that this mode is not yet implemented.
>
> I think it seems to be a FAQ since it is even listed
> in
I think you need 3.3.8 or greater.
On Mon, 2007-03-26 at 07:39 +0200, stephan nies wrote:
> I am using sqlite 3.3.5 .
>
> On 3/25/07, Eric Pankoke <[EMAIL PROTECTED]> wrote:
> >
> > What version of SQLite are you using? I'm not sure the IF EXISTS option
> > was present until a certain version o
On Mon, 2007-03-26 at 17:08 +0200, Vivien Malerba wrote:
> On 3/26/07, Martin Jenkins <[EMAIL PROTECTED]> wrote:
> > Vivien Malerba wrote:
> > > Hi!
> > >
> > > I've got an error reporting problem when trying to insert a row which
> > > breaks a UNIQUE constraint in a table in a C program, I get th
On Wed, 2007-03-28 at 12:27 +0530, Lloyd K L wrote:
> Hi,
> My table contains a text field called Name. Let the data be
>
> Name
> ---
> Abc
> abcd
> AB
> cab
> def
>
> I want to selcct all the rows which contains the term ab (not case
> sensitive). How can I do this?
SELECT name FROM "My
> I am trying to use this query:
>
> SELECT * FROM Files WHERE extension IN ('mp3','avi','ogg');
>
> I am not getting any row back though.
>
> SELECT * FROM Files WHERE extension='mp3' works though.
If this is literally the case, it's probably a bug.
> I am using sqlite3_step to execute a pre
On Wed, 2007-03-28 at 11:11 +0200, Jonas Sandman wrote:
> Yes, it seems so.
>
> Still, can this be done without knowing how many extensions there are on
> beforehand?
> what happens if I make a
>
> SELECT * FROM Files WHERE extension IN (:ext1, :ext2, :ext3, :ext4) and only
> bind :ext1 but not t
> exclusive2-1.7...
> Expected: [1]
> Got: [2]
> exclusive2-1.9...
> Expected: [1]
> Got: [0]
> exclusive2-1.10... Ok
> exclusive2-1.11... Ok
> exclusive2-2.1... Ok
> exclusive2-2.2... Ok
> exclusive2-2.3... Ok
> exclusive2-2.4... Ok
> exclusive2-2.5...
> Expected: [5]
> Got: [3]
>
On Wed, 2007-04-04 at 23:36 -0400, Rich Rattanni wrote:
> On 4/3/07, Rich Rattanni <[EMAIL PROTECTED]> wrote:
> > All:
> >I was wondering exactly how SQLite handles freeing memory used
> > from the heap when compiled without SQLITE_ENABLE_MEMORY_MANAGEMENT?
> >
> >Will absolutely no memory
On Thu, 2007-04-05 at 04:04 -0700, pompomJuice wrote:
> Ok.
>
> I went and re-prepared the statement anyway even though the documentation
> says it won't work. This trick only works if you finalize the failed
> statement after the step command. Otherwhise you keep on getting
> SQLITE_SCHEMA errors
failing for? And are
there any other SQL statements from the same handle active at the
time? Definition of active: have called step() but not finalize()
or reset().
Thanks,
Dan.
> Regards,
> Werner
>
>
>
>
> Dan Kennedy-4 wrote:
> >
> > On Thu, 2007-04-05 at
On Fri, 2007-04-06 at 13:22 -0700, Mike Johnston wrote:
> Hi,
> Is it possible to have memory databases located at a specific memory
> address? I have a battery backed memory I'd like to store specific
> information apart from the main database.
Not really possible at the moment.
An in-memory d
On Mon, 2007-04-09 at 13:02 -0700, Scott Hess wrote:
> Thanks for the concise report. I'm going to take a look at this
> today, to see if it's an fts1/2 problem. If it's _not_, I'll still
> look at it, but perhaps with less eventual success :-).
I checked the code and conflict handling mechanism
On Tue, 2007-04-10 at 09:26 -0700, Scott Hess wrote:
> On 4/10/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
> > I checked the code and conflict handling mechanisms (OR ERROR,
> > OR ABORT, OR REPLACE) do not apply to virtual tables.
>
> > Something to think about
On Tue, 2007-04-17 at 11:53 +0100, Alberto Simões wrote:
> Hi
>
> I've found SQLite faster than MySQL and Postgres for small/medium
> databases. Now I have big ones and I really do not want to change, but
> I have some performance issues.
>
> Consider the following database schema:
> CREATE TABLE
> At first I thought this had solved the problem, because all in house testing
> runs beautifully. However, as soon as the device is sent to the field, the
> error starts again. Unfortunately, it means that I have never been able to
> catch this in debug. I did, however, change the error reporti
On Wed, 2007-04-18 at 11:06 +0100, Alberto Simões wrote:
> On 4/17/07, Alberto Simões <[EMAIL PROTECTED]> wrote:
> > On 4/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > > "=?ISO-8859-1?Q?Alberto_Sim=F5es?=" <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Consider the following database schema:
On Wed, 2007-04-18 at 10:06 -0400, Joel Cochran wrote:
> OK, then I won't be worrying about Transactions for SELECT statements, it
> doesn't really apply to our application.
>
> And some additionaly confirmation that Christian seems to have been right on
> key: according to the problems reported a
On Thu, 2007-04-19 at 13:29 -0500, David A O L wrote:
> I have a very basic sql statement, mainly Im printing it...
>
> static int GuardaActividadEnArchivo(void *arg1, int argc, char **argv, char
> **azColName){
> int i;
> char *nombre, *ok, *ko, *actividad;
> nombre = ok = ko = activi
On Fri, 2007-04-20 at 10:13 +0200, Jens Miltner wrote:
> Am 20.04.2007 um 09:13 schrieb Jens Miltner:
>
> >
> > Am 01.04.2007 um 20:05 schrieb Iulian Musat:
> >
> >>
> >> [EMAIL PROTECTED] wrote:
> >>> [...]
> >>> In past releases of SQLite, we have made available a ZIP archive
> >>> with preproce
> It seems like the use_up_files command must work sometimes, since
> several iterations of the test worked (i.e. 6.1.1 and 6.1.2). I'm not
> sure what to make of the sequence of test failures and successes before
> it finally hangs.
>
> Since the comment indicates that this test is designed f
On Fri, 2007-05-04 at 18:22 -0400, Vitali Lovich wrote:
> Hi,
>
> I was wondering what would be the optimal way to select 1 matching row
> from multiple tables. Here is the scenario.
>
> Multiple tables contain a primary key KEY. If Table1 contains a
> matching KEY, then I want that row from
On Tue, 2007-05-08 at 10:45 +0700, Kirill wrote:
> Good day,
>
> SQLite version 3.3.17
> Enter ".help" for instructions
> sqlite> create table tbl1(t1 varchar(10));
> sqlite> insert into tbl1 values('софт'); - lowChar
> sqlite> insert into tbl1 values('СОФТ'); - upChar
> sqlite> select * from tbl1
On Mon, 2007-05-07 at 12:28 -0700, km4hr wrote:
> Notes on how I got sqlite running on hpux 11.0
>
> To install sqlite on hpux:
> * download sqlite-3.3.17.tar.gz from web site.
> (I unzipped the file on linux using gunzip I think. Then copied
>the tar file to /opt on the unix box. I guess gu
On Wed, 2007-05-09 at 16:18 -0700, Jon Scully wrote:
> Simpler than that. I merely want to attach to two databases (files).
> flash.db contains a set of tables that hold non-volatile data; ram.db
> contains a set of tables that is re-built (volatile) on re-boot -- but
> offers fast, read-only acce
On Sat, 2007-05-12 at 08:02 -0700, Mike Johnston wrote:
> When doing a "select * from foo" and using sqlite3_step() with
> the associated sqlite3_column_xx funcs, is the order of the
> columns in the resultset deterministic?
>
> What is the rule that defines what the order?
> it seems to be th
On Tue, 2007-05-15 at 13:47 +0530, B V, Phanisekhar wrote:
> Hello all,
>
> When I try to prepare the stmt for the query "PRAGMA
> cache_size = ?" I am getting an SQLITE_ERROR.
You can only use '?' in place of an SQL expression. PRAGMA
commands take a literal string, identifier or nu
On Tue, 2007-05-15 at 17:24 -0700, Mike Johnston wrote:
> Absolutely but it seems like duplicate effort if sqlite already has the info.
> Any guess if this is a big deal to put into the source?
Not a big deal at all. But there's no real advantage
to putting this in the core. And it would add a f
On Wed, 2007-05-16 at 11:39 +0530, B V, Phanisekhar wrote:
> Igor,
>
> Assume I have a database of the files/folders.
>
> Let it be
>
> Rowid puid
> 1 1
> 2 2
> 3 3
> 4 5
> 5 7
> 6 8
> 7 10
>
> Assume I have a relation table showing which file is in which folder
>
>
On Thu, 2007-05-17 at 16:54 +0200, Jiri Hajek wrote:
> > The Unicode standard is beside the point. There is lots of code
> > that does not handle charsets and encodings correctly, which can
> > open vulnerabilities to metacharacter injection. (Examples of
> > this class of problem are SQL injection
On Thu, 2007-05-17 at 18:26 -0400, Martin Gentry wrote:
> Can you be a bit more specific? :-) I ask because this is immediately
> relevant to some code I'm writing today, and have been operating on the
> understanding that I should honour the restriction. I'm fine with honouring
> the restrict
> Which in that case whats the point of a shared cache?
> What is it shared against, since all threads must send
> data to the shared server anyways and none may access
> it concurrently.
The idea is to have a single cache shared accessed by
more than one logical connection (read: more than one
erform db access. And all clients are queued and blocked upon the
> single threads message queue.
>
> Thanks,
> Ken
>
>
>
>
> Dan Kennedy <[EMAIL PROTECTED]> wrote:
> > Which in that case whats the point of a shared cache?
> > What
On Tue, 2007-05-29 at 13:11 -0700, Smith1, Robert E wrote:
> Hi,
>
> I am trying to install sqlite3 on Sun Solaris 2.8. I am not root so I
> cannot install to /usr/local. I start configure with
> --prefix=/ptmp/usr/localto try to get it to install to a different
> directory. But I get the sa
On Fri, 2007-06-01 at 10:51 +0100, Mark Gilbert wrote:
> Folks.
>
> My app just crashed in the field randomly after some time running fine.
>
> Thread 12 Crashed:
> 0 libsqlite3.0.dylib0x9406e587 sqlite3pager_get + 390
> 1 libsqlite3.0.dylib0x94054275 sqlite3Bt
On Tue, 2007-06-05 at 13:35 +0200, [EMAIL PROTECTED] wrote:
> I'v read in change log that some stack allocted memory were moved to the
> heap, but I think that there is still to much allocated memory on the stack.
> After creating a table with 2000 columns, jdbc driver created a query that
> run
On Wed, 2007-06-06 at 13:38 +0200, [EMAIL PROTECTED] wrote:
> > There have been some recent changes to try to address this
> > by placing various limits on number of columns, length of
> > SQL expressions, length of SQL statements etc. See:
> >
> > http://www.sqlite.org/cvstrac/fileview?f=sqlite
On Fri, 2007-06-08 at 09:50 +0530, Jimmy Mathew Ambalathuruthel wrote:
> Hi all,
>
> I am working in a porting project of SQLite from windows.
>
> I Could not port the Truncate () function (For Eg: WinTruncate () in
> windows code in the file os_win.c ) as the same logic cannot be applied
> t
On Sun, 2007-06-10 at 16:08 -0700, Brett Keating wrote:
> Well I basically did the following, but not sure it's optimal:
>
> 1) Took 3.3.17 amalgamation
> 2) Took shell.c from 3.3.17 full distribution, and made a target that
> just uses sqlite3.c and shell.c to get the command line tool
> 3) Took
On Tue, 2007-06-12 at 09:56 +0200, weiyang wang wrote:
> Hi Dr.H,
> Yes, I did a clean build in a clean directory( (top)/bld ). and i had run
> 'make clean' before i run the 'make'.
>
> i am wondering whether the lemon tool configuration in my environment is
> well done or not.
>
> thanks in adva
> What exactly happens when I change the cache_size (both increase and
> decrease size)?
A variable is set.
> What happens to the data that's there in the result cache at the time
> when the instruction PRAGMA cache_size = 0 is executed?
Nothing. The aforementioned variable is set to 10 inste
On Thu, 2007-06-14 at 15:08 -0700, Joe Wilson wrote:
> Is there an SQLite 3.x equivalent document for this?
>
> SQLite 2.X Database File Format
> http://sqlite.org/fileformat.html
>
> If not, is this 2.x document worth reading as a background to
> the general structure of the sqlite 3.x file
On Mon, 2007-06-18 at 06:04 -0500, John Stanton wrote:
> Andre du Plessis wrote:
> > How can one optimize the creation of the journal file. The problem is
> > this, for our system which is an event based one each message needs to
> > be insterted and committed to the database (guaranteed), this res
On Tue, 2007-06-19 at 00:46 +0100, Michael Hooker wrote:
> Christian wrote:
>
> >>Best way of doing this is to execute a 'BEGIN IMMEDIATE', copying the
> database file, then executing a 'ROLLBACK' to end the transaction.<<
>
> >>and can be safely copied at the OS level<<
>
> I also have a need t
On Tue, 2007-06-19 at 10:58 +0530, anand chugh wrote:
> Hi
>
> I am having code like this:
>
>rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
>if( rc!=SQLITE_OK ){
> return rc;
>}
>sqlite3_bind_text(pStmt, 1, zKey, -1, SQLITE_STATIC);
>sqlite3_bind_blob(pStmt, 2, zBlob, nB
On Tue, 2007-06-19 at 01:06 -0700, pompomJuice wrote:
> Hello there.
>
> I need some insight into how SQLite's caching works. I have a database that
> is quite large (5Gb) sitting on a production server that's IO is severely
> taxed. This causes my SQLite db to perform very poorly. Most of the tim
On Tue, 2007-06-19 at 09:42 +0200, Roberto Davico wrote:
> Hi all,
>
>I am Roberto and I find a problem using sqlite3 (version: SQLite
> version 3.3.8).
>
>I make a sample db to explain the situation:
>
>1) Create the sample database using command line tool:
>
> sqlite> .schema
> C
> My question is then, if any one connection makes any change to the database
> ( not neccesarily to the huge lookup table ) will all the other connections
> invalidate their entire cache?
Yes. The entire cache, regardless of what table was modified etc.
Dan.
On Tue, 2007-06-19 at 15:39 -0400, Igor Tandetnik wrote:
> Shane Harrelson
> <[EMAIL PROTECTED]> wrote:
> > To use pragmas from code, do I simply prepare them as a regular SQL
> > statement and then execute them?
>
> Yes.
Another thing to note: Some pragmas take effect during
sqlite3_prepare(),
On Tue, 2007-06-19 at 11:51 -0700, Gerry Snyder wrote:
> Michael Hooker wrote:
> > Many thanks for the explanation Dan.
> Ditto the thanks.
> > I suspected the purpose of ROLLBACK was as you say, but couldn't see
> > why it was used here. You point out the "under the hood" difference
> > betwe
On Wed, 2007-06-20 at 11:05 +0200, Andre du Plessis wrote:
> Sorry if I created any confusion there were some code that seemed to
> have called
> Sqlite_reset simultaneously from more than one thread, even though the
> statements were unique for each thread the call to the library was not
> locked.
> Hope that is more clear.
Perfectly. I get it now. As you say in the other post, every
sqlite call needs to be inside the critical section, including
sqlite3_finalize().
Dan.
-
To unsubscribe, send email to [EMAIL P
> Another question: Is it correct that virtual tables can be created using
> Perl but not Tcl? I don't have a current need (with the possible
> exception of FTS1/2, which are already accessible from Tcl), but the
> situation seemed curious. Wondering whether there was an undocumented
> capabil
On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote:
> Is it possible to do this:
>
>
>
>Open DB1
>
>Attatch DB2
>
>
>
>
>
> In DB1 have a trigger that does
>
> Insert into DB2. ?
>
>
>
>
>
> Theoretically it seems possible but we couldn't get it to work. Before I
On Fri, 2007-06-22 at 18:57 +0200, Jiri Hajek wrote:
> Hello,
>
> I wonder whether there are any plans to include internally proper
> Unicode comparisons? Don't get me wrong, I think that it's great that
> SQLite supports custom collations, there's absolutely no problem to
> handle it in internall
On Sat, 2007-06-23 at 10:56 +0200, Jiri Hajek wrote:
> > The reason is as you've surmised. Not all systems have full unicode
> > support (I'm not sure, but if I had to guess, I would say very few
> > systems do). Including an implementation with SQLite would bloat
> > the library to at least severa
On Mon, 2007-06-25 at 17:08 -0500, Andrew Finkenstadt wrote:
> How easy would it be for me to implement a "pragma page_count;" statement
> which returns the CURRENT page count of the database, and is much more
> cross-platform than my attempt to just "check the file size".
Not difficult I would th
On Tue, 2007-06-26 at 17:50 -0400, jose isaias cabrera wrote:
> Greetings.
>
> I have the following db declarations:
>
> SQLite version 3.3.8
> Enter ".help" for instructions
> sqlite> .schema
> CREATE TABLE LSOpenJobs
> (
> id integer primary key, ProjID integer, subProjID, pare
On Sun, 2007-07-01 at 16:31 -0500, Jeff Godfrey wrote:
> Hi All,
>
> Given the following sample data...
>
> ID Name Version
> --- - ---
> 1 name1 0.9
> 2 name1 1.0
> 3 name2 1.2
> 4 name3 1.0
> 5 name3 1.7
> 6 name3 1.5
>
> I need to create a query that will group the
On Mon, 2007-07-02 at 08:51 -0400, Rich Rattanni wrote:
> I think I am incorrectly using the API, which may be leading to my
> segmentation fault...
>
> I have a variable amount (22k -> 1MB) of data, split across several
> blobs to insert into a database. I transactify the process to save
> some
On Mon, 2007-07-02 at 18:46 -0500, Ben Combee wrote:
> This one's in shell.c. In process_input(), zLine is assigned using
>
> zLine = one_input_line(zSql, in);
>
> Usually, you hit the free(zLine) call in one of the code paths before
> repeating the while loop. However, on line 1614
>
>
How are you launching the second program (the one you wrote, not
sqlite3.exe)? It really sounds like you are opening the wrong file.
Try passing the full path to the database file to sqlite3_open().
Failing that, run windows find and search for files of the same
name. There's a good chance you w
On Wed, 2007-07-04 at 09:58 +0200, Jef Driesen wrote:
> Igor Tandetnik wrote:
> > Mario Figueiredo wrote:
> >> I'm a tad bit confused with sqlite3_finalize() usage when the query
> >> fails. As it is, I'm assuming it releases resources and I use it in
> >> this context:
> >>
> >> --
On Wed, 2007-07-04 at 12:37 +0200, Jef Driesen wrote:
> Dan Kennedy wrote:
> > On Wed, 2007-07-04 at 09:58 +0200, Jef Driesen wrote:
> >> Igor Tandetnik wrote:
> >>> Mario Figueiredo wrote:
> >>>> I'm a tad bit confused with sqlite3_finalize(
On Wed, 2007-07-04 at 13:25 +0200, Makavy, Erez (Erez) wrote:
> Hi,
>
> How do I get sources for previous versions? such as 3.3.4.
>
> Thanks,
> Erez.
Do a cvs checkout of the latest sources, as described here:
http://www.sqlite.org/download.html#cvs
Then use the [cvs update] command with
On Thu, 2007-07-05 at 21:08 -0700, Dave Brown wrote:
> I am considering using FTS for a new feature. My question is:
>
> - If I use fts1 (or fts2) now, and then a new version of fts comes out which
> is not backwards compatible, will I at least be able to upgrade users by
> simply deleting the old
On Thu, 2007-07-05 at 18:26 -0300, Bruno S. Oliveira wrote:
> Hi all,
>
> I'm having problems with the sqlite3_step function.
> I have a table with only one record and then I execute the
> sqlite3_step twice (with some processing in between). In the first run
> of the function everything goes fine
On Fri, 2007-07-06 at 07:18 -0700, Mike Johnston wrote:
> I have to join three tables to retrieve bits of data from each. I'm wondering
> if I use a view are there any performance issues vs. issuing the complete 3
> table join query in code.
>
> Also, is it quicker to have sqlite do joins on pri
On Fri, 2007-07-06 at 08:42 -0700, Mike Johnston wrote:
> n Fri, 2007-07-06 at 07:18 -0700, Mike Johnston wrote:
> > I have to join three tables to retrieve bits of data from each. I'm
> wondering if I use a view are there any performance issues vs. issuing
> the complete 3 table join query in co
On Tue, 2007-07-10 at 22:23 -0700, Sweden wrote:
> I have searched many forums without success for the following question:
>
> Is there any possibility to use LIKE operator in a SELECT statment -
> without being case sensitive AND with support for international characters?
> I am using "PRAGMA ca
On Tue, 2007-07-10 at 16:02 -0700, Joe Wilson wrote:
> --- [EMAIL PROTECTED] wrote:
> > "Scott Hess" <[EMAIL PROTECTED]> wrote:
> > > If you have an fts1 table f, you could drop f_term and f_content, but
> > > you won't be able to drop f itself. So you would have to name the
> > > fts2 version of
On Thu, 2007-07-12 at 23:38 -0700, RohitPatel wrote:
> Hi
>
> I have a Question regarding INTEGER PRIMARY KEY (zero value in column) ?
>
> Example table => create table {id INTEGER PRIMARY KEY, name TEXT};
>
> Is it ever possible that value 0 (zero) will be inserted in a column
> declared as
1 - 100 of 1526 matches
Mail list logo