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
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
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
> 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
>
> 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
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.
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',
"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"
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
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.
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
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
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
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
16 matches
Mail list logo