home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.ingres
- Path: sparky!uunet!UB.com!pacbell.com!ames!agate!usenet.ins.cwru.edu!gatech!swrinde!emory!sol.ctr.columbia.edu!The-Star.honeywell.com!umn.edu!bru!miracle!buntrock
- From: buntrock@mayo.edu (Jim Buntrock)
- Subject: Re: Choice list for tablefield in 4GL
- Message-ID: <1993Jan28.160140.8789@bmw.mayo.edu>
- Sender: newsman@bmw.mayo.edu (Usenet News Administrator)
- Reply-To: buntrock@mayo.edu
- Organization: Mayo Foundation
- References: <1993Jan28.145042.23125@pony.Ingres.COM>
- Date: Thu, 28 Jan 93 16:01:40 GMT
- Lines: 46
-
-
- ---
- In article 23125@pony.Ingres.COM, jabbate@Ingres.COM (Joe M. Abbate) writes:
- >In article <1993Jan27.224636.6022@macc.wisc.edu>, heim@vms.macc.wisc.edu
- >(JOH writes...
- >
- >>I have a column in a tablefield in Windows4GL that is a varchar. My
- >>user needs to be able to choose from a list of values for the field.
- >>There are a couple of 100 possible choices. What is the best way to
- >>implement this?
- >>
- >>Right now I'm trying to set up an option field but the choices are in
- >>a table in the DB and I don't see anyway to set up the option field
- >>with the values in the table.
- >
- >An option list is a descendant (or subclass) of EnumField, so one
- >of its attributes is ValueList, an object of type ChoiceList,
- >which is an array of ChoiceItems. You can add ChoiceItems values
- >(EnumText and EnumValue), inside a SELECT loop, either directly (by
- >assignment) or by using the AddTextItem method of ChoiceList.
- >Remember to call ChoiceItems.Clear() first and UpdChoiceList()
- >after the loop (to update the display). The Language Reference
- >Manual has an example in the System Classes chapter, under EnumField,
- >and you can also look at the Purchase_order application in appendix D
- >of the Application Editor User's Guide.
- >
-
- The above procedure will work fine, however, when the option list is displayed
- it forms a single vertical list. If you are working with more than say 20 items the
- remaining items will be displayed off the screen. The user will have no way
- of accessing the item they want. I am not sure if there is a way
- around a single vertical list for the option field. If any one knows please
- post? I have been using the tablefield as a fix.
-
-
- ///////////////////////////////
- James Buntrock
- Analyst/Programmer
- Medical Information Resources
- Mayo Clinic
- 200 First Street SW
- Rochester, MN 55905
- email - buntrock@mayo.edu
- ///////////////////////////////
-
-
-