On Jun 2, 2010, at 11:41 AM, Scott Frankel wrote:
Hi all,
I've been lurking for a few days while I explore SQLite and find
myself now with a question.
What's the correct usage for the ON DELETE NO ACTION statement?
I'm converting a schema file to SQLite. Executing a create table
On Jun 1, 2010, at 10:21 AM, Peter Kolbus wrote:
I am getting an access violation in rtree.c::nodeGetRowid() using a
database image of questionable integrity (the application the database
was last updated on shut down abnormally, but executing PRAGMA
integrity_check returns ok and there is
Hi,
trying to use .output to write a small text file, and send it to the C drive.
It looks like this:
.read UnPop.sql
.output C:\done.txt
.dump dbinfo
.quit
works fine if I send it to the E drive, but as soon as I try anywhere on the C,
whether to the drive itself, or a folder on C, it just
Hi
How could I force lemon assign a specific major number to a terminal? I need
that in order to make a lemon-generated parser work together with an already
existing scanner which is not under my control, and I'd like not to fall
back to manual translation.
Actually manual translation would
On 1 June 2010 12:52, Mark m.co...@virgin.net wrote:
Hi,
trying to use .output to write a small text file, and send it to the C drive.
It looks like this:
.read UnPop.sql
.output C:\done.txt
.dump dbinfo
.quit
works fine if I send it to the E drive, but as soon as I try anywhere on
thanks Simon, that worked, why is this? and if I wanted to send this to
someone else and it had the // would it NOT work for them?
Mark
- Original Message -
From: Simon Davies simon.james.dav...@googlemail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent:
Inside code you can use forward slash for path seperators (dang Microsoft for
ever introducing this backslash stuff).
so this works on ALL windows operating systems that I know of
.output c:/done.txt
Note though that if your user doesn't have admin priveledges they may not be
able to write
thanks Michael, my typing 2 forward slashes wasn't intentional, I realized
after I posted what I'd done, but it's good to know I can a forward slash
instead, so as long it it just goes to the C drive and no further, it should
be OK for all users?
Mark
- Original Message -
From:
On 2 Jun 2010, at 10:12am, Dan Kennedy wrote:
The fix you propose would ignore the (suspected) corruption
and continue without reporting it to the user. Which might be
the best thing for some
but not for me. Please do not roll anything like that into the source. I
definitely want error
On 2 Jun 2010, at 1:09pm, CDN Mark wrote:
thanks Michael, my typing 2 forward slashes wasn't intentional, I realized
after I posted what I'd done, but it's good to know I can a forward slash
instead, so as long it it just goes to the C drive and no further, it should
be OK for all users?
On Jun 2, 2010, at 7:19 PM, Simon Slavin wrote:
On 2 Jun 2010, at 10:12am, Dan Kennedy wrote:
The fix you propose would ignore the (suspected) corruption
and continue without reporting it to the user. Which might be
the best thing for some
but not for me. Please do not roll anything
Look this above! This will help you. I did't maked all test cases!
/***/
CREATE TABLE account (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
initial_balance REAL
);
CREATE TABLE movement (
id INTEGER PRIMARY KEY
An Correction!
/***/
DROP TRIGGER IF EXISTS movement_trg02;
CREATE TRIGGER movement_trg02 AFTER INSERT ON movement FOR EACH ROW
BEGIN
REPLACE INTO movement
SELECT t1.id
, t1.account_id
, t1.payment
, t1.amount
,
I asked that before because Oracle do this.
It notify the developer and ask if we want to create that transient index as
materialized.
I didn't see this working but I know this by a friend.
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás Brasil
Hi,
I'm wondering whether SQLite supports the XML functions ExtractXML and
UpdateXML. I couldn't find them in the manual and not in the web. Is it
true that I would need to provide them as user functions? Are there any
existing implementations for PHP PDO?
--
Yves Goergen LonelyPixel
On 2 Jun 2010, at 9:11pm, Yves Goergen wrote:
I'm wondering whether SQLite supports the XML functions ExtractXML and
UpdateXML. I couldn't find them in the manual and not in the web. Is it
true that I would need to provide them as user functions? Are there any
existing implementations for
I'm using sqlite 3.6.23.1.
I have a FTS3 table created using:
CREATE VIRTUAL TABLE EntryHeaders USING FTS3( Paragraph, Title,
tokenize=porter );
The following individual queries work and return rows:
SELECT rowid FROM EntryHeaders eh WHERE ( eh.Paragraph MATCH '91' )
SELECT rowid FROM
Hello. Sorry for my English.
I have a problem with the SQLite library reloaded correctly (use in
project). I'm using VC++ 2010 and Dev.
I add to project sqlite3.h, copy to folder with source sqlite3.dll and
sqlite3.lib. I add sqlite3.lib to linker - i search information on
forums, but can't
Lukasz,
I think the function you're trying to call is named sqlite3_open.
Regards,
Peter Kolbus
On Wed, Jun 2, 2010 at 10:56 AM, lukasz aaa zsu...@wp.pl wrote:
Hello. Sorry for my English.
I have a problem with the SQLite library reloaded correctly (use in
project). I'm using VC++ 2010 and
But I'm not getting any results when I combine these using OR:
SELECT rowid FROM EntryHeaders eh WHERE ( eh.Paragraph MATCH '91' ) OR (
eh.Title MATCH 'civil' )
See http://www.sqlite.org/fts3.html#section_3 . Your query should be more like:
SELECT rowid FROM EntryHeaders WHERE EntryHeaders
20 matches
Mail list logo