> 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
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 wrote:
> Hello. Sorry for my English.
> I have a problem with the SQLite library reloaded correctly (use in
> project). I'm using VC++ 2010
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
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
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
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"
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
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
,
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
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
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
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
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:
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 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"
To: "General Discussion of SQLite Database"
On 1 June 2010 12:52, Mark 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
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
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
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
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
20 matches
Mail list logo