From: Schlobohm, Jack <SchlobohmJ@DNB.com>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: error 3122 in ACCESS -
Date: Thu, 29 Jun 2000 17:33:19 -0400
Message-ID: <15451D40256749-01@WorldSecure_Server__smtp-gw.us.dnb.com_> (raw)
I have a query which uses an expression... dividing "1" by a number field in
a static table.
I changed the expression to divide by a different number field from the same
table. This caused an error.
Error 3122: I tried to execute a query that doesn't include the specific
expression < * > as part of an aggregate function.
The possible cause is listed as: I didn't enter an aggregate function in the
TRANSFORM statement.
OK - The only thing different from this query and the one that worked is
which field is included in the expression. The expression is { NewFieldName:
(1/[FieldName])*([FieldCreatedbyanEarlierExpressioninQuery]) }.
1st - What is a transform statement?
2nd- What is an aggregate function?
3rd - Would I need to change anything is SQL... and what?
4th- Why wouldn't the same expression work with a different field?
Jack Schlobohm
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: SchlobohmJ@DNB.com
Subject: Re: error 3122 in ACCESS -
In-Reply-To: <15451D40256749-01@WorldSecure_Server__smtp-gw.us.dnb.com_>
References: <15451D40256749-01@WorldSecure_Server__smtp-gw.us.dnb.com_>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox