[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::repository

Title:Oracle CDD/Repositorynce
Notice:Current versions are V7.0-01 and V6.1-03eld Test 3
Moderator:8292::PJACOBN
Created:Thu Jan 21 1993
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1094
Total number of notes:4913

1092.0. "Defining RECORDS with FIELDs not derfined" by ORAREP::NNTPD::"[email protected]" (Harish Murthy) Fri May 30 1997 08:11

Is it possible to DEFINE RECORD, containing FIELDs, that were 
not already defined ?

For example
    I can do
            CDO> DEFINE FIELD F1 TEXT 4.
            CDO> DEFINE FIELD F2 TEXT 4.
            CDO> DEFINE FIELD F3 TEXT 4.
            CDO> DEFINE RECORD R1.
            Cont> F1.
            Cont> F2.
            Cont> F3.
            CDO> END RECORD R1.

    But I cannot do

            CDO> DEFINE RECORD R1.
            Cont>    F1 TEXT 4.
            Cont>    F2 TEXT 4.
            Cont>    F3 TEXT 4.
            CDO> END RECORD R1.

Is this possible ?
If yes, how do we do it ?

Any help would be highly appreciated.
Regards...Harish.
[Posted by WWW Notes gateway]
T.RTitleUserPersonal
Name		DateLines
1092.1no8292::PJACOBPatrick [email protected]Mon Jun 02 1997 08:116
    Hi Harish,
    
    both global fields and local fields need a defined field. Thus, I am
    afraid that what you want does not exist ( yet ? ) in CDO.
    
    Patrick
1092.2NOVA::SMITHIDon't understate or underestimate Rdb!Mon Jun 02 1997 09:564
Even in interfaces such as SQL and RDO domains (global fields) are always
defined.

Ian
1092.3problem solved; but used CDDL in stead.ORAREP::RICE::MANGARAJUTue Jun 03 1997 04:2813
    Thanks a lot for the replies.
    I'd worked with Harish (the basenoter) on this.
    
    We found that, we can do this using CDDL.
    I mean we can have a DDL file containing the DEFINE RECORD command,
    with fields, that were 'not already DEFINEd' and execute/compile
    the DDL using:
    		$CDDL <ddl filename>.
    
    One problem with CDDL though, is that, it does not support
    multiple versions.
    
    Regards...Raju.
1092.4CDDL/VERSION ? 8292::PJACOBPatrick [email protected]Tue Jun 03 1997 05:185
    Hi Raju,
    
    CDDL/VERSION creates new version if it is what you want.
    
    Patrick