hi, i'm running fedora core 3 and i need some help cross-compiling
sqlite-3.2.2 for the PPC platform. i have the cross-compiler
toolchain ELDK-3.1.1 installed and, like i've done with other
packages, i ran the following:
$ ../sqlite-3.2.2/configure --host=ppc-linux-gnu \
I have a Python/wxPython application that inserts data in many places into
various tables in a sqlite database. All the inserts work fine except for
the latest one:
autoStartcursor.execute('INSERT INTO baseappstart (SerialNumber, Time,
FUSoftwareVersion, GUISoftwareVersion, NexpertVersion,
On Thu, 23 Jun 2005, Robert P. J. Day wrote:
>
> hi, i'm running fedora core 3 and i need some help cross-compiling
>sqlite-3.2.2 for the PPC platform. i have the cross-compiler
>toolchain ELDK-3.1.1 installed and, like i've done with other
>packages, i ran the following:
>
> $
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I was wondering if there's someone who already implemented the Modified
Preorder Tree Traversal (MPTT) algoritme in SQLite using triggers for
the modifications (insert,update,delete)
If so an example is highly appreciated, if not... well then
> The error returned is OperationalError: near ".", syntax error.
Probably because you need to enclose the version strings in single quotes.
> OperationalError: no such column: finally
Use single quotes around values in the SQL. Contents of double quotes are
interpreted as field names.
Hugh
> "DRH" == D Richard Hipp <[EMAIL PROTECTED]> writes:
DRH> On Wed, 2005-06-22 at 16:37 -0400, Charles Hines wrote:
>> Things seemed to be going rather well at first, but now quite frequently his
>> app is getting the "library routine called out of sequence" error (at
>> seemingly random times
> "Dennis" == Dennis Cote <[EMAIL PROTECTED]> writes:
Dennis> Charles Hines wrote:
>> I've tried using the various PRAGMAs to help debug it (side note: the vdbe
>> ones don't seem to be working for me, even though I compiled with the
>> --enable-debug flag) as well as putting in an sqlite3
While cross-compiling sqlite3.2.1, my Blackfin C compiler gives the
following warning:
".\src\pager.c", line 1342: cc0111: {D} warning: statement is unreachable
assert( rc==SQLITE_OK );
The context is:
/* This loop terminates either when the readJournalHdr() call returns
**
We are looking for beta testers for a new database manager product DragonDB -
MVB Edition. A brief description is given below. If you are interested in
becoming a beta tester, please send the following information to beta @
dragondb.com:
1. Name
2. E-mail address
3. Company
4. Windows version
in the application I'm writting I would make intensive use of BLOB
in fact I have a very simple DB tables.
However most of them have a BLOB column where I would put application defined
data.
The data could easily be over 50K (in fact it would be an in memory .tgz
archive with user text and
On Thu, 23 Jun 2005, Robert P. J. Day wrote:
>On Thu, 23 Jun 2005, Christian Smith wrote:
>
>> On Thu, 23 Jun 2005, Robert P. J. Day wrote:
>>
>> > um ... what appears to be the problem here? certainly, i have the
>> >entire gnu development suite installed, and i've used this incantation
>> >to
I counted the parens, and you're right. It's definitely not reachable.
> I think the compiler is right. I am not familiar with the sqlite3 source
> code, but the break at line 1330 breaks the for() loop at line 1324, NOT
> the while() loop at line 1281. Is that as it is intended, or is it a
>
On Thu, 23 Jun 2005, Christian Smith wrote:
> One of the known problems is that the autoconf part is basically
> unmaintained, and noone has stepped up to take the reigns.
i'm starting to see that. to test a local install, i ran the
configure with "--prefix=/home/rpjday/root" and yet, after a
apparently, it looks like the easiest way to cross-compile sqlite3
for my PPC board will be to just hack the gcc-oriented Makefile. as
it stands, that Makefile has a couple critical omissions for me.
first, it doesn't support building shared libs, which i'd prefer.
also, it's not clear how
On 6/23/05, Robert P. J. Day <[EMAIL PROTECTED]> wrote:
> p.s. as a side note, the whole point of this exercise is to build a
> *really* small footprint DB for an embedded system for which space is
> at a premium, and sqlite came highly recommended.
>
> if anyone has a suggestion as to some
On Thu, 2005-06-23 at 13:47 -0400, Robert P. J. Day wrote:
> in any event, the simplest solution appears to be to just hack up a
> modified makefile to do what i want. thanks for the info thus far,
> i'm sure this isn't the end of it.
>
I hack the Makefile template for all my builds.
I never
> p.s. as a side note, the whole point of this exercise is to build a
> *really* small footprint DB for an embedded system for which space is
> at a premium, and sqlite came highly recommended.
If you look on SourceForge, there is a project called adodotnetsqlite,
On Thu, 2005-06-23 at 14:48 -0400, Mitchell Vincent wrote:
> UPDATE customer_detail SET customer_id = (SELECT customer_id FROM
> customers WHERE customers.customer_name = customer_detail.customer_name);
>
This should work. Are you having problems? You'll
need version 3.1.0 or later.
--
D.
D. Richard Hipp wrote:
On Thu, 2005-06-23 at 14:48 -0400, Mitchell Vincent wrote:
UPDATE customer_detail SET customer_id = (SELECT customer_id FROM
customers WHERE customers.customer_name = customer_detail.customer_name);
This should work. Are you having problems? You'll
need version
On Thu, 23 Jun 2005, Brass Tilde wrote:
> > p.s. as a side note, the whole point of this exercise is to build
> > a *really* small footprint DB for an embedded system for which
> > space is at a premium, and sqlite came highly recommended.
>
> If you look on SourceForge, there is a project
On Thu, 2005-06-23 at 15:32 -0400, Mitchell Vincent wrote:
> Shoot! I meant to say that I need it to work with 2.8.16 (which was the
> entire issue!)..
>
> *crosses fingers* any way to make that happen?
>
Not really. Version 2 is in maintenance - meaning
bugfixes only. All new features go
Hello,
I'm using the TCL binding of sqlite3
One of the columns in my table has a date and time stamp, something like
this:
07/20/2004 01:35:40
06/20/2005 01:37:01
06/20/2005 12:10:07
06/20/2005 12:17:08
06/20/2005 01:35:00
If I want to get all dates that are later than "06/20/2005 01:00:00" I
D. Richard Hipp wrote:
On Thu, 2005-06-23 at 15:32 -0400, Mitchell Vincent wrote:
Shoot! I meant to say that I need it to work with 2.8.16 (which was the
entire issue!)..
*crosses fingers* any way to make that happen?
Not really. Version 2 is in maintenance - meaning
bugfixes only. All
[EMAIL PROTECTED] wrote:
Hello,
I'm using the TCL binding of sqlite3
One of the columns in my table has a date and time stamp, something like
this:
datetimes are sorted as strings, maybe that explains
Bert
07/20/2004 01:35:40
06/20/2005 01:37:01
06/20/2005 12:10:07
06/20/2005 12:17:08
Question...
Two database files, say A & B.
Open A.
Attach B.
Write to a table in A.
Write to a table in B.
During the writes, is the file not being written to locked?
Thanks,
Tim
[23-06-2005 21:32, Robert P. J. Day escreveu]
On Thu, 23 Jun 2005, Brass Tilde wrote:
If you look on SourceForge, there is a project called
adodotnetsqlite, http://sourceforge.net/projects/adodotnetsqlite/,
and the programmers there have mentioned a version of SQLite
compiled for handheld
> ok, i just took a quick look there and, personally, there's
> just a wee bit too much ".vcl" and ".vcp" and ".net" and so
> forth for my comfort level. :-P i'll take a shot at the full
> sqlite and see where that takes me, but i'll keep the
> alternative in mind. thanks.
Understood, I was
[EMAIL PROTECTED] wrote:
Hello,
I'm using the TCL binding of sqlite3
One of the columns in my table has a date and time stamp, something like
this:
07/20/2004 01:35:40
06/20/2005 01:37:01
06/20/2005 12:10:07
06/20/2005 12:17:08
06/20/2005 01:35:00
If I want to get all dates that are later
On Thu, 2005-06-23 at 14:50 -0700, Tim McDaniel wrote:
> Question...
>
> Two database files, say A & B.
> Open A.
> Attach B.
> Write to a table in A.
> Write to a table in B.
>
> During the writes, is the file not being written to locked?
>
No locks are taken on unused databases.
--
D.
Hi
I'm trying to write a SQLite module for BlitzMax (www.blitzmax.com)
and have run in to some difficulty. I've taken the "pure C source"
sqlite-source-3_2_2.zip file and mapped the C functions directly to
Max functions (Max produces *.s code and then uses GCC to compile and
link those and any
Mitchell Vincent wrote:
D. Richard Hipp wrote:
On Thu, 2005-06-23 at 15:32 -0400, Mitchell Vincent wrote:
Shoot! I meant to say that I need it to work with 2.8.16 (which was
the entire issue!)..
*crosses fingers* any way to make that happen?
Not really. Version 2 is in maintenance -
Hi,
I need
to create a unique constraint on a column of type varchar, but it is not case
sensitive by default.
Does any one know how to make a unique constraint case sensitive?
Thanks
and best regards,
Ajay Sonawane
32 matches
Mail list logo