Re: Designer 2000 question

From: Jerry Silver <jsilver_at_ca.oracle.com>
Date: 1996/02/19
Message-ID: <4gajjb$dfr_at_inet-nntp-gw-1.us.oracle.com>#1/1


I have no idea what this guy (Jacob) is ranting about. Designer/2000 is perfectly capable of generating "GUI" items, including combo boxes, that are bound to database columns. From the online help for the forms generator:  

        To generate a combo box from a detailed column usage:  

  1. Specify allowable values for the column, or assign the column to a domain.
  2. Set the Suggestion List property of the column (the column itself, not the detailed column usage) to True in the Repository Object Navigator. [or the Schema Diagrammer]
  3. Set the display datatype of the detailed column usage to one of COMBO BOX, COMBO BOX(ABBR) or COMBO BOX(MEAN)

vera_at_mda.ca (Felipe Vera) wrote:

>jcd (jcd_at_rhh.dk) wrote:
>: Mikki Hall (mhall_at_thomtech.com) wrote:
>: : We are trying to identify an attribute with a display datatype of
>: : combo box. When we generate the form, we are getting an the warning
>: : message CGEN-01407 indicating the attribute can not be displayed as
>: : a GUI item. The resulting form changes the attribute to a TEXT item.
>:
>: well Mikki - all your problems exists because you are using
>: Destroyer/2000.
>:
>: Seriously though - we have experienced the same problem, and as far as
>: we have been told (by oracle support) it just is not possible to
>: display a database field as a GUI item. This in spite of the fact that
>: Oracle's Designer/2000 course materials claims the opposite (and that
>: is not the only case (pun intended)).
>:
>: This pretty much prevents you from genereting true Windows applications
>: from Destroyer/2000 - which was the reason we had to choose not to use
>: the generator in the project we are currently working on.
>:
>: Oracle support mumbled something about this being possible in a later
>: version (now where have I heard that before)
>:
 

>Hi Jacob,
 

>This sounds pretty serious, let me make sure I understand what you mean.
 

>Typically, one would load a combo box from the result of a query or
>directly from column(s) in a table. Are you saying that if I use
>Designer/2000 to generate Developer/2000 forms I cannot do this?
 

>Being new to Oracle I'm not quite sure of the definition of a 'GUI
>item' but I'm assuming that it's your typical, text field, radio
>button, check box, list box, combo box set. If you're saying that
>by using the Designer/2000 (or Destroyer/2000) forms generator one
>cannot make these GUI items 'data aware', then I've got to wonder how
>anybody could use it for anything?
 

>Is your solution to use Developer/2000 alone?
 

>Thanks,
>Felipe
 

>--
>---------------------------------------------------------------------------
>Felipe Vera Macdonald Dettwiler & Associates
>vera_at_mda.ca 13800 Commerce Pkwy, Richmond, BC
>---------------------------------------------------------------------------
Received on Mon Feb 19 1996 - 00:00:00 CET

Original text of this message