| From: | "Schlobohm, Jack" <SchlobohmJ(at)DNB(dot)com> |
|---|---|
| To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | error 3122 in ACCESS - |
| Date: | 2000-06-29 21:33:19 |
| Message-ID: | 15451D40256749-01@WorldSecure_Server__smtp-gw.us.dnb.com_ |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vadim Passynkov | 2000-06-30 19:06:34 | some strings from errlog |
| Previous Message | Kovacs Zoltan Sandor | 2000-06-29 16:56:55 | select from table |