Its close but it seems to be doing a union rather than a left outer join
(I think!).
On my sample data I have 5 'males' per 'teacher' then the query returns
a count of 25 rather than 5. Gives me an idea though so I will have a
play around with it before I go home tonight.
Thanks,
Grant
Grant
>I am having problems with queries again - (I need a decent book on SQL -
>any recommendations?).
I have 'ORACLE: the complete reference' which is a bit out of date but has lots
of DBA type tricks for diagnostics... Covers SQL in a very technical manner assuming
you already understand a great dea
I am having problems with queries again - (I need a decent book on SQL -
any recommendations?).
I have query that (in a simplified version) does;
SELECT Teacher, Students, OtherStuff, Count(MaleFemale) As
NumberOfGirls
FROM MySchoolTable // a table listing teachers, students
WHERE M
16 bit world.
Exception "Error Creating Window" is often caused by lack of memory at the
moment of an attempt to create a window. Why is it that this exception
message is still shown even when code like that is used:
try
tmf := TMyForm.Create (Application);
except
Application.Terminate.
end;
Quoting Andrew Masters <[EMAIL PROTECTED]>:
> Hi,
>
> I originally sent this off topic but it didn't get posted for some =
> reason (is the off topic list working ?), so
>
> My development pc runs out of system resources (and eventually hangs) =
> when I have my project open with D3 and the
You could get the Kernal Toys for Win95 from the MSDN site and see if this
points out any problems - can't remember if this includes anything to check
for system resources, or the URL.
You could also try some memory/resource debugging tools.
eg MemCheck on the Delphi Super Page - freeware. (memc
Use NT for development, it is far better at handling application errors, and
is not prone to running out of resource's like Win9X development platforms
are.
Sorry if this is not what you wanted to hear, but you won't regreet going to
NT.
Chris
-Original Message-
From: [EMAIL PROTECTED]
One approach to complex screens with tabs is to break it up into different
forms and have the forms dyanamically created and destroyed behind events
triggered by the pagecontrol/tab component. To do this you create the form,
and them make its parent the tabsheet. You also need to set the form
pr
Bugs ? in my program ?? :)
Unfortunately I have the low resources situation I described the very first time I run
my app. I do have one form with many tabs and a large number of controls which may be
the culprit. Otherwise, yes, I'd expect to slowly run out of resources over time
running/debug
If you Break/Reset your program from within D3, it does not cleanup/release
all the system resources eg I presume these are things like window handles,
file handles, memory.
The other thing is bugs that do not release objects created in your program
etc.
I get this after running a while and hav
Hi,
I originally sent this off topic but it didn't get posted for some reason (is the off
topic list working ?), so
My development pc runs out of system resources (and eventually hangs) when I have my
project open with D3 and then run it from within D3. I tend to have a lot of units
open
Wilfred Verkley wrote:
> You could use a DrawGrid instead and the win32 api call DrawText.
>
> >From win32.hlp:
>
> "The DrawText function draws formatted text in the specified rectangle. It
> formats the text according to the specified method (expanding tabs,
> justifying characters, breaking li
12 matches
Mail list logo