: [sqlite] Oracle DECODE
"Drew, Stephen" <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I have written a function to replicate the Oracle DECODE function,
> which I register whenever I open a SQLite3 (3.2.6) connection (see
> bottom of email).
>
> However it s
Hello all,
I have written a function to replicate the Oracle DECODE function, which
I register whenever I open a SQLite3 (3.2.6) connection (see bottom of
email).
However it seems that certain decodes fail due to corrupted data. I
have stepped through my code and seen that the value is correct
http://www.sqlite.org/lockingv3.html
RESERVED
A RESERVED lock means that the process is planning on writing to the
database file at some point in the future but that it is currently just
reading from the file. Only a single RESERVED lock may be active at one
time, though multiple SHARED locks can
er all).
Dunno if that helps any.
Glenn McAllister
SOMA Networks, Inc.
Drew, Stephen wrote:
> Hello all,
>
> An interesting use of the in-memory SQLite database would be to use it
> in shared memory and have the data shared between applications but
> stored once.
Sorry, just noticed this is very similar Mateus' email from earlier, so
will wait for any responses to that...
-Original Message-
From: Drew, Stephen
Sent: 15 February 2006 15:33
To: sqlite-users@sqlite.org
Subject: [sqlite] Shared Memory Question
Hello all,
An interesting use o
Hello all,
An interesting use of the in-memory SQLite database would be to use it
in shared memory and have the data shared between applications but
stored once.
The background to this is I am making local replicated copies of a main
database, and as they are transient (they are read-only copi
message from MS-Word last year when I
tried to print to a PDF-Printer (free space on my disk: 14 GB).
Bye,
Michael
>
> Drew, Stephen wrote:
>
>> John,
>>
>> Thanks for the reply.
>>
>> I disagree - my error message informs my users (who are technone
John,
Thanks for the reply.
I disagree - my error message informs my users (who are technonerds)
that the disk or db file is full, when neither of these is the case.
Surely you can see that even a different constant error message in this
context would be preferable? SQLITE_WRITE_FAILED or somet
:[EMAIL PROTECTED]
Sent: 10 February 2006 17:28
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Database Disk Full
"Drew, Stephen" <[EMAIL PROTECTED]> wrote:
>>
> It's just a little bit misleading if you're not familiar with the
> circumstances it's rai
o people in diagnosing why the file write failed.
Many thanks, and keep up the great work!
Steve
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 10 February 2006 17:01
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Database Disk Full
"Drew, Stephen&
Hello,
In sqlite3OsWrite function (in os_win.c) the following code exists:
while( amt>0 && (rc = WriteFile(id->h, pBuf, amt, &wrote, 0))!=0 &&
wrote>0 ){
amt -= wrote;
pBuf = &((char*)pBuf)[wrote];
}
if( !rc || amt>(int)wrote ){
return SQLITE_FULL;
}
Is this really a
I would be in favour of this, specifically to allow shared memory
database access.
-Original Message-
From: Cariotoglou Mike [mailto:[EMAIL PROTECTED]
Sent: 01 December 2005 00:18
To: sqlite-users@sqlite.org
Subject: [sqlite] Feature request
Hi all. I would like to propose an enchanceme
I think if you set the preprocessor definition NO_TCL it should avoid
compiling tclsqlite.c which includes this file.
-Original Message-
From: Meenakshi K [mailto:[EMAIL PROTECTED]
Sent: 24 November 2005 05:59
To: sqlite-users@sqlite.org
Subject: [sqlite] tcl.h missing in the sourcecode
Yes I use SQLite for replicating a main oracle database.
Occasionally (and I mean occasionally) a schema change in Oracle needs
to be propagated to the SQLite database. So this situation does arise
for me.
-Original Message-
From: Rob Lohman [mailto:[EMAIL PROTECTED]
Sent: 03 November 20
"The first proposal seems to me a very good one and contributes to
clarity in programs. The second one is of dubious value and a poor
tradeoff in my opinion."
Hmm. Perhaps. I currently do this in my wrapper anyway and it's
annoying, so it's not completely devoid of value.
-Original Message-
I'm for both changes...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 03 November 2005 13:18
To: sqlite-users@sqlite.org
Subject: [sqlite] Request for comment: Proposed SQLite API changes
As currently implemented, when an error occurs during sqlite3_step(),
Oracle 9.2
CREATE TABLE ex1(
x INTEGER,
y NUMBER(21,18),
CHECK( xmailto:[EMAIL PROTECTED]
Sent: 02 November 2005 23:31
To: sqlite-users@sqlite.org
Subject: [sqlite] CHECK constraints
In a CHECK constraint, if the expression is NULL (neither true nor
false) does the constraint fail?
I think this is the best solution in the real world, although I agree
with DRH that different division operators are a bad thing.
Surely if somebody wants the result as an integer, they can use
sqlite3_column_int() to pull the result out? Or even write a function
to do whatever rounding they see
econd seems to be a limitation of VS6 - it certainly isn't a
problem in VS7. Can't really think of any neat solution around it
either...
This doesn't concern me, as - as I mention - I use VS7...
Steve
-Original Message-
From: Drew, Stephen
Sent: 19 September 2005 17
Mike,
3.2.6 compiles fine in Visual Studio 7 (.NET 2003). I can give it a go
in my copy of Visual Studio 6 if you like...
Steve
-Original Message-
From: Cariotoglou Mike [mailto:[EMAIL PROTECTED]
Sent: 19 September 2005 10:14
To: sqlite-users@sqlite.org
Subject: [sqlite] problems comp
ny thanks,
Steve
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: 14 September 2005 16:04
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Column Naming Convention (yet again)
Drew, Stephen wrote:
>Hello,
>
>It's that time of the month again - colum
Hello,
It's that time of the month again - column naming convention discussion.
The documentation states quite clearly:
Case 4: short_column_names=OFF and full_column_names=OFF
For this case (which was the default prior to version 3.1.0) the result
is the same as for case 2 for simple queri
Point taken about viruses perhaps, but there are other reasons one might want
to encrypt data - which by its very nature could be related to anything.
For example, in a commercially competitive environment, it might be easy for a
competitor to gain access to files, or even colleagues within t
Hi,
Sorry to ask a stupid question, but how exactly do I get the return
value from this pragma?
Thanks in advance,
Steve
e: [sqlite] database disk image is malformed
On Thu, 26 May 2005, Drew, Stephen wrote:
>Hello,
>
>Assuming there is no external interference, how could one cause this
>error to occur through embedded use of SQLite? And why, following a
>restart of my application, does it not happ
Hello,
Assuming there is no external interference, how could one cause this
error to occur through embedded use of SQLite? And why, following a
restart of my application, does it not happen again immediately? It
seems most odd...
Any clues would be most appreciated. This is SQLite 2.8.15.
R
te help on this if anyone can spare the time. I
need to either move to SQLite 3 or find an alternative. I cannot move
to SQLite 3 if I cannot replicate the behaviour of SQLite 2, even with
pragmas.
Many thanks,
Steve
-Original Message-
From: Drew, Stephen
Sent: 03 May 2005 15:49
To: sqli
anyone can spare the time. I
need to either move to SQLite 3 or find an alternative. I cannot move
to SQLite 3 if I cannot replicate the behaviour of SQLite 2, even with
pragmas.
Many thanks,
Steve
-Original Message-----
From: Drew, Stephen
Sent: 03 May 2005 15:49
To: sqlite-users@sqlite.o
Sent: 03 May 2005 15:26
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Pragmas
On Tue, 2005-05-03 at 15:09 +0100, Drew, Stephen wrote:
> This is not the case for the version of SQLite 3.2.1 I am using. Is
> the documentation incorrect, or am I doing anything wrong?
>
Document
Hello,
Sorry to keep on harping on about this, but the documentation for the
full_column_names pragma states clearly:
"...Normally, such result columns are named
if the SELECT statement joins two or
more tables together, or simply if the SELECT statement
queries a single table."
This is not
This is fine for me too. However, in 3.1.0 neither of these pragmas
appeared to work. Are they fixed in a later release or check-in? Sorry,
but I couldn't find this info on the website.
-Original Message-
From: George Ionescu [mailto:[EMAIL PROTECTED]
Sent: 27 April 2005 14:18
To: sql
Hello,
Has anyone else had any problems getting the column names pragmas
working in SQLite 3.x ?
I can't seem to get them to work, and can't find anything relating to
the latest version on the website.
Thanks,
Steve
-Original Message-----
From: Drew, Stephen
Sent: 06 April 200
Hello,
I've been looking into upgrading to 3.2.1 from 2.8.15 and am still
running into problems with returned column names.
I've written a piece of code to test four scenarios with 2.8.15 and
3.2.1 and these are the results:
Two tables:
CREATE TABLE A_TABLE (col1 INTEGER, col2 INTEGER)
CREATE
Shawn,
"If SQLite is as good as you say, then why is it free?"
Things don't have to cost the earth (or anything at all) to be good!
"If anyone can see the source code, then won't we be venerable to
hackers?"
There is a encryption package available, at a cost.
http://www.hwaci.com/sw/sqlite/pro
rsday, January 27, 2005 9:42 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unable to open database file
Drew, Stephen said:
> Yet Starteam (version control system) is still interfering with the
> file
> - causing unexpected errors while the application is running. Is this
> becau
Hello,
I'm using SQLite 2.8.15
on Windows 2000, and am still getting the error mentioned in the subject
line. It was my understanding that once my application had opened the
database, nothing else could touch it
Yet Starteam (version
control system) is still interfering with the fil
Have you considered using the date functionality supported by SQLite?
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
-Original Message-
From: teoh [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 4:22 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite search by
Sorry Mike, missed half my email out.
I think the change you suggest (sqlite3_column_table) is an interesting
one. It allows the pure column name to be extracted. Then, if the
end-user decides (i.e. there are columns with the same name),
sqlite3_column_table could be called to give a prefix to dis
I must confess that for my purposes I'd prefer the columns to have
prefixes if prefixes were used in the query, or there is more than one
table in the query. In other words:
SELECT A.* FROM A
A.a_col, A.b_col
SELECT * FROM A
a_col, b_col
SELECT * FROM A, B WHERE A.a_col = B.b_col
A.a_col, A.b_co
Kurt,
Apologies. I believe I have also tried:
Exec("PRAGMA full_column_names=1;")
Steve
-Original Message-----
From: Drew, Stephen
Sent: Tuesday, January 25, 2005 4:33 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] SQLite 3.1.0 Column Names
Kurt,
Thanks for the reply.
Kurt,
Thanks for the reply. Assume my pseudo-calls below do the following:
Open: calls sqlite3_open
Exec: calls sqlite3_exec
Query: calls sqlite3_prepare, sqlite3_step, ..., sqlite3_finalize
Close: calls sqlite3_close
And check return values of these functions.
I am doing
Hello,
I have two
tables:
"CREATE TABLE A (a_col
TEXT, PRIMARY KEY (a_col))"
"CREATE TABLE B
(b_col TEXT, a_col TEXT, PRIMARY KEY (b_col))"
I am trying to test the column names returned by the following
query:
SELECT A.*, B.* FROM A, B WHERE A.a_col =
B.a_col
Now whether or not I have
47 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] v2 -> v3 upgrade
On Fri, 21 Jan 2005 14:30:01 -0000, Drew, Stephen <[EMAIL PROTECTED]>
wrote:
> However, with version 3 and its new data types, I can't seem to be
> able to replicate this. It seems as though it will jus
Hello,
I'm trying to upgrade my
wrapper library for SQLite to use version 3. Everything is going well so
far, with one exception.
In Version 2.x, I would
use the data type string which is returned after the column names in call
to sqlite_step(). This allowed me to distinguish dates fro
My viewpoint on this is that $ should be allowed in both table names and
column names and that:
CREATE TABLE ex$1( col$abc INTEGER );
Should work as-is. It does in Oracle SQL.
If other languages/systems use the $ for other purposes, surely they can
(or will be forced to) just avoid using the $
UPPER() behaviour
Drew, Stephen wrote:
> Simon, Thanks for the response. Two points:
>
> 1) The code is in the SQLite library, not my application.
Oh yes - so it is. And in the copy I have here (v3) it does in fact use
"unsigned char *".
> 2) Surely if chars are signed by
-
From: Simon Middleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 18, 2005 12:57 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Strange UPPER() behaviour
Drew, Stephen wrote:
> Hello,
> I was running my application which uses SQLite in debug mode, and I
> noticed some ver
Hello,
I was running my
application which uses SQLite in debug mode, and I noticed some very bizarre
behaviour in this function:
static void upperFunc(sqlite_func *context,
int argc, const char **argv){
char *z;
int i;
if( argc<1 || argv[0]==0 ) return;
z = sqlite_set_result_string(context
Also, the data types (in 2.8.15) do not appear to copy over into the newly
created table...
I had to manually create the table with SQL, then insert into it from the query.
-Original Message-
From: Jakub Adámek [mailto:[EMAIL PROTECTED]
Sent: Monday, December 13, 2004 3:08 PM
To: [EMAIL
Hello,
Is there a similar
function in standard SQLite? I've had a quick scan of the documentation
and it seems like there isn't, but I thought I'd
double-check.
Thanks in
advance,
Stephen Drew
Hi
there,
Sorry to bother you with
a simple question, but where does this reside by default (i.e.
file)?
I have changed my project
to use in-memory temp-store, but the program won't start as the temp store
already exists on disk. I can't locate the file however - I have deleted
the db
Many thanks.
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 1:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] In-Memory Performance Comparisons
Drew, Stephen wrote:
>
> Can anyone tell me (or point me to any documen
Hello
all,
Can anyone tell me (or
point me to any documentation) about the differences in speed between using an
on-disk DB and an in-memory one?
Regards,
Steve
Ah sorry, my mistake.
I think you need to actually call sqlite_step for the DELETE to take
effect though.
-Original Message-
From: Holger Brunck [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 24, 2004 5:59 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Problems with the C interface
> Y
You need a call to sqlite_exec() too.
-Original Message-
From: Holger Brunck [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 24, 2004 5:44 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] Problems with the C interface
Hi,
I'm using sqlite 2.8.12 and have a problem in deleting rows from a
data
Unni,
Try using the VACUUM command:
http://sqlite.org/lang.html#vacuum
Steve
-Original Message-
From: Unnikrishnan Nair [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 17, 2004 3:57 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] .db file size is not changing
Hi all,
I have a sqlite datab
ogress bar (i.e. one that keeps resetting).
-Original Message-
From: Will Leshner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 11, 2004 4:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Row Count
On Aug 11, 2004, at 8:41 AM, Drew, Stephen wrote:
> This will be a big o
Baker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 11, 2004 4:10 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Row Count
SELECT count(*) FROM Table WHERE Foo = 'bar';
Drew, Stephen wrote:
> Hello,
>
> Is there any way to obtain the number of rows returned by a SEL
Hello,
Is there any way to
obtain the number of rows returned by a SELECT statement, before receiving all
the rows returned? I am using the sqlite_exec() / sqlite_step() functions
to return the data, but need to populate a progress bar.
Regards,Stephen Drew
DISCLAIMER: This e-mail and a
er it in anyway?!?
Regards,Stephen Drew
Stephen Drew
Stephen Drew
Stephen Drew
Software Developer
Software Developer
Software Developer
Front Office Development
Front Office Development
Front Office Development
Beauchamp Financial Technology
Limited
tel:
+44 (0)20 74
: Drew, Stephen
Sent: Monday, July 26, 2004 12:39 PM
To: Drew, Stephen; '[EMAIL PROTECTED]'
Subject: [sqlite] RE: Data Types
This seems to be the result of creating a table as:
CREATE TABLE temp AS SELECT * FROM another_table
Surely the datatypes of the original query (SELECT * FROM ano
This seems to be the result of creating a table
as:
CREATE TABLE temp AS SELECT * FROM
another_table
Surely the datatypes of the original query (SELECT * FROM
another_table) should be used for the new table temp?
Regards,
Steve
From: Drew, Stephen Sent: Tuesday, July 20,
2004 5:25
types?
Thanks,
Steve
From: Drew, Stephen Sent: Monday, July 19,
2004 7:09 PMTo: '[EMAIL PROTECTED]'Subject: Data
Types
Hi
there,
I am using the PRAGMA
command "SHOW_DATATYPES=on". However, not all of my queries return the
datatypes. Has anyone else exper
Hi
there,
I am using the PRAGMA
command "SHOW_DATATYPES=on". However, not all of my queries return the
datatypes. Has anyone else experienced this
problem?
Regards,Steve
I agree that minimising the SQL syntax that SQLite doesn't support would be
a good addition to the new release.
Steve
-Original Message-
From: J.W. Janssen [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 2:03 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] Variable sub-queries?
Hi
.
Thanks for your help,
Steve
-Original Message-
From: Tito Ciuro [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 7:58 PM
To: Drew, Stephen
Cc: '[EMAIL PROTECTED]'
Subject: Re: [sqlite] Can't Open Database File
Hello Stephen,
On Jun 10, 2004, at 18:34, Drew
w milliseconds might help?
Regards,
Steve
-Original Message-
From: Tito Ciuro [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 4:13 PM
To: Drew, Stephen
Cc: '[EMAIL PROTECTED]'
Subject: Re: [sqlite] Can't Open Database File
Hi Stephen,
Check this: http://www.sqlite.or
aneously in two or more threads.
Is it still not safe to use the same SQLite structure pointer in two or more
threads if they are protecting against concurrent use?
Regards,
Steve
-Original Message-----
From: Drew, Stephen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 3:38 PM
To:
Hi there,
I am having a problem with accessing my SQLite database.
I have a certain number of worker threads that access the SQLite database,
protected by a critical section.
The database is already open prior to this. Each thread attempts to insert
a row protected by the critical section.
Does SQLite support the subtraction of queries, e.g.
SELECT * FROM TABLE_A
MINUS
SELECT * FROM TABLE_B
Thanks,
Steve
I have it working under Windows 2000 using BCB 6.
-Original Message-
From: Eli Wheaton [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 4:47 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] Using sqlite with C++Builder6
Hi All,
I'm having a problem trying to get SQLite to work with a
,
Steve
-Original Message-
From: Drew, Stephen [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 11:36 AM
To: '[EMAIL PROTECTED]'
Subject: [sqlite] Borland C++ Builder 6
Has anyone any experience of compiling the SQLite library with Borland C++
Builder 6 and it's shi
Has anyone any experience of compiling the SQLite library with Borland C++
Builder 6 and it's shipped version of STLPort?
Regards,
Steve
According to the excellent "Calendrical Calculations" by Reingold &
Dershowitz,
Julian Day 0 = Noon, Monday 1st January 4713 BC (Julian Calendar)
Noon, Monday 24th November -4713 (Proleptic Gregorian
Calendar)
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PRO
So how does SQLite distinguish between the built-in:
{ "like", 2, SQLITE_NUMERIC, likeFunc },
and a user-defined function such as
{ "like", 2, SQLITE_NUMERIC, my_like_function },
then?
-Original Message-
From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
Sent: Tuesday
-Original Message-
From: Drew, Stephen [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 11:05 AM
To: '[EMAIL PROTECTED]'
Subject: [sqlite] Functions & Keywords
Hello,
It is straightforward to define a function in SQLite...such as MY_FUNCTION(
).
Is there an equally simple
resemble Oracle SQL
features.
Thanks in
advance,
Steve
Stephen Drew
Stephen Drew
Stephen Drew
Front Office Development Team
Front Office Development Team
Front Office Development Team
Beauchamp Financial Technology
Limited
tel:
+44 (0)20 7469
8636
email:
[EMAIL PROTECTED
Hello,
It would be very useful to be able to determine which tables are being used
in a given query.
The background is that we are performing a local caching of queries by
caching the underlying tables from an Oracle database in a local SQLite
database.
Given this query:
SELECTA.col_1,
Hi,
Are there any plans to include a DECODE as a standard built-in function in
SQLite? I have written one myself very easily, and it seems to be a nice,
quick feature to add.
Regards,
Steve
79 matches
Mail list logo