Hi,
When I browse SQLite amalgamation file sqlite3.c , I found the following
comment:
/*
** WinCE lacks native support for file locking so we have to fake it
** with some code of our own.
*/
#if SQLITE_OS_WINCE
typedef struct winceLock {
int nReaders; /* Number of reader locks obtai
On Thu, Oct 14, 2010 at 1:04 AM, Nate Silva wrote:
> (Although FTS can be compiled into SQLite, I would like a DLL so I can
> dynamically load the extension into environments where I have a pre-compiled
> SQLite that doesn’t have full text search.)
>
>
Nate,
I think compile-time errors in this ca
Roger MARTINEZ wrote:
> restore function is not ok for me .
> Before I make a backup with
> /usr/local/sqlite-3.7.2/bin/sqlite3 spip.sqlite
> sqlite>.backup main spip.save
> ...
> /usr/local/sqlite-3.7.2/bin/sqlite3 spip.save
> sqlite>.database
> seq name file
> ---
> ---
What’s the recommended way to build the SQLite FTS3 extension as a Windows DLL?
I’m having the following problem:
fts3_tokenizer.obj : error LNK2005: sqlite3_api already defined in fts3.obj
When building as an extension, the macro SQLITE_EXTENSION_INIT1 is used in both
fts3_tokenizer.c and fts3
restore function is not ok for me .
Before I make a backup with
/usr/local/sqlite-3.7.2/bin/sqlite3 spip.sqlite
sqlite>.backup main spip.save
...
/usr/local/sqlite-3.7.2/bin/sqlite3 spip.save
sqlite>.database
seq name file
---
Kees Nuyt wrote:
> That is to say, any value in id_toto2_and_toto3 has a
> corresponding row in both toto2 and toto3.
>
> You have to ask yourself if toto2 and toto3 shouldn't be
> combined into one table.
>
> As far as I can tell, the only reason to not combine them
> would be some performance
On Wed, 13 Oct 2010 12:55:40 +0200, TP
wrote:
> Is this legal to have a foreign key
> that references several tables?
It is legal, but it is uncommon or even very rare.
Why? Well, a foreign key column (id_toto2_and_toto3)
identifies a row (tuple) in the referred table (toto2)
typically by it's
Mihai
> I use the Mozilla add-on, it's very handy and it gets updated.
> https://addons.mozilla.org/en-US/firefox/addon/5817/
That is what I am using, but unless I am missing something, it doesn't
let me create a form for data entry.
Thanks,
Graham
__
I use the Mozilla add-on, it's very handy and it gets updated.
https://addons.mozilla.org/en-US/firefox/addon/5817/
It currently uses SQLite version 3.6.22.
--
Mihai Militaru
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
Pavel Ivanov wrote:
>> Is this legal to have a foreign key that references several tables?
>
> Why not? I'd say it's a very bad database design (or extremely rare
> and questionable reason to do that) but there's nothing wrong in it
> from SQL point of view.
Thanks Pavel.
I'm rather new at SQL.
> Is this legal to have a foreign key that references several tables?
Why not? I'd say it's a very bad database design (or extremely rare
and questionable reason to do that) but there's nothing wrong in it
from SQL point of view.
Pavel
On Wed, Oct 13, 2010 at 6:55 AM, TP wrote:
> Hello,
>
> I
Hello,
I have another "borderline" question about SQL in SQLite. Look at the
following example
---
PRAGMA foreign_keys = ON;
CREATE TABLE toto1 ( id_toto1 INTEGER PRIMARY KEY
, id_toto2_and_toto3 INTEGER NOT NULL
,
12 matches
Mail list logo
