General information
Category:
Third party products
Well, then it may be an issue of poor database design that I'm encountering. Seeing that I'm by myself however I have no one to check that with.
I have a left join condition that could return a null value for instance, and I want to present this in the following way:
NVL(Types.cabbreviation,"NONE") as cClientGroup
so that no logic has to exist in the form or control that would have to know what to do with null. It looks like I would use the expression column in xcase, or define a virtual field in the Types table. In the first case the column for expression is not available during the view design, and in the second the virtual field doesn't show up in the available fields for the path. What would you, or anyone else do to implement this?
Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only