Skip to Content
0
Former Member
Jul 29, 2016 at 04:24 PM

DDDW ?

396 Views

In my evaluation of PowerBuilder for an upcoming project I am running into an issue.

I will have a form that has many combo boxes (DDDW)...

A snippet of the base table would be

STRING_ID (Integer) , STRING_OTHER (varchar(64))

There is a database table that holds the strings in it

STRING_ID , STRING, LANG_ID

So the DDDW will use this table to show the actual strings in the dropdowns for the user to select from.

My issue is that most of these fields will need to have the option for the user to select "OTHER" and than freeform in their string. So when this occurs the form needs to show this freeform string.

For example the SQL that creates the DDDW results

10 Word 1

20 Word 2

30 Word 3

1000 Other

The drop down would display correctly Word1,Word2,Word3,Other But when the user actually selects Other the form need to display the freeform text the user entered. This freeform text gets stored in the base table as. 1000 , 'This is what I typed'

if a non other item is selected it would be stored as 10,''

So far the only thing I can think of is to have my form actually have both STRING_ID and STRING_OTHER on it and in code dynamically position and size the appropriate on to display. If my form would only have a handful of these DDDW's I would go with this. But my form will have 100's of these and that .does not look like a fun task to do.

In Visual Studio C# I would know how to go about this.

Any ideas would be appreciated.

Thanks

TPS