Subject | Re: [IBO] Calculated Fields |
---|---|
Author | Laurie McIntosh |
Post date | 2006-07-27T19:15:15Z |
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
Serves me right.
Helen, I know SQL pretty well. What I don't do well is write example
queries after 15 hour days! But if I can't phrase the question
properly, how can I expect the non-mind readers in the audience to
know what the problem is?
Let's say my query looks like
SELECT MYDATE,
COUNT(MYBOOK) AS MYBOOK,
COUNT (MYCALLS) AS MYCALLS
FROM FOO
GROUP BY MYDATE
... and I want to calculate COUNT(MYBOOK) / COUNT(MYCALLS) for every
record.
What goes in the onCalculateField method?
> Get hold of a primer on SQL? Your problem is not with "how to make<sigh>
> IBO do what I want" but understanding how to extract data from your
> database. You're writing an application with a relational database
> as its back-end. The language that your application talks to the
> database in is SQL. Whether you can believe it or not, you're not
> going to get by without knowing SQL, sorry.
Serves me right.
Helen, I know SQL pretty well. What I don't do well is write example
queries after 15 hour days! But if I can't phrase the question
properly, how can I expect the non-mind readers in the audience to
know what the problem is?
Let's say my query looks like
SELECT MYDATE,
COUNT(MYBOOK) AS MYBOOK,
COUNT (MYCALLS) AS MYCALLS
FROM FOO
GROUP BY MYDATE
... and I want to calculate COUNT(MYBOOK) / COUNT(MYCALLS) for every
record.
What goes in the onCalculateField method?