Hello again–
Well, I figured out a workaround to this one - just thought I’d let you all know – I just concatenated the decodes, eliminating the @Select concatenations. My coworker thought she remembered an issue with @Select and parentheses in the version 3.x to 4.0 conversion, but we didn’t realize it might still be an issue with 4.1 – although, it seems it was fixed with the move to 4.1.2! Anyone know of any other compatibilities?
Thanks!
Amy
At 12:15 PM 11/4/1999 -0500, you wrote:
Hello Listsers–
I ran into an odd one today - wonder if you all have any experience with
this:
We have a mixed constituency of users, ranging from 4.1 (not .1 anything) to 4.1.2 to 4.1.3 clients. I, the Designer of the universe in question, am using Designer 4.1.3. I created a new object in our General Ledger universe, which users with 4.1.2 and 4.1.3 clients can use/refresh with no problem. 4.1 users (not 4.1.2/4.1.3) get an invalid object type error. I’ve cross-tested - i.e., having a 4.1.3 user try to use the variable from a 4.1 machine, just to make sure it wasn’t a user issue. The only thing that I can think of, and I really hope isn’t the case (although I fear it is), is that the object is too complicated for 4.1 to handle. Here’s how it goes.
A given FUND code can be frozen for different Ledger transaction sources. So, in a FUND_FREEZE column, we have a column for FUND, and one for each source with values Y or (null) to indicate that a fund is frozen. For
example
Fund Code:123456
Journal Entry Freeze: Y
Payroll Freeze: Y
Purchase Order Freeze: (null)
All users can see and use these objects with no problems. However, one user wanted to be able, in one column, to get a summary of which funds were frozen. To do this, I did the following:
-created separate objects with decodes to act as flags for the freeze: so, for Payroll, the Payroll Flag object is: decode(DWADMIN.FUND_FREEZE.PAYROLL_FREEZE,‘F’,'PA ',null). I think hid these objects from all users, using Designer
-created another public object FUND FREEZE DESC which concatenates the (hidden) flag objects:
@Select(Fund Freeze\CForm Flag (FF)) || @Select(Fund Freeze\Feeders Flag (FF)) || @Select(Fund Freeze\JE Flag (FF)) || @Select(Fund Freeze\Payroll Flag (FF)) || @Select(Fund Freeze\PO Flag (FF))
This is the object which 4.1.2 and 4.1.3 users can see, but which 4.1 users can’t.
====================================
Amy A. Miller, Data Analyst
University of Pennsylvania ISC
Office of Data Administration
3401 Walnut, Suite 265C /6228
Philadelphia, PA 19104-6228
Phone: 215-898-2171 Fax:215-898-0386
Email: milleraa@isc.upenn.edu
Listserv Archives (BOB member since 2002-06-25)