I believe you are wrong. The rowid is the primary key in the SQLite
B-tree representation. It is always unique and allows you not to use
your own primary key. But if you have a column of type INTEGER PRIMARY
KEY, the values in this column become rowid. Otherwise a new
autoincremented column is
On May 17, 2005, at 8:11 PM, Ken & Deb Allen wrote:
By ensuring that each record receives a unique identifier and
including that in all queries, the main issue is resolved.
Right, but the problem is that the user didn't use the unique
identifier in the query and now I'm faced with the prospect
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 can
ok, fine. what baffled me in the first place was the error message:
> 4:malformed database schema - near "to": syntax error
this is an sqlite error, not an sqlite3Explorer error, so I wonder whether at
some point even sqlite would gag at this field type definition...
I see there is an autoCommit flag in the sqlite3 structure. That is,
of course, an opaque structure and technically I shouldn't be looking
at it. But I wonder how evil it would be to expose that flag so that
I can use it to detect whether or not SQLite is currently in a
transaction.
Thanks
I use triggers to do this.
Quoting Jay Sprenkle <[EMAIL PROTECTED]>:
> On 5/17/05, Svetlik Slavomir <[EMAIL PROTECTED]> wrote:
> > Hi, I am new in this forum, but not in SQLite3. I successfully used
> > SQLite3.dll with Rapid-Q (very good programming language - clone of
> > Q-Basic), basic comman
On May 17, 2005, at 2:07 PM, Jay Sprenkle wrote:
rowid won't work in a multiuser database. It's just the row number
within
the result set you retrieved. This sort of problem is the reason
why people
use a unique id field. The database automatically assigns you a number
that won't change and isn
Mr. Cariotoglou,
I had two tables with unusual schemas. These schemas were acceptable to
SQLite but I perhaps I should not have expected Sqlite3Explorer to allow
them. The schemas look like the following example:
CREATE TABLE dataset_version
(
version_id smallint not null ,
name varc
rowid won't work in a multiuser database. It's just the row number within
the result set you retrieved. This sort of problem is the reason why people
use a unique id field. The database automatically assigns you a number
that won't change and isn't shown to the user (they can't change it either).
Could you please let me know what the problem was ? I am the author of
sqlite3Explorer, and perhaps I could fix it.
> -Original Message-
> From: Downey, Shawn [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 17, 2005 11:45 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Sqlite3ex
I develop a database wrapper for SQLite and I have an interesting
problem that I'm curious how other people solve. Basically, the users
of my wrapper have the option of editing database records indirectly
through the wrapper, rather than directly, using UPDATE. The database
wrapper is a set
Thanks anyway. I solved this myself.
Sqlite3Explorer is more particular about the table schema syntax than
Sqlite.
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)
-Original Message-
From: Downey, Shawn
Sent:
I think that you can put the aggregates directly into the SELECT
clause rather than referring to them by alias, i.e.
select city, sum(Weight)/count(id) as AvgWeight
-Tom
> -Original Message-
> From: de f [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 17, 2005 1:55 PM
> To: sqlit
Is there any way to do the following without using subqueries or
repeating the formulas?
select city, count(id) as TotalNum, sum(Weight) as TotalWeight,
TotalNum/TotalWeight as AvgWeight...
Get your own "800" number
Voicemail, fax, email, and a lo
Thanks for help
--- "Downey, Shawn" <[EMAIL PROTECTED]> a écrit:
>
> SELECT name FROM sqlite_master WHERE type = 'table';
>
> Shawn M. Downey
> MPR Associates
> 632 Plank Road, Suite 110
> Clifton Park, NY 12065
> 518-371-3983 x3 (work)
> 860-508-5015 (cell)
>
>
> -Original Message-
>
Version 1.4 of Sqlite3explorer could not open my database. The error
message is:
4:malformed database schema - near "to": syntax error
An older version of Sqlite3explorer worked fine on this database. I am
using sqlite.dll version 3.2.1. Does anyone else have problems with
Sqlite3explore
On Tue, 17 May 2005, Jaap Krabbendam wrote:
I have been simulating a crash during a transaction. After BEGIN, at some
point I do exit(-1) instead of COMMIT or ROLLBACK in order to simulate a
crash.
After that, I can see that a -journal file is present. If I restart my
executable, it seems that the
This is$B!!(BYutaka nakamura in Japan.
(B
(Bdiff file sqlite-3.2.1's func.c.
(B
(Badd stdev() and rr() .
(B
(B. stdev() mean stddev lile MS Excel.
(B
(B. rr() mean RiskReturn( mean 1/CV =$B&L(B/$B&R(B)
(B
(Bpahaps RiskReturn calculate speed fastest SQL in the world.
(B
(Bbecous
I do have some code here. It is clear that the problem is related to using
threads. I did not see the problem having just the main program. Note that it
is my objective to test a crash, hence the exit(0) from my_thread. The same
phenomenon is seen when replacing exit(0) by while(1) sleep(100) and t
Thanks for responding Gé
There are the usual options of buffered and unbuffered file i/o in AmigaOS.
A given file can be opened either in a shared mode, or an exclusive mode by
a process, but it can also be locked first and then opened. It cannot be
locked individually for a given pthread runnin
David Pitcher wrote:
> The claim that it works over a networked drive has made me
> start to think that operating system specific locking mechanisms are totally
> the wrong way to go, and that I have misunderstood the code.
OS locking mechanisms are supposed to work over a network.
>[...] or s
Dave,
The os_unix.c locking code is extremely convoluted because of the rather
insane Posix locking semantics, which tend to make writing threaded code
excessively complicated, e.g. if two threads are accessing the same file
and one thread closes its file handle the other thread loses all its lock
I'll try to get the essentials in a short program (and hope that it still
reproduces the problem). I'll get back on this later.
Jaap Krabbendam
>
>Can you post code?
>
>--- Jaap Krabbendam <[EMAIL PROTECTED]> wrote:
>
>>
>> Hi,
>>
>> I have been simulating a crash during a transaction. After B
Can you post code?
--- Jaap Krabbendam <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have been simulating a crash during a transaction. After BEGIN, at some
> point
> I do exit(-1) instead of COMMIT or ROLLBACK in order to simulate a crash.
>
> After that, I can see that a -journal file is present
On 5/17/05, Svetlik Slavomir <[EMAIL PROTECTED]> wrote:
> Hi, I am new in this forum, but not in SQLite3. I successfully used
> SQLite3.dll with Rapid-Q (very good programming language - clone of
> Q-Basic), basic commands like CREATE, INSERT, SELECT, UPDATE etc. works
> fine, thanks!
> My newbie q
Hi,
I have been simulating a crash during a transaction. After BEGIN, at some point
I do exit(-1) instead of COMMIT or ROLLBACK in order to simulate a crash.
After that, I can see that a -journal file is present. If I restart my
executable, it seems that the changes of the transaction are made
SELECT name FROM sqlite_master WHERE type = 'table';
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)
-Original Message-
From: majed chatti [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 17, 2005 8:00 AM
To: sqlite
Houw can I get all of tables of a data base
I think its same think like
>select * from sysobjects;
but it dose not work
_
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stocka
Hi,
i think you are talking about foreign key constraints: these are not
enforced by sqlite (http://www.sqlite.org/omitted.html).
If you want the database to delete child records when the parent record
is deleted, you have to write a trigger
(http://www.sqlite.org/lang_createtrigger.html).
Mart
Hi, I am new in this forum, but not in SQLite3. I successfully used
SQLite3.dll with Rapid-Q (very good programming language - clone of
Q-Basic), basic commands like CREATE, INSERT, SELECT, UPDATE etc. works
fine, thanks!
My newbie question: If I create two tables (parent and child), I know
set rel
there
Ive just recently ported ( in the nastiest dirtiest way so far ) sqlite onto
another platform - that is AmigaOS version 4.0 (
powerpc
):http://www.os4depot.net/index.php?function=showfile&file=library/misc/sqlite3.tar.gz
However I had to put a health warning on it because in order to get
31 matches
Mail list logo
