Options in Drop-down Not on Separate Lines

Metastorm

The information in this article applies to product: e-Work 6.x

Issue

• When using the SelectSQL function, the list options in a drop-down are displayed on one line instead of separate lines.

Resolution

• The drop-down uses a comma as the row delimiter. If SelectSQL is used, a comma must be specified as the row delimiter. The alternative is to use the GetData function which has a comma as the default row delimiter. Either of the following would return a list of user names from the eUser table with each name on a separate line in the drop-down:

  %GetData(,eUser,"","eUserName")

  %SelectSQL("SELECT eUser.eUserName FROM eUser WHERE (eUser.eUserName IS NOT NULL)","","",",")

• See the Designer User Manual for additional information on these functions.