OpenInsight Drop Down List (OpenInsight Specific)
At 30 JUL 1998 05:01:57PM Greg James -- [email protected] wrote:
What is the best way to use data from a table in a drop down list box. I know that you can specify what information will be displayed in the control's properties, but I want to have the contents of the drop down list box be from an OI table, so that when the table contents are changed, it is reflected in the drop down list box. Thanks.
At 30 JUL 1998 05:27PM Don Bakke wrote:
Greg,
Well how dynamic do you need it to be? If you can tolerate the list being updated based on specific events (i.e. CREATE, WRITE, READ, etc.) then simply put your code that reads all the ID's from the table and changes this control there.
If you need the list to be up to date all the time, then you can have the GOTFOCUS event of the control also lauch this code - but this may cause disatisfaction by your end users if the code takes a long time to process (i.e. tables with many keys).
If this table will never get very large, then put a QuickDex/RightDex on it and then all you need to do is read the %RECORDS% record from the data table and you already have an @FM-delimited variable ready to stuff into your list. This would be a very minimal delay.
