Hallo,
assertions like this (btree.c, line 1043) are bad:
assert( sizeof(ptr)==sizeof(char*) );
The problem better is described here:
http://bugs.kde.org/show_bug.cgi?id=92563
Reporters say that even for intel P4, sizeof pointers is 8, not 4 there. Any
plans for fixing these bugs in official
- Original Message -
From: "Dennis Cote" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 02, 2004 5:25 PM
Subject: Re: [sqlite] new uploads
ok, Denis I have fixed the bug and uploaded the new version of
sqlite3Explorer. thanks for pointing it out.
BTW, I have some
hi-
I am working on making my program for viewing sql statement results and
changing table structure a little nicer. the reason the question came
about below is I thought I'd like to add capability to have more than
one field be the primary key and also would like to add the constraint
unique
Per Jessen wrote:
I've now rebuilt a copy from the CVS and I still get the:
php: src/auth.c:128: sqliteAuthRead: Assertion `pStack!=0' failed.
I didn't rebuild the database though - is it needed?
This cannot be the case since in the latest code from
CVS, there is no assert() on line 128, either in
D. Richard Hipp wrote:
> Per Jessen wrote:
>> I'm running a small php-script in command-line mode - initially everything
>> goes fine until a table in the db reaches around 8700 rows, then I see the
>> assert failing.
>>
>> This is 2.8.15, which I'm using with PHP4.3.8/SQLite-1.0.3. I don't
Per Jessen wrote:
FYI, I tried building from CVS - btree.c doesn't compile with -DNDEBUG.
We have just begun work on some major enhancements to the library.
So issues like this will come up from time to time in CVSHEAD for the
next couple of months. You can either fall back to the previous
Per Jessen wrote:
> D. Richard Hipp wrote:
>
>> This is probably the same as ticket #896 which is fixed in the CVS tree.
>> See:
>
> FYI, I tried building from CVS - btree.c doesn't compile with -DNDEBUG.
> And when I edited the Makefile.in to remove -DNDEBUG, I ended up with:
Did another
D. Richard Hipp wrote:
> This is probably the same as ticket #896 which is fixed in the CVS tree.
> See:
FYI, I tried building from CVS - btree.c doesn't compile with -DNDEBUG.
And when I edited the Makefile.in to remove -DNDEBUG, I ended up with:
./libtool --mode=link gcc -g -O2 -DOS_UNIX=1
Not a whole lot. For the most part, change sqlite_ to sqlite3_, and
add 16 to the end of funcs you want in unicode.
Have you tried using setlocale() to use a swedish codepage?
On Tue, 02 Nov 2004 16:54:40 +, Liz Steel <[EMAIL PROTECTED]> wrote:
> Thanks for your reply, however, wcstombs
Didier BRETIN wrote:
Cmd.CommandText = "ATTACH DATABASE database AS main";
The original memory database is called "main". Choose
a different name.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Dennis Cote wrote:
I think there is a problem with the SQLite web site. The contrib link
(http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a
file not found error from Hurricane Electric.
Please use http://www.sqlite.org/contrib instead. That particular
link should not be
Thanks for your reply, however, wcstombs uses the default code page rather
that UTF8, which is where I was going wrong with using it originally.
Unfortunately, it is unlikely that I will get approval to use libiconv as it
is third-party software.
How much effort is involved with converting to
Well, wcstombs uses WideCharToMultiByte() internally, with some more
locality checks added in. Maybe you are using it wrong?
If you cant get that to work, libiconv is great for converting charsets.
Is there any reason you can't use sqlite 3.x? It has native unicode support.
On Tue, 02 Nov
On Tue, 2 Nov 2004, Liz Steel wrote:
>However, when I call sqlite_open with a multibyte string, it doesn't seem to
>work as I expect.
>
>To clarify: I have a database name with Swedish characters in, which are
>converted to multibyte characters, however, the filename that is created
>treats each
On Tue, Nov 02, 2004 at 01:58:42PM +0100, Didier BRETIN wrote:
> I'm new to SQLite, and I try to know if it is possible to crypt de
> database file used by
> SQLite. I try to find some documentation on this but I found nothing :(.
http://www.sqlcrypt.com
Currently in beta testing. Signups are
Dennis Cote wrote:
Richard,
I think there is a problem with the SQLite web site. The contrib link
(http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a
file not found error from Hurricane Electric.
may is that the link you're looking for:
http://www.sqlite.org/contrib
Ciao
Hi Giuliano,
ISA Informatica a écrit :
Hello,
I downloaded the
ADO.NET Data Provider for SQLite from Finisar
http://sourceforge.net/projects/adodotnetsqlite
but when i start the project i receive always the error message that
a reference is missing... NUnit...
I added the reference, but still
Hi,
D. Richard Hipp wrote :
Gerhard Haering wrote:
On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote:
Hello all,
I wonder if there is a possibility to save (dump) an in-memory
database to file (and vice versa, loading from file) in a fast way?
(Without having to create a new database
Loading shared libraries is easy enough on windows and
Linux, but throw AIX and HPUX and Solaris into the mix
and suddenly things become more complicated. SQLite is
a cross-platform library. It has to work on more than
just windows.
Really? Both these platforms support shared libraries - I use
CARIOTOGLOU MIKE wrote:
> I have uploaded the new version of sqlite3Explorer, which fixes a bug
> with the schema treeview.
Richard,
I think there is a problem with the SQLite web site. The contrib link
(http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a
file not found error
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 02, 2004 4:49 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Join function in select statement
>
>
> CARIOTOGLOU MIKE wrote:
> > Why not provide some extra functionality on one platform
CARIOTOGLOU MIKE wrote:
Why not provide some extra functionality on one platform ?
Because that's not what SQLite does. SQLite works the same
on all platforms.
Note also that were this policy to change and SQLite were
allowed to have extra features on selected platforms, it is
most likely that
On Tue, Nov 02, 2004 at 04:36:41PM +0200, CARIOTOGLOU MIKE wrote:
> [user-defined functions loadable through shared libraries]
> true. OTOH, since, as you say, it *is* simple, why not provide some extra
> functionality on one platform ? it does not affect other platforms, and it
> is s nice to
true. OTOH, since, as you say, it *is* simple, why not provide some extra
functionality on one platform ? it does not affect other platforms, and it
is s nice to have.. it would be an IFDEF thingy, anyway.. of course, you
know best.
> -Original Message-
> From: D. Richard Hipp
Le mardi 2 Novembre 2004 09:36, George Ionescu a ÃcritÂ:
> I'm looking for an sqlite-based bulletin board to run under linux.
> Any recommendations?
All PHP CMS, forum and boards using adodb php class can use sqlite.
Google with sqlite cms
--
JCR
aka DJ Anubis
LAB Project Initiator &
CARIOTOGLOU MIKE wrote:
write a user-defined function in your hosting code. the only problem is,
people that use your database (as opposed to your code), will not be able to
use the function. DRH, what about DLL-loadable functions ? this should be
easy to arrange, and would be of enormous help.
Gerhard Haering wrote:
On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote:
Hello all,
I wonder if there is a possibility to save (dump) an in-memory
database to file (and vice versa, loading from file) in a fast way?
(Without having to create a new database and copying records by
Hello Didier,
Check: http://www.hwaci.com/sw/sqlite/prosupport.html
The second paragraph in particular...
Regards,
-- Tito
On Nov 2, 2004, at 13:58, Didier BRETIN wrote:
Hello,
I'm new to SQLite, and I try to know if it is possible to crypt de
database file used by
SQLite. I try to find some
Hello,
I'm new to SQLite, and I try to know if it is possible to crypt de
database file used by
SQLite. I try to find some documentation on this but I found nothing :(.
Is it possible ?
I would like to use SQLite for my application but if the database file
can be read
by every body it's a bad
On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote:
> Hello all,
>
> I wonder if there is a possibility to save (dump) an in-memory
> database to file (and vice versa, loading from file) in a fast way?
> (Without having to create a new database and copying records by
> select and
Hello all,
I wonder if there is a possibility to save (dump) an in-memory database
to file (and vice versa, loading from file) in a fast way? (Without
having to create a new database and copying records by select and inserts)
Oliver
I have uploaded the new version of sqlite3Explorer, which fixes a bug with
the schema treeview.
Marcel Strittmatter wrote:
Hi all
I like to have a join function that I can use in a select statement like
this:
select join(name, ',') from people;
this should produce something like this:
scott,martin,jones,adams
It is not possible to use perl or another script language. The only
language I
I believe I know what is wrong, it has to do with tables that have implicit
indexes. I will upload a new version in an hour. pls give it a try, and let
me know. if it does not work,
send me your database (zipped).
regards.
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL
Hello Dr. Hipp,
hello sqlite users,
I'm looking for an sqlite-based bulletin board to run under linux. Any recommendations?
Thanks.
Regards,
George Ionescu
35 matches
Mail list logo