--- [EMAIL PROTECTED] wrote:
> I'm using cygwin under windows XP.
> gcc version 3.4.4
>
> I unzipped the sqlite-3.3.16.tar.gz to the directory sqlite-3.3.16.
>
> Executed the following:
>
> cd sqlite-3.3.16
> mkdir build
> cd build
> ./configure
> make
>
> The resulting sqlite3.exe is 4 times
My 2 cents:
create table Objects(id integer primary key, name text);
create table Attributes(id integer primary key, name text);
create table ObjectAttributes(objectID integer, attributeID integer, order
integer, type integer, value text, version text);
- Original Message -
From:
Hi all,
I've used SQLite-3.3.4 for quite a while, mostly the Tcl binding.
A few days ago I installed 3.3.15 and the Tcl binding worked fine.
Tonight I downloaded 3.3.16 and compiled it without any errors
or warnings and then installed it. When I tried to execute sqlite3
the following error
Use sqlite3_libversion(). See
http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details.
Im using 3.3.13, I will like if you can show a little snipped of how to go
with something like the next..
(The following at sqlite prompt)
create table some(xthing varchar, count integer);
insert
I'm using cygwin under windows XP.
gcc version 3.4.4
I unzipped the sqlite-3.3.16.tar.gz to the directory sqlite-3.3.16.
Executed the following:
cd sqlite-3.3.16
mkdir build
cd build
./configure
make
The resulting sqlite3.exe is 4 times bigger than the windows release in
sqlite-3.3.16.zip.
David A O L wrote:
That mean Im using sqlite version 2?? (Because it say database locked).
Like I know I have here sqlite3 I will search the way to print the
version
of the library used...
David,
Use sqlite3_libversion(). See
http://www.sqlite.org/capi3ref.html#sqlite3_libversion for
What I whant is that in // Here! I whant to update (increment, decrement,
> etc).
>
> But it say that the DB is locked...
With sqlite v2, yes. If you were using sqlite v3 you could do the
UPDATE in the SELECT callback.
That mean Im using sqlite version 2?? (Because it say database locked).
[EMAIL PROTECTED] wrote:
Hello,
I'm currently modelling and designing a new database according the following
specifications. The general idea is the ability to store arbitrary objects,
which have attributes of various kinds. The attributes themselves may be
multivalued. The objects being
Justin Fletcher <[EMAIL PROTECTED]> wrote:
>
> As test select1-11.2.1 already produced a useful result
> for this class of test and 11.2.2 provides no additional
> tests, it is probably redundant as a test there - the
> test it's performing is actually being obscured by the
> goofy test system
Michael Boldin via alt email wrote:
And for anyone else using python and pysqlite, here is now to get a list of
table
# Python SQLite application
from pysqlite2 import dbapi2 as sqlite
# Connect to database
path= 'C:\\'
dbname= 'dbtest.db'
db_location= path + '\\' + dbname
db =
Michael Boldin via alt email
wrote:
And for anyone else using python and pysqlite, here is now to get a
list of table
# Find table names
qx='select tbl_name from sqlite_master'
You'd want something like
select tbl_name from sqlite_master where type='table';
In addition to tables,
[EMAIL PROTECTED] wrote:
Justin Fletcher <[EMAIL PROTECTED]> wrote:
do_test select1-11.2.2 {
execsql2 {
SELECT * FROM t3, t4;
}
} {a 3 b 4 a 3 b 4}
Can someone explain how the test can be correct ?
This comes about because of duplicate column names.
The execsql2 procedure looks
Thanks Igor, this gives me what I need
In fact,
pragma table_info( sqlite_master );
works to give information about what is in the master table view
And for anyone else using python and pysqlite, here is now to get a list of
table
# Python SQLite application
from pysqlite2 import dbapi2
Justin Fletcher <[EMAIL PROTECTED]> wrote:
> do_test select1-11.2.2 {
>execsql2 {
> SELECT * FROM t3, t4;
>}
> } {a 3 b 4 a 3 b 4}
>
> Can someone explain how the test can be correct ?
>
This comes about because of duplicate column names.
The execsql2 procedure looks at all column
By having "versioned attributes" do you mean the entire set of attributes is
versioned as a group, or individually? Is it an object's state at a
specific point in time that you want to version?
--a
On 4/20/07, Michael Ruck <[EMAIL PROTECTED]> wrote:
Hello,
I'm currently modelling and
Thank you John Stanton. This has opened new doors for me, and think it
would be helpful for others in the list too..
Thanks and Regards
Lloyd
On Thu, 2007-04-12 at 12:34 -0500, John Stanton wrote:
> We use a very simple data retrieval method for smallish datasets. The
> data is just stored in
Hi,
I'm doing some work with the SQLite test suite and I'm confused as to the
purpose or correctness of a couple of the tests. A few tests have shown
up odd issues, but the following is typical of the general case.
8<
do_test select1-11.1 {
execsql {
DELETE FROM t3;
DELETE
Rich Rattanni wrote:
I mean't when I tried this...
update Parameters set value = (select value from WorkingParameters wp);
When you execute this, it works, but it takes the first result row
from value and copies it into all the rows of parameters.
Rich,
When you execute an update statement,
Hello,
I'm currently modelling and designing a new database according the following
specifications. The general idea is the ability to store arbitrary objects,
which have attributes of various kinds. The attributes themselves may be
multivalued. The objects being stored need to be versioned, so
Lloyd,
If you want some code examples contact me and I shall send you some.
[EMAIL PROTECTED]
Lloyd wrote:
Thank you John Stanton. This has opened new doors for me, and think it
would be helpful for others in the list too..
Thanks and Regards
Lloyd
On Thu, 2007-04-12 at 12:34 -0500, John
On 4/19/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
--- DragonK <[EMAIL PROTECTED]> wrote:
> I'm having the following problem: a sqlite database file is on an NTFS
> filesystem, in a directory with no permissions to create new files, but
only
> to modify the original database. By using filemon
We do something like that by storing the data in TEXT format and using
RCS to handle versioning by its reverse delta method. It works well for
storing notes and may be useful in your application.
A function can return the appropriate version.
Michael Ruck wrote:
Hello,
I'm currently
>>The question is: the anterior way is the only way???<<
>>I think anterior means "before"... I'm no wordsmith...<<
Yes it does: David means "what I said before", or "the foregoing". He's
simply asking if there is another way.
Michael Hooker
From: "Dan Kennedy" <[EMAIL PROTECTED]>
To:
On Fri, 2007-04-20 at 10:13 +0200, Jens Miltner wrote:
> Am 20.04.2007 um 09:13 schrieb Jens Miltner:
>
> >
> > Am 01.04.2007 um 20:05 schrieb Iulian Musat:
> >
> >>
> >> [EMAIL PROTECTED] wrote:
> >>> [...]
> >>> In past releases of SQLite, we have made available a ZIP archive
> >>> with
Am 20.04.2007 um 09:13 schrieb Jens Miltner:
Am 01.04.2007 um 20:05 schrieb Iulian Musat:
[EMAIL PROTECTED] wrote:
[...]
In past releases of SQLite, we have made available a ZIP archive
with preprocessed source files. In the future, we may change this
so that instead of a ZIP archive
Am 01.04.2007 um 20:05 schrieb Iulian Musat:
[EMAIL PROTECTED] wrote:
[...]
In past releases of SQLite, we have made available a ZIP archive
with preprocessed source files. In the future, we may change this
so that instead of a ZIP archive full of individual files, we
ship a single
26 matches
Mail list logo
