On Fri, Apr 09, 2010 at 12:50:56AM +0400, Alexey Pechnikov scratched on the
wall:
> Hello!
>
> May be is needed to show this more informatively. The record
> "TABLE role_fts VIRTUAL TABLE INDEX 0:" is not useful I think.
http://sqlite.org/fts3.html
1.3 Simple FTS3 Queries
[...]
FT
Hello!
On Friday 09 April 2010 00:11:56 Jay A. Kreibich wrote:
> Virtual Tables are completely abstract to the query planner. The
> only way to do any type of indexed or high efficiency lookup is if
> the virtual table allows that to happen. Otherwise, there is
> nothing the query planne
On Thu, Apr 08, 2010 at 11:52:13PM +0400, Alexey Pechnikov scratched on the
wall:
>
> 1. With ordinary tables - fast
> 2. With ordinary tables and virtual table - very slow
>
> select role_exist.rowid as rowid, role.* from role_exist, role, role_fts
> where role_exist.rowid=role.rowid and role
Hello!
The SQLite library is builded from trunk
af3b72d94a1b6513f02402af3ada5fb5dd390151
1. With ordinary tables - fast
explain query plan
select role.rowid as rowid, role.* from role_exist, role where
role_exist.rowid=role.rowid;
0|0|TABLE role_exist
1|1|TABLE role USING PRIMARY KEY
select r
On Tue, Apr 6, 2010 at 10:40 PM, Dan Kennedy wrote:
>
> On Apr 7, 2010, at 3:23 AM, Chris verBurg wrote:
>
> > Hehe, okay, here I go. :)
> >
> >
> > I'm trying to replace an existing flex/bison parser with an re2c/lemon
> > parser, but I'm running into a methodological problem. I have a
> > hyp
No, actually, not bin. I have tried it from the root directory and the
App_Data directory using
absolute paths. I will try your approach.
Thanks Allan,
Joe
Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
cell: 603.289.
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Igmar Palsenberg
> Sent: Thursday, April 08, 2010 6:18 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] SQLite on Windows 2003
>
>
> > First of all
> Yeah, I think it is related to that. I am not new to ASP.NET nor to
> Windows 2003. I am new to SQLite, however.
> But I think you are on to something. I even changed the file name
> extension to .txt and it still doesn't work,
> although it does work in the console application.
>
To test :
Hi Igmar,
Yeah, I think it is related to that. I am not new to ASP.NET nor to
Windows 2003. I am new to SQLite, however.
But I think you are on to something. I even changed the file name
extension to .txt and it still doesn't work,
although it does work in the console application.
Thanks,
Joe
On 8 Apr 2010, at 1:12pm, Burnett, Joe wrote:
> I still do not have a successful opening of the SQLite connection in my
> ASP.NET C# application on
> Windows 2003. I have done the following:
>
> The connection opens successfully with the SQLite command tool.
> It opens successfully using a C# co
> First of all, I want to thank everyone that has replied to this email
> thread.
>
> I still do not have a successful opening of the SQLite connection in my
> ASP.NET C# application on
> Windows 2003. I have done the following:
>
> The connection opens successfully with the SQLite command tool.
>
First of all, I want to thank everyone that has replied to this email
thread.
I still do not have a successful opening of the SQLite connection in my
ASP.NET C# application on
Windows 2003. I have done the following:
The connection opens successfully with the SQLite command tool.
It opens success
On 8 Apr 2010, at 11:35am, Alex Kides wrote:
> I'm using sqlite through Qt and the problem I'm having is that in non
> utf locales (e.g. ja_JP.PCK on solaris) when given a shift-jis encoded
> to utf-8 string to open, the file being created is using the utf-8
> characters, i.e. when the file is ls
Hi,
I'm not sure if this is the right place to ask or has been covered
already (haven't been able to find any reference to this issue), but
does sqlite3_open_v2 have to take a UTF-8 formatted string for the
filename?
SQLITE_API int sqlite3_open_v2(
const char *filename, /* Database f
Hello!
On Thursday 08 April 2010 12:38:57 you wrote:
> A RAM disk is a good idea, but would require me to jump through too
> many hoops to get it approved. Corporate environment, you see :(
> For now, I've gone with a disk-based database with a larger cache and
> page size.
You can set
PRA
On Apr 8, 2010, at 3:38 PM, Kent Boogaart wrote:
> BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
> }Thanks to all respondents.
> A RAM disk is a good idea, but would require me to jump through too
> many hoops to get it approved. Corporate environment, you see :(
> For now, I'
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
}Thanks to all respondents.
A RAM disk is a good idea, but would require me to jump through too
many hoops to get it approved. Corporate environment, you see :(
For now, I've gone with a disk-based database with a larger cache
Hello!
On Thursday 08 April 2010 01:58:09 P Kishor wrote:
> The above is not going to work because I already have 649 in table t.
CREATE TEMP TABLE temp_t AS
SELECT * FROM t
WHERE id = 651;
UPDATE temp_t SET id=649; -- may be id=id-2 for set of records
DELETE FROM t WHERE id = 649;
INSERT INTO
18 matches
Mail list logo