From: tim.hall@tswi.spambuster.com (Tim Hall)
Subject: Re: CG_FORM_HELP question
Date: 1997/09/09
Message-ID: <341540b9.16238846@69.0.9.9>#1/1
References: <341448D3.DC1C494C@wei.org> <5v3dlc$8km@camelot.dsccc.com>
Organization: TSW International
Newsgroups: comp.databases.oracle.tools



On 9 Sep 1997 11:58:36 GMT, jstrange@imtn.dsccc.com (John Strange)
wrote:

>desc CG_FORM_HELP
>
> HLP_APPLN       N VARCHAR2(30)    application name              
> HLP_INDEX       N VARCHAR2(100)   help index                    
> HLP_MODTAB_NAME Y VARCHAR2(30)    module/table name             
> HLP_GENERATED   Y VARCHAR2(1)     help generated                
> HLP_SEQ         N NUMBER(5.0)     Sequence number
> HLP_TEXT        Y VARCHAR2(70)    help text string              
> HLP_TYPE        N VARCHAR2(1)     help type                     
> 
> HLP_TYPES are
> B       BLOCK
> C       COLUMN
> F       FORM
> M       MODULE
> T       TABLE
>
>Alistair M Fraser (afraser@wei.org) wrote:
>: Oracle Designer 2000 creates a table called CG_FORM_HELP that is used by
>: the MS
>: Help generator. I would like to access the information contained in this
>: table by a java
>: application, however the meaning of the columns seems to be
>: under-documented for
>: this purpose.
 
>: Specifically, how does the information contained in the column HLP_SEQ
>: relate to the
>: table I generated help on.
>

I assume, since HLP_TEXT is only 70 characters, that it's the column
the text should be sorted on when there is more than one line of text
for a particular object.  You will want it in your ORDER BY clause,
otherwise the help text might come in a random sequence and not make a
great deal of sense....
----------------------------------------------------
Tim Hall, TSW International, Now Indus International

http://www.tswi.com
http://www.indusgroup.com

Remove "spambuster" from email address before replying