smart data browser and additional info

[Mike Clark]

How do I get additional info into a smartdatabrowser/smartdataobject combination using V9.1D? -
A simple example is that I wish to display a column which shows the state of an order but this is held on the table as a single character and the user wishes to see a complete description.

On V8 there is a way to change the browser using a freeform query with row-displays trigger and changing the ON Display of Browser trigger.

Is there a similar solution under V9.1d for smartdatabrowsers?

Help appreciated.

 

[Stefan De Leyn]

Follow the following steps.
Define a funtion in the SDO with one input parameter (your code).
The return character is obviously the description. Then define a Calculated Field in the SDO where you call this function and the input parameter should be 'rowobject.Code' which is one of the existing fields in the SDO. Save the SDO and then you will see that the calculated field becomes a selectable field in the smartbrowser and the smartviewer.

This should do it.