I've lined up some time to work on fts, again, which means fts3. One
thing I'd like to include would be to order doclists by some baked-in
ranking. The idea is to sort to most important items to the front of
the list, and then you can do queries which limit the number of hits
and can thus be sig
Rob Richardson <[EMAIL PROTECTED]>
wrote:
Our shop writes in Visual C++ 6, and our applications are all
developed
with _UNICODE defined. But if we want to use sqlite3_exec(), we are
forced to convert the SQL statements to single-byte characters. Why
is
there no sqlite3_exec16() method? Or is t
Greetings!
Our shop writes in Visual C++ 6, and our applications are all developed
with _UNICODE defined. But if we want to use sqlite3_exec(), we are
forced to convert the SQL statements to single-byte characters. Why is
there no sqlite3_exec16() method? Or is there a version of the SQLite
API
- Original Message -
From: "Trey Mack" <[EMAIL PROTECTED]>
To:
Sent: Friday, June 08, 2007 1:08 PM
Subject: Re: [sqlite] SQL query help...
Here's what I tried, which didn't work...
select
name,
substr(name,1,length(name)-3) as zone,
substr(name,length(name)-2,2) as location,
max(th
Here's what I tried, which didn't work...
select
name,
substr(name,1,length(name)-3) as zone,
substr(name,length(name)-2,2) as location,
max(thick) - min(thick) as diff from plypoint
where diff > 0.0005
group by zone,location
That causes a "misuse of aggregate" error.
select
name,
substr(name,
Hi All,
I need a little help in constructing a SQLite query..
Here's what I have so far that works...
select
name,
substr(name,1,length(name)-3) as zone,
substr(name,length(name)-2,2) as location,
max(thick) - min(thick) as diff from plypoint
group by zone,location
The above properly calculate
A.J.Millan wrote:
John Elrick wrote:
Tim Anderson wrote:
We are working on a project for the Census Bureau and needed an
embeddable database that was zero configuration for the user and fast.
We evaluated SQLite against numerous competitors...
IMHO, a bit exaggerated the "numerous co
Tim Anderson wrote:
> I'm writing an article about SQLite and I'd love to get some comments
> from users about why you use it. Performance? Features? Reliability?
> Cost? Is the open source aspect important? Anything else? For that
> matter, anything you really don't like about SQLite?
>
> You can
Am Donnerstag, 7. Juni 2007 19:49 schrieb Tim Anderson:
> I'm writing an article about SQLite and I'd love to get some comments
>
> >from users about why you use it. Performance? Features? Reliability?
>
> Cost? Is the open source aspect important? Anything else? For that
> matter, anything you rea
Ellis Robin (Bundaberg)
<[EMAIL PROTECTED]> wrote:
Update Parameter set ParameterValue = (select NewParams.parametervalue
from Scenario, Link, Catchment, FunctionalUnit,
FunctionalUnitDefinition, StandardFU, Parameter, NewParams where
Scenario.ScenarioID = 1004 and Scenario.NetworkID = Link.Netwo
Hi there,
Unfortunately, after DELETE FROM table, all data was successfully deleted.
Is there any possibility to restore the data? Any tools maybe?
I can see all the data still in DB file.
Any answers will be highly appreciated!
On Fri, 2007-06-08 at 09:50 +0530, Jimmy Mathew Ambalathuruthel wrote:
> Hi all,
>
> I am working in a porting project of SQLite from windows.
>
> I Could not port the Truncate () function (For Eg: WinTruncate () in
> windows code in the file os_win.c ) as the same logic cannot be applied
> t
12 matches
Mail list logo