An me again - nice monologue, but helps to get things clear...(hope so ;-))
As I replaced the Relationships by Propertiers - nothing changed ??? So as the data is still here - without deleting and reloading - are there still relations - or is the miracle somewhere else ? brg werner "Dipl.-Ing. Werner Riegler" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > This is me again: > > For everybody who wants to hellp me, there are some more details: > > Class GAS.DocumentType Extends GAS.NLSObject > Property DOCID As %Numeric; > Property DocumentType As DocumentType; > Relationship ToObjectType As GAS.DocumentTypeReference [ Cardinality = > many, Inverse = FromDocumentType ]; > Index DOCIDIndex On DOCID [ Unique ]; > Index DocumentTypeIndex On DocumentType; > > > Class GAS.ObjectType Extends GAS.NLSObject > Property DOCID As %Numeric; > Property ObjectType As ObjectType; > Relationship FromDocumentType As GAS.DocumentTypeReference [ Cardinality > = many, Inverse = ToObjectType ]; > Relationship FromObjectType As GAS.ObjectTypeReference [ Cardinality = > many, Inverse = ToObjectType ]; > Relationship ToObjectType As GAS.ObjectTypeReference [ Cardinality = > many, Inverse = FromObjectType ]; > Index DOCIDIndex On DOCID [ Unique ]; > Index ObjectTypeIndex On ObjectType; > > > Class GAS.ObjectTypeReference Extends GAS.NLSObject > Relationship FromObjectType As GAS.ObjectType [ Cardinality = one, > Inverse = ToObjectType ]; > Relationship ToObjectType As GAS.ObjectType [ Cardinality = one, Inverse > = FromObjectType ]; > > Class GAS.DocumentTypeReference Extends GAS.NLSObject > Relationship FromDocumentType As GAS.DocumentType [ Cardinality = one, > Inverse = ToObjectType ]; > Relationship ToObjectType As GAS.ObjectType [ Cardinality = one, Inverse > = FromDocumentType ]; > > The Problem is: > - After rebuilding the indices on DocumentType > SELECT * FROM GAS.DocumentType where docid=41 => o.k. > SELECT * FROM GAS.ObjectType where docid=30 => fails (no result) !!! > > - After rebuilding the indices on ObjectType > SELECT * FROM GAS.DocumentType where docid=41 => fails (no result) !!! > SELECT * FROM GAS.ObjectType where docid=30 o.k. > > My idea - but I would like also some help for this - is: > => skip the Relationships in ObjectType and DocumentType > => in ObjectTypeReference and DocumentTypeReference replace them by > unmanaged Properties of Type DocumentType, ObjectType > => use predefined Queries in ObjectType and DocumentType to get the > Relations, adopt XML Presentation by hand... > > But: what happens when I just edit > Relationship FromObjectType... to > Property FromObjectType As ObjectType; > and recompile, rebuild index ... data will be gone ? > > modify loader and load again > test what happens ... > > wonder how to use Relationships... ;-) > > happy easter > werner > > > "Dipl.-Ing. Werner Riegler" <[EMAIL PROTECTED]> schrieb > im Newsbeitrag news:[EMAIL PROTECTED] > > Hi - Help ... > > > > There are several derived Classes, > > and when I rebuild the indices in the SQL Manager > > I can access via SQL Query different Tables/Classes ??? > > > > The Class Tree (unfortunately not easy available from any tool I know > ;-)): > > > > NLSObject > > | | | > > Object ObjectType DocumentType > > DOCID DOCID DOCID > > | > > PlantStructureType > > > > There are Unique Indices on DOCID > > > > So there are at least 2 Entries in ObjectType and DocumentType > > which I can not access via SQL Query: > > > > SELECT * FROM GAS.ObjectType where DOCID = 30 > > or SELECT * FROM GAS.PlantStructureType where DOCID = 30 > > SELECT * FROM GAS.DocumentType where DOCID=41 > > > > When I rebuild the Indices for ObjectType (not for PlantStructureType !?) > > I get the DOCID 30 Row, > > but not the DOCID 41 Row from the other Table... > > > > When I rebuild the Indices for DocumentType > > I get the DOCID 41 Row, > > but not the DOCID 30 Row from the other Table... > > > > > > gosh ... > > > > what can I do ? > > - recompile whole project - done > > - rebuild indices - there are dependencies ? > > - restart cache database - done > > > > what else ? > > > > > > some more details: > > > > Class GAS.DocumentType Extends GAS.NLSObject > > Property DOCID As %Numeric; > > Index DOCIDIndex On DOCID [ Unique ]; > > > > Class GAS.ObjectType Extends GAS.NLSObject > > Property ObjectType As ObjectType; > > Index DOCIDIndex On DOCID [ Unique ]; > > > > Class GAS.PlantStructureType Extends GAS.ObjectType > > > > There are also some additional Classes to build Relations between this > > Classes... > > > > But it worked before ? > > > > > > The only thing I did, was changing an additional derived Class, > > where I first accidentally forgot to change some Types after "Copy Class". > > I had data in it but neede to delete by SQL and reload - index rebuild an > so > > on... > > > > But it was just: > > > > Class GAS.SiteStructureType Extends GAS.ObjectType [ ClassType = > > persistent, ProcedureBlock ] > > { > > > > Property ObjectType As SiteStructureType; // was first PlantStructureType > > > > > > so what to do ??? > > drop all the tables and load again ??? > > > > or have the indices to have different names ??? > > > > ??? > > > > brg > > werner > > > > > > > > > > > > > > > >
