I'm trying to compile the latest cvs version of 3.0 on my
AMD64 system and I'm running into this problem.
gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I../sqlite/src -DNDEBUG
-c ../sqlite/src/btree.c -fPIC -DPIC -o .libs/btree.o
gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I../sqlite/src
Thanks for the clarification. I'll need to study the docs on the three
part method and slowly figure it out. A working example sure would
be nice! -- Al
On Mon, 26 Jul 2004 11:21:08 +0100 (BST), Christian Smith
<[EMAIL PROTECTED]> wrote:
> Typed data retrieval is not supported by
On Monday 26 July 2004 6:09 pm, Dennis Volodomanov wrote:
> Hello all,
>
> I just downloaded the whole repository and tried to recompile (v3), but
> in sqliteInt.h there's a header include "config.h" and this file is not
> present anywhere :-(
>
> Am I missing something? I was able to compile fine
Dennis Volodomanov wrote:
Hello all,
I just downloaded the whole repository and tried to recompile (v3), but
in sqliteInt.h there's a header include "config.h" and this file is not
present anywhere :-(
Am I missing something? I was able to compile fine before...
config.h is generated by the
Dennis,
Run 'configure' and then 'make'. The file "config,h" will be created
automatically.
Regards,
-- Tito
On 26 jul 2004, at 21:09, Dennis Volodomanov wrote:
Hello all,
I just downloaded the whole repository and tried to recompile (v3), but
in sqliteInt.h there's a header include "config.h"
Sorry about this one - I forgot that I have to build the source, as
opposed to getting the one already pre-formatted for Windows. :-/
-Original Message-
From: Dennis Volodomanov
Sent: Tuesday, 27 July 2004 11:09 AM
To: [EMAIL PROTECTED]
Subject: [sqlite] where is config.h?
Hello all,
I
Monday, July 26, 2004, 5:46:48 PM, Nuno Lucas wrote:
> Doug Currie, dando pulos de alegria, escreveu :
>> In 3.x column names are available as soon as the query is prepared.
>> See the C API reference at
>> http://www.sqlite.org/capi3ref.html#sqlite3_column_name
> This wasn't implemented in
Dennis Volodomanov wrote:
If I go the easy way and increase the MAX_BYTES_PER_ROW to 4294967296
(for example), will it have any performance effect on the "normal" sized
rows?
No.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Hello all,
I just downloaded the whole repository and tried to recompile (v3), but
in sqliteInt.h there's a header include "config.h" and this file is not
present anywhere :-(
Am I missing something? I was able to compile fine before...
TIA
Dennis
//
Software for animal shelters
Hello all,
I raised the questions below a couple of weeks ago, but didn't receive
an answer, so I'd like to politely ask again :-)
If I go the easy way and increase the MAX_BYTES_PER_ROW to 4294967296
(for example), will it have any performance effect on the "normal" sized
rows?
The idea behind
On Jul 24, 2004, at 6:36 PM, [EMAIL PROTECTED] wrote:
I've been digging through a problem I'm having with spontaneous
crashing with sqlite 3.0.3 on OS X 10.3.4, and finally have it down to
a small amount of demo code.
and here's the code (XCode 1.2 project):
On Jul 26, 2004, at 2:13 PM, Gus Mueller wrote:
What's interesting is that balance_nonroot doesn't call
balance_shallower- it calls balance, and then balance calls
balance_shallower.
Yeah, it looks like a frame header is getting tromped on and confusing
the debugger. I filed it at
Doug Currie, dando pulos de alegria, escreveu :
In 3.x column names are available as soon as the query is prepared.
See the C API reference at
http://www.sqlite.org/capi3ref.html#sqlite3_column_name
This wasn't implemented in 3.0.2, right? (I didn't test 3.0.3 yet)
I believe I tried that (exactly
On Sat, 24 Jul 2004 23:13:53 -0500, Gus Mueller <[EMAIL PROTECTED]> wrote:
> On Sat, 24 Jul 2004 15:36:50 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> > Can another OS X user give this a try, see if it crashes for you? Any
> > ideas what's going on?
>
> I gave it a try, and it crashes
Great!!! Thanks!
Roger.
- Original Message -
From: "Doug Currie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 26, 2004 4:10 PM
Subject: Re: [sqlite] Versions 2.8.15 and 3.0.3 available
>
> Monday, July 26, 2004, 12:33:41 PM, Roger Reghin wrote:
>
> > I also use
When a table is created with "create table as select ...",
version 2.8 does not use any type info from the old table
when creating the new one; all it uses are the column
names. Version 3 uses the type info but doesn't pick up
at least some of the constraints. You can verify all this
with
Drew, Stephen wrote:
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?
See http://www.sqlite.org/cvstrac/tktview?tn=521.
The
On Jul 24, 2004, at 1:32 AM, [EMAIL PROTECTED] wrote:
sqlite> select count(*) from newsgroups where name =
'rec.arts.anime.fandom';
0
sqlite> select count(*) from newsgroups where name like
'rec.arts.anime.fandom';
1
Figured it out: I was using sqlite3_bind_blob(), but if I change to
Monday, July 26, 2004, 12:33:41 PM, Roger Reghin wrote:
> I also use EMPTY_RESULT_CALLBACKS for the same reason Nuno does. And my
> software also needs FULL_COLUMN_NAMES as well. So, no 3.x for me... =(
In 3.x column names are available as soon as the query is prepared.
See the C API reference
Hello Richard.
Please dont remove EMPTY_RESULT_CALLBACKS.
This will make it hard to continue with Callback.
It is a very nessessary part of Callback.
So please dont remove it.
Regards
Erwin Jabor
I also use EMPTY_RESULT_CALLBACKS for the same reason Nuno does. And my
software also needs FULL_COLUMN_NAMES as well. So, no 3.x for me... =(
Roger Reghin.
- Original Message -
From: "Nuno Lucas" <[EMAIL PROTECTED]>
To: "sqlite" <[EMAIL PROTECTED]>
Sent: Monday, July 26, 2004 12:33 PM
> the following exports are missing from sqlite3.def (for windows):
> sqlite3_version
Since this is DATA there are some issues around how to add this.
Various tools expect different things. I would prefer to see the
sqlite3_libversion function added to the C API.
> sqlite3_get_auxdata
>
D. Richard Hipp, dando pulos de alegria, escreveu :
The following pragmas are scheduled to be removed in the future:
EMPTY_RESULT_CALLBACKS
FULL_COLUMN_NAMES
SHORT_COLUMN_NAMES
COUNT_CHANGES
What would be the equivalent to EMPTY_RESULT_CALLBACKS=TRUE then?
I use it to get the
CARIOTOGLOU MIKE wrote:
I am working on a Delphi wrapper of the sqlite3 API. Where should I post the
file when properly tested ?
I'm not sure if you can post files to the wikki or not, but that might
be one place.
I have been thinking of adding some of my delphi source to my webpage,
if/when I
> Is there any way to know the type of the current statement,
> i.e.: select,
> insert, delete, etc?
> I would like to know it to retrieve the sqlite3_changes()
> value after the
> statement has finished to return that value to the user.
>
(almost) what you need :
** Return the number of
CARIOTOGLOU MIKE wrote:
I noticed that the previous version had some PRAGMA's not implemented,
notably
DEFAULT_SYNCHRONOUS (and, I think, also SHOW_DATATYPES, or
EMPTY_RESULT_CALLBACKS, I am not sure).
any changes on this ?
DEFAULT_SYNCHRONOUS no longer exists. The default setting for
I noticed that the previous version had some PRAGMA's not implemented,
notably
DEFAULT_SYNCHRONOUS (and, I think, also SHOW_DATATYPES, or
EMPTY_RESULT_CALLBACKS, I am not sure).
any changes on this ?
I am working on a Delphi wrapper of the sqlite3 API. Where should I post the
file when properly tested ?
You can find it and download for free:
http://www.rosa.nl/Bold2/
It makes experimenting with SQLite in Bold/Eco (Borland) easier.
kind regards
Bert Verhees
Typed data retrieval is not supported by the callback method of execution.
You must use the prepare/step/finalize execution method.
Check out:
http://www.sqlite.org/capi3.html
in particular, the sqlite3_step and related functions in section 2.2
"Executing SQL statements." This section gives the
30 matches
Mail list logo
