Hmmm. The number of warnings compiling the 3.3.1 source is up to 10
from 6 in the 3.3.0 source. All of them appear to be related to
inappropriate sign comparisons/assignments.
-ken
Thank you, kind sir. Sometimes it is difficult to see the individual
ferns on the floor of the massive forest!
Oddly enough, the problem seems to have been caused by the lack of
the os.c file being compiled into the project at all? Some files that
were in the 3.2.8 code stream are no
For the life of me I cannot figure out where this is going wrong. I
am not a below average intelligence individual, and I have been
working with computers for over 30 years, but this one has me totally
at a loss.
I should point out that while I own MacOS based systems exclusively
for
attempt to debug the 3.3.0 source and step into the
sqlite3OsLock call, it simply drops me into some assembler and
declares the bad instruction signal.
-ken
On 12-Jan-06, at 8:46 PM, [EMAIL PROTECTED] wrote:
Ken & Deb Allen <[EMAIL PROTECTED]> wrote:
I had a look, but I do not
I have encountered a problem while attempting to execute some code
with SQLite embedded. This code was working with the previous version
of the source. I am developing a small framework to permit me to use
the SQLite engine from within some Cocoa applications I am developing
for personal
Wow! Am I impressed!
A while back I initiated the email concerning the large number of
compiler warnings that were being generated when I attempted to
compile the SQLite source code using either the Visual Studio 2005
compiler or using XCode 2.2 (gcc 4). This sparked off some
acrimonious
the
actual intent raises some concerns.
-ken
On 29-Oct-05, at 12:56 PM, [EMAIL PROTECTED] wrote:
Ken & Deb Allen <[EMAIL PROTECTED]> wrote:
vdbeapi.c
e:\SQLITE\327\Source\vdbeapi.c(55) : warning C4244: 'return' :
conversion from 'i64' to 'int', possible loss of data
e:\SQLITE\327\Source
I have been toying with the idea of checking whether or not I can use
SQLite in a Windows device driver as its database. I am working on an
existing product that is implemented as a series of Windows device
drivers, filter drivers and even a file system driver. The file
system driver
This would be more effective if it were also available for MacOS and
Linux.
-ken
On 20-Aug-05, at 5:32 AM, Ralf Junker wrote:
Hello Clark Christensen,
SQLiteSpy executes the query "select date('2005-08-19');" with no
problems. SQLiteSpy is a free SQLite3 database manager and is
similar
I recently downloaded the (Finisar) .Net Data Provider for SQLITE
from SourceForge in order to use this in a C# applications under
Windoes XP. I had a few small problems getting the database created
at all via .Net, but that is working, and I was able to also define
the schema for my
Will declaring the column as VARCHAR not achieve the same thing? Does
SQLITE not translate VARCHAR to TEXT, rather than numeric?
-ken
On 21-Jun-05, at 5:10 AM, D. Richard Hipp wrote:
On Tue, 2005-06-21 at 00:13 -0400, Tito Ciuro wrote:
Hello,
When I add text to the database, it's getting
All database tables should be defined with a unique primary key.
Ideally this should consist of one or more integer columns; tect
columns can be used but they are universally less efficient. If the
data being stored does not contain a natural unique identifier, then
one should be added; you
Having used other databases extensively, and discovering that SQLITE
does not have a native DATETIME data structure, I have elected to store
the Date/Time value from the operating system (which is either a 32-bit
or 64-bit value) directly into an INT field and then translate it into
a string
When can we expect a 3.2.2 release that includes this correction? I am
working on a database that depends on 64-bit integer values.
-ken
On 15-Apr-05, at 7:35 AM, D. Richard Hipp wrote:
On Fri, 2005-04-15 at 10:53 +0100, Richard Boulton wrote:
I'm running the latest sqlite 3.2.1 command line
), and then timing the SELECT/JOIN.
-ken
On 15-Apr-05, at 6:15 AM, Ken & Deb Allen wrote:
I cannot speak for SQLITE for certain, but I know with a number of
commercial RDBMS packages the index is not used unless it contains a
sufficient degree of distribution. Microsoft SQL Server, for exa
I cannot speak for SQLITE for certain, but I know with a number of
commercial RDBMS packages the index is not used unless it contains a
sufficient degree of distribution. Microsoft SQL Server, for example,
is quite explicit in stating that if the distribution of values across
the range of
I have been experimenting with SQLITE for a little over a week now, and
I must say that I am fairly impressed with many of its capabilities. I
have been experimenting with performance from several aspects, and the
numbers are quite respectable. I have several years experience with
Sybase,
So, would this problem still exist if the code were to open two
'connections' to the database, issue the SELECT on one open connection
and then issue the CREATE TABLE via the other open connection?
Does this in any way prevent an application from opening a single
connection, issuing a SELECT,
To determine whether a specific database exists, check to see if the
file exists before calling sqlite3_open(), using stat() or some other
call.
To determine if a specific schema exists within an open database, use
the query "SEELCT COUNT(*) FROM sqlite_master WHERE type = 'table' AND
name IN
19 matches
Mail list logo
