Re: [sqlite] on delete no action

2010-06-02 Thread Dan Kennedy
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

Re: [sqlite] Bug and possible fix: Access violation in rtree.c:nodeGetRowid()

2010-06-02 Thread Dan Kennedy
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

[sqlite] output problem

2010-06-02 Thread Mark
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

[sqlite] lemon-generated parser cooperation with a scanner not under my control

2010-06-02 Thread Aspra Flavius Adrian
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

Re: [sqlite] output problem

2010-06-02 Thread Simon Davies
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

Re: [sqlite] output problem

2010-06-02 Thread CDN Mark
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:

Re: [sqlite] output problem

2010-06-02 Thread Black, Michael (IS)
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

Re: [sqlite] output problem

2010-06-02 Thread CDN Mark
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:

Re: [sqlite] Bug and possible fix: Access violation in rtree.c:nodeGetRowid()

2010-06-02 Thread Simon Slavin
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

Re: [sqlite] output problem

2010-06-02 Thread Simon Slavin
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?

Re: [sqlite] Bug and possible fix: Access violation in rtree.c:nodeGetRowid()

2010-06-02 Thread Dan Kennedy
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

Re: [sqlite] Performance issue on view

2010-06-02 Thread Israel Lins Albuquerque
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

Re: [sqlite] Performance issue on view

2010-06-02 Thread Israel Lins Albuquerque
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 ,

Re: [sqlite] MySQL vs. SQLite

2010-06-02 Thread Israel Lins Albuquerque
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

[sqlite] XML functions support?

2010-06-02 Thread Yves Goergen
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

Re: [sqlite] XML functions support?

2010-06-02 Thread Simon Slavin
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

[sqlite] FTS3 query question

2010-06-02 Thread Nick Hodapp
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

[sqlite] Problem with sqlite3

2010-06-02 Thread lukasz aaa
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

Re: [sqlite] Problem with sqlite3

2010-06-02 Thread Peter Kolbus
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

Re: [sqlite] FTS3 query question

2010-06-02 Thread Alexandre Courbot
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