Nathan Kurz wrote:
On Mon, Mar 06, 2006 at 06:24:13PM -0800, Steve Green wrote:
Hi,
I'm hoping that someone can shed some light on the following issue that
I'm seeing. When I attempt to create a temp table using DBD::SQLite (v1.11)
and either SQLite v3.3.3 or v3.3.4, I get the following error:
Hi,
I recompiled sqlite (3.2.7) source in RedHat 9 (I upgrade kernel to
2.4.31). After all, "make test" reports lock test failed, why ? Is
there any option in kernel need to turn on ? Do anyone have the same
problem ?
thank you
yk
It would be interesting to know how the result of Coverity analysis
changes resulting from your fixes.
> I got a login and have studied all 31 defects reported by your
> tool against SQLite. This is a report of my findings:
> You can see my changes at
> D. Richard Hipp <[EMAIL PROTECTED]>
On Mon, Mar 06, 2006 at 06:24:13PM -0800, Steve Green wrote:
> Hi,
>
> I'm hoping that someone can shed some light on the following issue that
> I'm seeing. When I attempt to create a temp table using DBD::SQLite (v1.11)
> and either SQLite v3.3.3 or v3.3.4, I get the following error:
>
> DBD::S
On 3/7/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
> We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs
> our TV Newspaper System. It was running on a PIII-1GHz but due some
> shifts for rendering performance increase (Inkscape SVG -> PNG) we moved
> the complete
Okay, here's a strange one. I have sqlite dbs for every day of the week.
Every db is the same (contains 4 tables) as far as structure goes.
Is there a method from the command line (on a win32 box) that I can use the
sqlite.exe to merge 10 days (so 10 dbs) worth of data into a single "master"
Hi,
I'm hoping that someone can shed some light on the following issue that
I'm seeing. When I attempt to create a temp table using DBD::SQLite (v1.11)
and either SQLite v3.3.3 or v3.3.4, I get the following error:
DBD::SQLite::db do failed: not an error(21) at dbdimp.c line 398 at
With t
Hi James!
Even though I dragged the entire directory, os.c and shell.c were the
only two files no included in the project. Weird...
Thanks so much!
-- Tito
On 06/03/2006, at 17:11, James W. Walker wrote:
Tito Ciuro <[EMAIL PROTECTED]> wrote:
When I create an Xcode project in Mac OS X and
Tito Ciuro <[EMAIL PROTECTED]> wrote:
When I create an Xcode project in Mac OS X and put all the SQLite
files there, it doesn't compile:
ld: warning prebinding disabled because of undefined symbols
ld: Undefined symbols:
_sqlite3OsCheckReservedLock
_sqlite3OsClose
_sqlite3OsFileSize
_sqlite3Os
Hello Marcel,
I should have been more specific. Sorry about that: when I ./
configure and then make, everything is fine. It passes all the tests.
Cool. When I create an Xcode project in Mac OS X and put all the
SQLite files there, it doesn't compile:
ld: warning prebinding disabled because
Hello,
I open one connection to a sqlitedb and do a few successful autocommited
sqlite3_exec() calls.
Then I want to use the db handle to call another sqlite3_exec() with SQL
code for a transaction.
Before I close the connection I call again sqlite3_exec() with SQL
COMMIT to end the transaction.
Hello,
the SQLite3 bindings got a big update and now support user defined
collation sequences and SQL functions written in Scheme. They also do
automagical recompilation of stale statements now.
For technical reasons I had to break the "valid NULL statement" workaround
for these changes, tho
Boris Popov wrote:
I didn't get much traction on this issue last time around, so I apologize to
those who may think my persistence is annoying.
Why is it that this works,
SELECT DISTINCT * FROM (SELECT t1.ID, t1.STREET, t1.HOUSE_NUM
FROM GR_ADDRESS t1
WHERE t1.ID = 1 UNION ALL SELECT t1.ID, t1
Ben Chelf <[EMAIL PROTECTED]> wrote:
>
>So I'm basically asking for people who want to play around with some
> cool new technology to help make source code better. If this interests
> you, please feel free to reach out to me directly. And of course, if
> there are other packages you care about
Tito Ciuro <[EMAIL PROTECTED]> wrote:
> Hello,
>
> On 06/03/2006, at 12:44, [EMAIL PROTECTED] wrote:
>
> > I build the OS-X version for the website on Tiger using
> > the ./configure script in the TEA version of SQLite. You
> > might try it as a work-around.
> >
> > http://www.sqlite.org/sqlite-
Hello,
On 06/03/2006, at 12:44, [EMAIL PROTECTED] wrote:
I build the OS-X version for the website on Tiger using
the ./configure script in the TEA version of SQLite. You
might try it as a work-around.
http://www.sqlite.org/sqlite-3.3.4-tea.tar.gz
I get a "document not found" error.
Thanks,
Hello Manfred,
On 06/03/2006, at 12:43, Manfred Bergmann wrote:
What source package did you download?
http://www.sqlite.org/sqlite-3.3.4.tar.gz
Were these files missing bevor configure and make, too?
Yes.
Thanks,
-- Tito
Hi Derrell,
On 06/03/2006, at 12:11, [EMAIL PROTECTED] wrote:
First guess would be that 'configure' isn't detecting that OS X is
Unix-like.
I suspect you might get a hint of what's going on if you carefully
inspect the
output from 'configure' to see what supported OS it's detecting (if
any
I didn't get much traction on this issue last time around, so I apologize to
those who may think my persistence is annoying.
Why is it that this works,
SELECT DISTINCT * FROM (SELECT t1.ID, t1.STREET, t1.HOUSE_NUM
FROM GR_ADDRESS t1
WHERE t1.ID = 1 UNION ALL SELECT t1.ID, t1.STREET, t1.HOUSE_NU
[EMAIL PROTECTED] writes:
> Jarl Friis <[EMAIL PROTECTED]> wrote:
>> What does does it mean when sqlite3_prepare() returns SQLITE_ROW.
>>
>> It seems like this is just another valid (successful) return code from
>> sqlite3_prepare().
>>
>> Can anyone ellaborate on this? please.
>>
>
> sqlite3_p
Hi
On my PowerMac G4 with Tiger 10.4.5 (Build 8H14), it works.
You can download an archive with finished configure and make steps
from the following address:
http://www.dinoware.com/mailinglists/sqlite-3.3.4.tar.gz
You can look at the configure.log and make.log files to check for
differenc
Tito Ciuro <[EMAIL PROTECTED]> wrote:
> Hello,
>
> SQLite 3.3.4
> Mac OS X Tiger 10.4.5
>
> After ./configure and make SQLite 3.3.4, I see that some files have
> disappeared:
>
> os_test.c
> os_test.h
> os_unix.h
> os_win.h
>
> This results in a few undefined symbols:
>
> sqlite3OsClose
> sq
Hi.
I haven't had any problems compiling under Mac OSX 10.4.5. Even
making a universal binary was no problem at all, except that the
"normal" (not the tcl) install process does not work properly and I
had to link all object files myself with libtool.
What source package did you download? We
Jarl Friis <[EMAIL PROTECTED]> wrote:
> What does does it mean when sqlite3_prepare() returns SQLITE_ROW.
>
> It seems like this is just another valid (successful) return code from
> sqlite3_prepare().
>
> Can anyone ellaborate on this? please.
>
sqlite3_prepare() should never return SQLITE_ROW
What does does it mean when sqlite3_prepare() returns SQLITE_ROW.
It seems like this is just another valid (successful) return code from
sqlite3_prepare().
Can anyone ellaborate on this? please.
Jarl
--
Jarl Friis
Softace ApS
Omøgade 8, 2.sal
2100 København Ø.
Denmark
Phone: +45 26 13 20 90
E
Tito Ciuro <[EMAIL PROTECTED]> writes:
> Hello,
>
> SQLite 3.3.4
> Mac OS X Tiger 10.4.5
>
> After ./configure and make SQLite 3.3.4, I see that some files have
> disappeared:
>
> os_test.c
> os_test.h
> os_unix.h
> os_win.h
>
> This results in a few undefined symbols:
>
> sqlite3OsClose
> sqlite3
Hello,
SQLite 3.3.4
Mac OS X Tiger 10.4.5
After ./configure and make SQLite 3.3.4, I see that some files have
disappeared:
os_test.c
os_test.h
os_unix.h
os_win.h
This results in a few undefined symbols:
sqlite3OsClose
sqlite3FileSize
sqlite3OsLock
...
Any ideas?
Thanks,
-- Tito
Hello,
We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs
our TV Newspaper System. It was running on a PIII-1GHz but due some
shifts for rendering performance increase (Inkscape SVG -> PNG) we moved
the complete application to an AMD64.
The last weeks it seems the databas
[EMAIL PROTECTED] wrote:
Dennis Cote <[EMAIL PROTECTED]> wrote:
It is worth noting that SQLite's behavior is not completely consistent.
If the column is declared to be an 'integer primary key', then SQLite
will insert a "default" value even when the user explicitly supplies a
NULL value in
I've read that message and spent a lot of time trying to figure out
why my code was broken, only to find out it wasn't my code. It was
annoying enough I remembered it ;)
Good luck
On 3/6/06, cstrader <[EMAIL PROTECTED]> wrote:
> Yes, was that ever obvious. My dependency checker just didn't pick
Yes, was that ever obvious. My dependency checker just didn't pick it up.
Thanks, Jay!!
On 3/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Dennis Cote <[EMAIL PROTECTED]> wrote:
> >
> > It is worth noting that SQLite's behavior is not completely consistent.
> > If the column is declared to be an 'integer primary key', then SQLite
> > will insert a "default" value even when the
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> It is worth noting that SQLite's behavior is not completely consistent.
> If the column is declared to be an 'integer primary key', then SQLite
> will insert a "default" value even when the user explicitly supplies a
> NULL value in an insert statement
Thomas Chust wrote:
On Fri, 3 Mar 2006, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
Is the DEFAULT value for a column suppose to replace
an explicit NULL value? Or does the DEFAULT value only
get used if no values for an insert is specified? What
is the correct SQL behavior?
SQLite
> > > Can anyone help me with creating temporary tables in place of the views,
> > > which are available during runtime, which have the same fields and data
> > > as my view such that when one table is updated, the results are appended
> > > to the temporary table
> >
> > Why not just insert the co
The reason i am using views is that these tables change very often so if
i create the temp table, i do not know if it will be updated after the
original table is updated
On Mon, 2006-03-06 at 07:56 -0600, Jay Sprenkle wrote:
> > Can anyone help me with creating temporary tables in place of the vi
Do you get the message 'the dll or one of it's component's can't be found'?
If so, check that all the required pieces (the sqlite dll), are either
in the current app
run directory, or the windows directory
> Can anyone help me with creating temporary tables in place of the views,
> which are available during runtime, which have the same fields and data
> as my view such that when one table is updated, the results are appended
> to the temporary table
Why not just insert the content of the view into
Hello everyone.
I am using sqlite to create a web application. I am currently in the
process of writing reports using Agata.I had created views because i had
some tables whose rows i had to concatenate in order for the reports to
make any sense.
But the problem i have now is that Agata does not w
that doesn't seem to be it - I have the same problem with this code.
#include
#include
#define _SQLITE3_H_ extern "C"
#define PLUGINAPI2 extern "C"
PLUGINAPI2 typedef struct sqlite3 sqlite3;
PLUGINAPI2 int sqlite3_open(
const char *filename,
sqlite3 **ppDb
);
PLUGINAP
=?iso-8859-1?Q?Thomas_R=F8nshof?= <[EMAIL PROTECTED]> wrote:
> Is there a maximun for how many chars I can put in a VARCHAR ?
>
http://www.sqlite.org/faq.html#q11
--
D. Richard Hipp <[EMAIL PROTECTED]>
Is there a maximun for how many chars I can put in a VARCHAR ?
I could use a field at about 1024 chars.
Med venlig hilsen / Best regards
Thomas Rønshof
Kyborg A/S
Ermelundsvej 132
DK-2820 Gentofte
Tel: +45 39 66 88 30
Fax: +45 39 55 15 29
E-mail: [EMAIL PROTECTED]
--
-
42 matches
Mail list logo