[comp.databases] Tricks & INGRES Report-Writer

jukka@tukki.jyu.fi (Jukka Hartikainen) (02/02/90)

I have a little problem in doing SELECT-clause in
Ingres Report-Writer. I know that there is no way
to do it "pure", but some other way maybe...

If I have

  SELECT  ...., constant=value, ...
  FROM    ...
  WHERE (condition 1) or (condition 2)

and I'd like to get the value of constant 1 or 2 depending of
which one of the where-conditions is true. Is it possible and how?

The main idea is that the constant is one sort column and in the
report there will be header and footer for that. The data is
some personal records and depending of in what group one person is,
his/hers data is in right place.

Thanks!

---Jukka

bg0l+@andrew.cmu.edu (Bruce E. Golightly) (02/05/90)

How about using the .IF in the body of the RW procedure? We use this technqiue
in one that cranks outs outlet ID labels, which makes use of run-time parameter
values and .IF operations. Makes for some really ugly code, but it works.

Bruce