RE: Calculated/derived fields

Yeah I missed the Qry/400 requirement in the OP.

I wonder if the Qry/400 replacement can utilize service programs. While
it may not be the easiest thing for a user to do, it would be cool if
the functionality was there.


Kurt Anderson
Application Developer
Highsmith

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Tuesday, September 09, 2008 6:29 AM
To: Midrange Systems Technical Discussion
Subject: Re: Calculated/derived fields

Kurt's suggestion was to use a service program to calculate the dollar
amounts. In that instance the dollar amount would not be available to
Query/400.

--
Jeff Crosby
UniPro Foodservice/Dilgard
260-422-7531
Opinions expressed are my own and not necessarily those of my company.
Unless I say so.



rob@xxxxxxxxx wrote:

Why wouldn't it be available to those query users? Any VIEW can use a

UDF. And I've written a FAQ at faq.midrange.com on how to make a

service

program subprocedure into a UDF and put it in a view.

Having users query tables (and figure out join this to that and ...)

can

be numbing. Create good views. After all, you've played with query

tools

and the first thing they do is force you to create meta data. And

much of

the cool stuff that meta data does can be done with good views.

Rob Berendt