Registered: 1158198299 Posts: 5,507
Reply with quote #1
Options in Drop-down Not on Separate Lines
Last edited: 13 Oct 2005
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.
Keywords: kb656 __________________ Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.