Re: Designer 2000 question

: 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)
: : 
: 

I recieved the following note from Oracle Canada which explains exactly how to achive what Mikki was originally trying to do (apparently either Jacob was asleep during this part of the course or he's getting bad information from Oracle Germany support:-)

> 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)
>
> I'm having trouble postings to Newsgroups for some reason. Can you pass this
> response
> on for me?
>
> Thanks,
> ____________
> Jerry Silver (JSILVER.CA)
> Vancouver Pre-sales
> Office: (604) 331-3004
> vRoute: 826-3004
> Fax: (604) 682-5235
> Internet: jsilver_at_ca.oracle.com
>
>
>

-- 
---------------------------------------------------------------------------
Felipe Vera                           Macdonald Dettwiler & Associates
vera_at_mda.ca                           13800 Commerce Pkwy, Richmond, BC
---------------------------------------------------------------------------