: [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 i
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
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
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
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
age 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 a
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
:[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 raised in... I've
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" <[EMAIL PROTECTED]>
Hello,
In sqlite3OsWrite function (in os_win.c) the following code exists:
while( amt>0 && (rc = WriteFile(id->h, pBuf, amt, , 0))!=0 &&
wrote>0 ){
amt -= wrote;
pBuf = &((char*)pBuf)[wrote];
}
if( !rc || amt>(int)wrote ){
return SQLITE_FULL;
}
Is this really a
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
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
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
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:13
To: sqlite-users
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
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 - column naming conven
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
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
Hi,
Sorry to ask a stupid question, but how exactly do I get the return
value from this pragma?
Thanks in advance,
Steve
] 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 happen ag
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.
execute(db, "CREATE TABLE TEST1 (id NUMERIC, data
VARCHAR2);");
execute(db, "CREATE TABLE TEST2 (id NUMERIC, data2
VARCHAR2);");
//query(db, "SELECT * FROM TEST1;");
query(db, "SELECT T1.*, T2.* FROM TEST1 T1, TEST2 T2
WHE
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
: 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?
>
Documentation
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
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:
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 2005 11:57
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)
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.
, 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
> because
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
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,
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
PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] v2 -> v3 upgrade
On Fri, 21 Jan 2005 14:30:01 -, 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 just be treat
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
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 sig
-
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 =
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:
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
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
>
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
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 overhead on really sm
[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 SELECT
> state
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
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 7469
8
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 experienced thi
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?
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.org/cvstrac/wiki?p=MultiThreadin
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: '[EM
,
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 shipped version
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
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:
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
65 matches
Mail list logo
