Neven
- Original Message -
From: "Tracey Maule" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 9:36 AM
Subject: Re: [DUG]: sql help please
> yeah i know its tough when u dont know the data
ick sorry the formatting fell off
- Original Message -
From: "Tracey Maule" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 9:36 AM
Subject: Re: [DUG]: sql help please
> yeah i know
uot; <[EMAIL PROTECTED]>
Sent: Wednesday, February 12, 2003 9:01 PM
Subject: Re: [DUG]: sql help please
> Tracy went to reply last night and then had a closer look at
> your sql and thought havent got an answer.
> anyway will try now
>
> distinct records are all you can expect
&
Tracy went to reply last night and then had a closer look at
your sql and thought havent got an answer.
anyway will try now
distinct records are all you can expect
you could try
select distinct pe.commencedate, sn.skillid, s.name, sn.timeperiodid, tp.weeks
from personemployment pe
join skillnee
umb newbie not being able to sort it out with SQL . =)
Cheers for your time anyway
- Original Message -
From: Nello Sestini
To: Multiple recipients of list delphi
Sent: Wednesday, February 12, 2003 2:07 PM
Subject: Re: [DUG]: sql help please
i was waiting a bit for a more sag
i was waiting a bit for a more sage response, but
...
could someone help me with my query
please?
I have the following tables
/* snip ... */
Some skills are required in more than one
job. If this person has both those jobs and doesnt have that skill, then
the quer
> On 17 Jan 2003 at 11:28, Steve Peacocke wrote:
> Steve I had actually copied each part of the 2 part query into
> separate Q numbers. It seems that the temp table created in one Q is
> available to another?
Yes, Twenty Queries actually uses only a single query behind the scenes -
therefore t
On 17 Jan 2003 at 11:28, Steve Peacocke wrote:
> > OK. I guess that's what I was asking.
>
> Yep, my guess is what Twenty Queries was doing was running the first.
> It simply opens the query with what you have given it so nothing
> special runs in the background there.
Steve I had actually copi
> hmmm from memory also I dont think delphi sql handles joins.
>
> I believe when I was doing stuff like this I had to take the result set
> from the first and load these into variables and then pass these to a
> seperate query...
Mark is talking DBISAM which has a good SQL implementation. The wo
> OK. I guess that's what I was asking.
Yep, my guess is what Twenty Queries was doing was running the first. It
simply opens the query with what you have given it so nothing special runs
in the background there.
> So...Can I do
>
> SELECT (blah, blah) into MEMORY t1
>
> followed by
>
> SELECT (
[EMAIL PROTECTED]]On
> Behalf Of Mark Howard
> Sent: Friday, 17 January 2003 11:16 a.m.
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: SQL Help
>
>
> OK. I guess that's what I was asking.
>
> So...Can I do
>
> SELECT (blah, blah) into MEMORY t1
&g
To answer part of my own query...
Yes, you can do as below (as long as you remember to do 'SQL.Clear'
between!)
I'm still not sure if I need to specifically handle the Memory table when
I've finished with it.
Mark
On 17 Jan 2003 at 11:15, Mark Howard wrote:
> OK. I guess that's what I was as
OK. I guess that's what I was asking.
So...Can I do
SELECT (blah, blah) into MEMORY t1
.
ParamByName('StartDate').AsDate := Date1;
ParamByName('EndDate').AsDate := Date2;
Open;
followed by
SELECT (blah, blah)
JOIN MEMORY t1 on d.LogCode = t1.LogCode
.
ParamByName('StartDate').AsDate := Date
I thought delphi could only handle single sql queries, not multiples?
Please correct me if Im wrong...
Chris
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mark Howard
> Sent: Friday, 17 January 2003 10:54 a.m.
> To: Multiple recipients of list de
The only query I've seen to do this is in the form
SELECT * FROM MyTable A
WHERE 50 > (SELECT COUNT(B.TableID) FROM MyTable B
WHERE A.TableID < B.TableID)
a. I don't know if local SQL will do it - it's pretty good now though.
b. It kills DBMS's - ie a stored proc, on a SQL db, or a cu
15 matches
Mail list logo
