Hello Dr. Hipp:
I have previously reported compiler warnings to you issued
by the Pelles C MS-Windows compiler and you have repaired
them in the following release. This is the first time I have tried
to compile the single file sqlite3.c using the compiler version 3.50
and it reported some
The preprocessed source code in single files (plus def file) package
would be appreciated.
The number one reason for me, which make the "The Amalgamation" a show stopper:
Using SQLite in an open source project usually (and also in my case)
means that the source code is available on a
On 5/1/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote:
One suggestion though, instead of (or in addition to) using '*' as the
prefix operator perhaps '%' would be more appropriate in order to be closer
to the LIKE operator.
Hmm. I was mainly just doing what other groups appear to do (Lucene,
This is great! The main reason we decided not to use FTS in our project was
lack of prefix searching. With this new functionality we'll probably switch
to using FTS in a future update.
One suggestion though, instead of (or in addition to) using '*' as the
prefix operator perhaps '%' would be
I just finished ( http://www.sqlite.org/cvstrac/chngview?cn=3893 )
checking in a string of changes to fts2.c to provide prefix search.
This works like:
CREATE VIRTUAL TABLE t USING fts2(c);
INSERT INTO t (c) VALUES ('This is a test');
INSERT INTO t (c) VALUES ('That was a test');
INSERT INTO
Yes, you are right. Good thing the OP found it
himself.
RBS
> actually
>
> SELECT COUNT(DISTINCT ...
>
> On 5/1/07, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
>> It will be as the below query, but replace:
>> distinct p.*
>> with:
>> count(p.ID)
>>
>> RBS
>>
>> >> Allan, Mark wrote:
>> >> >
actually
SELECT COUNT(DISTINCT ...
On 5/1/07, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
It will be as the below query, but replace:
distinct p.*
with:
count(p.ID)
RBS
>> Allan, Mark wrote:
>> > What I want is Joe Blogs just the once.
>> >
>> >
>> Mark,
>>
>> Then try adding distinct like
>
> Ok, so here's another question, how would I get the count of
> patients where the EVC and FVC > 2.0?
>
Dont worry I have figured this out. I am doing:-
select count (distinct p.PatientID) p.*
from PatientsTable as p
join ExaminationsTable as e on e.PatientID=p.ID
join TestTable as t on
It will be as the below query, but replace:
distinct p.*
with:
count(p.ID)
RBS
>> Allan, Mark wrote:
>> > What I want is Joe Blogs just the once.
>> >
>> >
>> Mark,
>>
>> Then try adding distinct like this:
>>
>> select distinct p.*
>> from PatientsTable as p
>> join ExaminationsTable as e on
> Allan, Mark wrote:
> > What I want is Joe Blogs just the once.
> >
> >
> Mark,
>
> Then try adding distinct like this:
>
> select distinct p.*
> from PatientsTable as p
> join ExaminationsTable as e on e.PatientID=p.ID
> join TestTable as t on t.ExamID=e.ID
> join ForcedSpiroTable as f on
Allan, Mark wrote:
Excellent, thanks for your help.
Mark,
For future reference, your posts could use a little more trimming. There
is no need to quote the entire string of messages from your original
post on each reply. :-)
Dennis Cote
Allan, Mark wrote:
What I want is Joe Blogs just the once.
Mark,
Then try adding distinct like this:
select distinct p.*
from PatientsTable as p
join ExaminationsTable as e on e.PatientID=p.ID
join TestTable as t on t.ExamID=e.ID
join ForcedSpiroTable as f on f.TestID=t.ID
join
Excellent, thanks for your help.
Indeed I was missing the DISTINCT keyword. The query does exactly what I need
it to now.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of P
> Kishor
> Sent: 01 May 2007 15:50
> To: sqlite-users@sqlite.org
> Subject: Re:
Try instead:
select distinct etc.
will only work if your select only involves the
patient table.
RBS
> Hi,
>
> Thanks for your quick replies. I have tried this method but however I am
> getting a row returned for each entry in ForcedSpiroTable or
> RelaxedSpiroTable that matches the search
On 5/1/07, Allan, Mark <[EMAIL PROTECTED]> wrote:
Hi,
Thanks for your quick replies. I have tried this method but however I am
getting a row returned for each entry in ForcedSpiroTable or RelaxedSpiroTable
that matches the search criteria.
i.e. If a single patient say "Joe Bloggs" has 5
Hi,
Thanks for your quick replies. I have tried this method but however I am
getting a row returned for each entry in ForcedSpiroTable or RelaxedSpiroTable
that matches the search criteria.
i.e. If a single patient say "Joe Bloggs" has 5 tests, all with EVC and FVC
greater than 2.0 then I get
Allan, Mark wrote:
I have a database that looks something like the following:-
PatientsTable { ID, Name, Sex, }
ExaminationsTable { ID, PatientID, }
TestTable { ID, ExamID, .}
ForcedSpiroTable { ID, TestID, EVC, IVC, IC ... }
RelaxedSpiroTable { ID, TestID, FVC, FEV1, PEF, ...}
Can
select *
from PatientsTable P
inner join ForcedSpiroTable F on
(P.ID = F.ID)
inner join RelaxedSpiroTable R on
(P.ID = R.ID)
where
F.EVC > 2.0 and
R.FVC > 2.0
RBS
> Hi,
>
> Can anyone offer any help with the following SQL query?
>
> I have a database that looks something like the following:-
>
Hi,
Can anyone offer any help with the following SQL query?
I have a database that looks something like the following:-
PatientsTable { ID, Name, Sex, }
ExaminationsTable { ID, PatientID, }
TestTable { ID, ExamID, .}
ForcedSpiroTable { ID, TestID, EVC, IVC, IC ... }
hi,
i found the way to open a temp file is different from other files (.db files
or journal files)
open temp file: open with the relative path. and then point to the fullpath
while open other files: get the fullpath first, and then open.
codes are cited as below:
in pager.c
yazan wasfi wrote:
Hi All,
I'm trying to compile sqlite with TCL enabled under VC6, Ive installed
ActiveTCL8.4, and Added the include, lib, bin, to my VC6 project, when
compiling the sqlite, I dont get any errors, but when trying to link it I get
49 errors like this
Linking...
tclsqlite.obj
21 matches
Mail list logo