I second that...
- Original Message -
From: "EzTools Support" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 22, 2004 12:58 AM
Subject: [sqlite] Need Type info with Views
> Hello DRH. This is further to the previous query regarding no type
> information being re
I am using a parametric sql statement, with parameters of the form :Name
The following routines give an access violation, when called via the windows
dll:
sqlite3_bind_parameter_name
sqlite3_bind_parameter_index
The access violation indicates that a NULL pointer is being accessed.
A brief look a
Hello all,
Is it possible to have some sort of a zip-unzip (compress-uncompress)
function built-in when writing/reading the SQLite v3 databases, like the
encode()/decode() functions were in v2? Has anyone implemented this? Is
it available, for example, like the encryption at a charge?
If nobody
Hello DRH. This is further to the previous query regarding no type
information being returned with Views. I had previously asked if this
could be added, but have not received any comment.
I'm sure anyone would agree that getting the column type data type back
with views is no less important t
> But I think the gist of you email is that you'd prefer the "INSERT OR
> REPLACE" to be handled like an update. I can't see a reason why an OLD
> record could be created for replace inserts. The problem then becomes how
> do you know in the trigger whether OLD is valid? If the insert is a
> straig
> CREATE TABLE table (ID text UNIQUE, Name text, Surname text, SecDbKey text)
> INSERT INTO table VALUES ('001', 'John', 'Smith', 'A0B1C2D3')
> INSERT OR REPLACE INTO table VALUES ('001', 'Jane', 'Parker', 'E4F51234')
I'm not sure exactly what relationship you're trying to maintain
between this ta
On Tue, September 21, 2004 11:26, Christian Smith said:
> On Tue, 21 Sep 2004, Alex wrote:
>
> In which case it might be better to convert the replace insert into an
> update, and use the update trigger which is guaranteed to have valid OLD
> and NEW.
>
> But that is not my decision to make. Crea
On Tue, 21 Sep 2004, Alex wrote:
>Hi, Christian
>
>Thanks for your response. The situation, however, is more complicated.
>Please, consider an example in SQL:
>
>CREATE TABLE table (ID text UNIQUE, Name text, Surname text, SecDbKey text)
>
>INSERT INTO table VALUES ('001', 'John', 'Smith', 'A0B1C2
Alex wrote:
> Hi, Christian
>
> Thanks for your response. The situation, however, is more complicated.
> Please, consider an example in SQL:
>
> CREATE TABLE table (ID text UNIQUE, Name text, Surname text, SecDbKey
> text)
>
> INSERT INTO table VALUES ('001', 'John', 'Smith', 'A0B1C2D3')
>
> INSERT
"Alex" <[EMAIL PROTECTED]> writes:
> CREATE TABLE table (ID text UNIQUE, Name text, Surname text, SecDbKey text)
>
> INSERT INTO table VALUES ('001', 'John', 'Smith', 'A0B1C2D3')
>
> INSERT OR REPLACE INTO table VALUES ('001', 'Jane', 'Parker', 'E4F51234')
>
> In the given example the "UNIQUE" con
Hi, Christian
Thanks for your response. The situation, however, is more complicated.
Please, consider an example in SQL:
CREATE TABLE table (ID text UNIQUE, Name text, Surname text, SecDbKey text)
INSERT INTO table VALUES ('001', 'John', 'Smith', 'A0B1C2D3')
INSERT OR REPLACE INTO table VALUES
This question is for DRH, mostly, but anybody who feels they know the
internals sqlite, pls answer :
I normally want to operate in synchronous=FULL mode. However, at some point
in time, I would like to turn synchronous OFF,
do a batch operation, and then turn synchronous to FULL again. This is eas
On Tue, 21 Sep 2004 08:58:22 -0400, Doug Currie <[EMAIL PROTECTED]> wrote:
Tuesday, September 21, 2004, 6:04:53 AM, Peter wrote:
Hello all, I've been using MinGW to compile SQLite for
over a year already and encountered a problem I've never
seen before when trying to compile SQLite 3.0.7.
There is
Tuesday, September 21, 2004, 6:04:53 AM, Peter wrote:
> Hello all, I've been using MinGW to compile SQLite for
> over a year already and encountered a problem I've never
> seen before when trying to compile SQLite 3.0.7.
There is a problem in the Makefile in 3.0.7, fixed in CVS yesterday.
Windo
On Sun, 19 Sep 2004, Alex wrote:
>Hi,
>
>The point is that if the OR REPLACE clause is specified, INSERT may
>overwrite an existing row instead of inserting a new one. In this case the
>appropriate record in the secondary db must be deleted. However, I cannot do
>it because OLD is not available in
On Tue, 21 Sep 2004 13:15:52 +0200, Martins Mozeiko <[EMAIL PROTECTED]> wrote:
Did you try googling for "pthreads win32": http://sources.redhat.com/pthreads-win32/
If you want thread safety with sqlite then you must install this pthreads library,
if not - then just rerun ./configure with --disable-
Did you try googling for "pthreads win32": http://sources.redhat.com/pthreads-win32/
If you want thread safety with sqlite then you must install this pthreads library,
if not - then just rerun ./configure with --disable-threadsafe
Peter Bartholdsson wrote:
> Hello all, I've been using MinGW to co
Hello all, I've been using MinGW to compile SQLite for
over a year already and encountered a problem I've never
seen before when trying to compile SQLite 3.0.7.
The error message is as follows:
$ mingw32-make
./libtool --mode=link gcc -g -O2 -DOS_WIN=1 -I. -I../src -DNDEBUG -DHAVE_READLINE=1
-I/mi
Hi!
I have a database with one table and around 3 records. When I execute
SELECT id,title,like(title,'%city') as mc FROM m;
sqlite spends around 180 ms to execute, but if I continue to exec same
statement it starts to loose speed.
Using it on a windows.
Same thing with Sqlite 2.8.15 and with S
Thank you, I am looking forward to it. The Sqlite-Wince is really
useful, I only copy it to my directory and compile on Win32, WinCE,
Linux and QNX.
Jakub
Nuno Lucas wrote:
Jakub Adamek, dando pulos de alegria, escreveu :
That's GREAT ! Nuno, are you going to merge Sqlite-Wince STABLE ?
I'll do
20 matches
Mail list logo