一篇文章了解编译类成员定义

文章目录

一篇文章了解编译类成员定义

  • Complied - 开头的表都均为编译时定义的内容。例如:属性字段,会显示继承父类的属性,类定义表则不会。
  • ^oddCOM -所有编译表的Global信息。

注:文章示例可在一篇文章了解定义类成员定义表结构查找


%Dictionary.CompiledClass - 编译类定义表

简介

新建类或更改类定义会修改此表字段。

索引
  • 取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name})
    • %Dictionary.CompiledClass.Name - 类名称
示例

增加User.HumanFinal关键字。

Class User.Human Extends (%Persistent, %Populate) [ ClassType = persistent, Final, SqlRowIdName = id ]
{
}

SQL查询该表,可以观察到Final字段为1。

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human")
^oddCOM("User.Human",2)="User.Human"
^oddCOM("User.Human",22)="~Human~"
^oddCOM("User.Human",23)="persistent"
^oddCOM("User.Human",24)="HANDLE"
^oddCOM("User.Human",25)=4
^oddCOM("User.Human",27)=1680892779
^oddCOM("User.Human",36,"%occInclude")=""
^oddCOM("User.Human",36,"%occSqlfunc")=""
^oddCOM("User.Human",36,"%systemInclude")=""
^oddCOM("User.Human",38,"%occUtility")=""
^oddCOM("User.Human",38,"%systemInclude")=""
^oddCOM("User.Human",43)="INTEGER"
^oddCOM("User.Human",45)="~User.Human~%Library.Persistent~%Library.SwizzleObject~%Library.RegisteredObject~%Library.Base~%Library.SystemBase~"
^oddCOM("User.Human",47,"HUMAN_EXTENT")=$lb("SQLUser","Human_Extent")
^oddCOM("User.Human",47,"QUERYPERSONBYNAME")=$lb("SQLUser","QueryPersonByName")
^oddCOM("User.Human",48)="%Library.PersistentProperty,%Library.CachePopulate"
^oddCOM("User.Human",49)=1
^oddCOM("User.Human",50,"User.Human.0")="66692,53827.718035"
^oddCOM("User.Human",50,"User.Human.1")="66692,53827.711134"
^oddCOM("User.Human",52)="INTEGER"
^oddCOM("User.Human",53)="SQLUser.Human"
^oddCOM("User.Human",57)="SQLUser"
^oddCOM("User.Human",58)="Human"
^oddCOM("User.Human",59)="SQLStorage"
^oddCOM("User.Human",60)="%Library.Persistent,%Library.Populate"
^oddCOM("User.Human",62,"SQLUser.Human")=$lb("SQLUser","Human")
^oddCOM("User.Human",63)="66692,53827.919521"
^oddCOM("User.Human",64)="66692,53827.335423"
^oddCOM("User.Human",74)=2016.2
^oddCOM("User.Human",77,"User.Human")=""
^oddCOM("User.Human",83)=""
^oddCOM("User.Human",89)="kc0dEu86w10"
^oddCOM("User.Human",90)="GIxw8H7ueAs"
^oddCOM("User.Human",91)="LAPTOP-ARLL3DSO:CACHE^USER"
^oddCOM("User.Human",102)="85G0k7W1jrTUlg"
表结构
字检类型描述位置检索码
Abstract%Boolean指定类不能有实例;对于数据类型,指定该类不能用作属性类型。21 s {Abstract}=$s($d(^oddCOM({L1},21))#2:^(21),1:$s($d(^oddDEF({L1},21))#2:^(21),1:0))
Ancestry%CacheStringAncestry22 s {Ancestry}=$s($d(^oddCOM({L1},22))#2:^(22),1:$s($d(^oddDEF({L1},22))#2:^(22),1:""))
CacheVersion%CacheString编译此类的版本。74 s {CacheVersion}=$s($d(^oddCOM({L1},74))#2:^(74),1:$s($d(^oddDEF({L1},74))#2:^(74),1:""))
ClassCompileError%CacheString如果出现错误,则编译此类的状态代码98 s {ClassCompileError}=$s($d(^oddCOM({L1},98))#2:^(98),1:$s($d(^oddDEF({L1},98))#2:^(98),1:""))
ClassDefinitionError%Boolean如果序列化类时出现问题,则设置为 true,以便编译器知道不要编译该类。67 s {ClassDefinitionError}=$s($d(^oddCOM({L1},67))#2:^(67),1:$s($d(^oddDEF({L1},67))#2:^(67),1:0))
ClassType%CacheString指定如何使用该类。23 s {ClassType}=$s($d(^oddCOM({L1},23))#2:^(23),1:$s($d(^oddDEF({L1},23))#2:^(23),1:""))
Classes%CacheString由此类生成的项目数组。86 n sub s {Classes}="",sub="" f s sub=$o(^oddCOM({L1},86,sub)) q:sub="" s {Classes}={Classes}_$lb($lb(sub,$g(^oddCOM({L1},86,sub))))
ClientDataType%CacheString对于数据类型类,指定通过 ActiveXJava 公开时使用的类型。数据类型类必须指定客户端数据类型。24 s {ClientDataType}=$s($d(^oddCOM({L1},24))#2:^(24),1:$s($d(^oddDEF({L1},24))#2:^(24),1:"VARCHAR"))
ClientDataTypeEnum%Integer客户端数据类型枚举25 s {ClientDataTypeEnum}=$s($d(^oddCOM({L1},25))#2:^(25),1:$s($d(^oddDEF({L1},25))#2:^(25),1:0))
ClientInfo%CacheString客户端信息26 n sub s {ClientInfo}="",sub="" f s sub=$o(^oddCOM({L1},26,sub)) q:sub="" s {ClientInfo}={ClientInfo}_$lb($lb(sub,$g(^oddCOM({L1},26,sub))))
ClientName%CacheString如果该类映射到例如 Java,则这会为该类提供一个备用名称。73 s {ClientName}=$s($d(^oddCOM({L1},73))#2:^(73),1:$s($d(^oddDEF({L1},73))#2:^(73),1:""))
CompilationSignature%CacheString编译签名27 s {CompilationSignature}=$s($d(^oddCOM({L1},27))#2:^(27),1:$s($d(^oddDEF({L1},27))#2:^(27),1:""))
CompileAfter%CacheString指示类编译器应该在指定的类之后编译此类。28 s {CompileAfter}=$s($d(^oddCOM({L1},28))#2:^(28),1:$s($d(^oddDEF({L1},28))#2:^(28),1:""))
CompileNamespace%CacheString此类编译时的命名空间,用于帮助依赖性检查。91 s {CompileNamespace}=$s($d(^oddCOM({L1},91))#2:^(91),1:$s($d(^oddDEF({L1},91))#2:^(91),1:""))
ConstraintClass%CacheString要继承的附加约束成员超类。80 s {ConstraintClass}=$s($d(^oddCOM({L1},80))#2:^(80),1:$s($d(^oddDEF({L1},80))#2:^(80),1:""))
DdlAllowed%Boolean对于持久类,指示 DDL 语句是否可用于更改或删除类定义。29 s {DdlAllowed}=$s($d(^oddCOM({L1},29))#2:^(29),1:$s($d(^oddDEF({L1},29))#2:^(29),1:0))
DependsOn%CacheString该类依赖于可运行以便该类进行编译的类的列表。84 s {DependsOn}=$s($d(^oddCOM({L1},84))#2:^(84),1:$s($d(^oddDEF({L1},84))#2:^(84),1:""))
Deployed%Integer指示该类是否已部署,即与用于构建该类的源解除关联。72 s {Deployed}=$s($d(^oddCOM({L1},72))#2:^(72),1:$s($d(^oddDEF({L1},72))#2:^(72),1:0))
Deprecated%Boolean如果此类已弃用,则为 True17 s {Deprecated}=$s($d(^oddCOM({L1},17))#2:^(17),1:$s($d(^oddDEF({L1},17))#2:^(17),1:0))
Description%CacheString指定类的描述。4 s {Description}=$s($d(^oddCOM({L1},4))#2:^(4),1:$s($d(^oddDEF({L1},4))#2:^(4),1:""))
DisableIncremental%Boolean已弃用95 s {DisableIncremental}=$s($d(^oddCOM({L1},95))#2:^(95),1:$s($d(^oddDEF({L1},95))#2:^(95),1:0))
Dynamic%Boolean已弃用30 s {Dynamic}=$s($d(^oddCOM({L1},30))#2:^(30),1:$s($d(^oddDEF({L1},30))#2:^(30),1:0))
EmbeddedClass%CacheString如果在成员类型类中指定,则为形成嵌入超类的类的名称100 s {EmbeddedClass}=$s($d(^oddCOM({L1},100))#2:^(100),1:$s($d(^oddDEF({L1},100))#2:^(100),1:""))
Extents%CacheStringExtents77 n sub s {Extents}="",sub="" f s sub=$o(^oddCOM({L1},77,sub)) q:sub="" s {Extents}={Extents}_$lb($lb(sub,$g(^oddCOM({L1},77,sub))))
Final%Boolean指定该类不能有子类。7 s {Final}=$s($d(^oddCOM({L1},7))#2:^(7),1:$s($d(^oddDEF({L1},7))#2:^(7),1:0))
GeneratedBy%CacheString如果此类是由其他组件生成的,则这是生成此类的项目的名称87 s {GeneratedBy}=$s($d(^oddCOM({L1},87))#2:^(87),1:$s($d(^oddDEF({L1},87))#2:^(87),1:""))
HasCPP%CacheString如果此类具有 C++ 方法,则为 True97 s {HasCPP}=$s($d(^oddCOM({L1},97))#2:^(97),1:$s($d(^oddDEF({L1},97))#2:^(97),1:""))
Hash%CacheString此类的哈希值,以便我们可以检测到它何时发生更改。89 s {Hash}=$s($d(^oddCOM({L1},89))#2:^(89),1:$s($d(^oddDEF({L1},89))#2:^(89),1:""))
Hidden%Boolean指定在查看类字典的内容时通常不列出该类。32 s {Hidden}=$s($d(^oddCOM({L1},32))#2:^(32),1:$s($d(^oddDEF({L1},32))#2:^(32),1:0))
Import%CacheString提供要为此类导入的类包列表。33 s {Import}=$s($d(^oddCOM({L1},33))#2:^(33),1:$s($d(^oddDEF({L1},33))#2:^(33),1:""))
Importall%CacheString全部导入34 n sub s {Importall}="",sub="" f s sub=$o(^oddCOM({L1},34,sub)) q:sub="" s {Importall}={Importall}_$lb($lb(sub,$g(^oddCOM({L1},34,sub))))
IncludeCode%CacheString指定编译此类时使用的缓存包含文件的可选列表。35 s {IncludeCode}=$s($d(^oddCOM({L1},35))#2:^(35),1:$s($d(^oddDEF({L1},35))#2:^(35),1:""))
IncludeCodeAll%CacheString包含全部代码36 n sub s {IncludeCodeAll}="",sub="" f s sub=$o(^oddCOM({L1},36,sub)) q:sub="" s {IncludeCodeAll}={IncludeCodeAll}_$lb($lb(sub,$g(^oddCOM({L1},36,sub))))
IncludeGenerator%CacheString指定编译此类的方法生成器方法时使用的缓存包含文件的可选列表。37 s {IncludeGenerator}=$s($d(^oddCOM({L1},37))#2:^(37),1:$s($d(^oddDEF({L1},37))#2:^(37),1:""))
IncludeMGenAll%CacheStringIncludeMGenAll38 n sub s {IncludeMGenAll}="",sub="" f s sub=$o(^oddCOM({L1},38,sub)) q:sub="" s {IncludeMGenAll}={IncludeMGenAll}_$lb($lb(sub,$g(^oddCOM({L1},38,sub))))
IndexClass%CacheString要继承的附加索引成员超类。81 s {IndexClass}=$s($d(^oddCOM({L1},81))#2:^(81),1:$s($d(^oddDEF({L1},81))#2:^(81),1:""))
Inheritance%CacheString定义使用多重继承时的继承顺序,如果一个成员存在于多个超类中,则哪个超类优先。92 s {Inheritance}=$s($d(^oddCOM({L1},92))#2:^(92),1:$s($d(^oddDEF({L1},92))#2:^(92),1:"left"))
InitialValue%CacheString如果指定新对象的初始序列值94 s {InitialValue}=$s($d(^oddCOM({L1},94))#2:^(94),1:$s($d(^oddDEF({L1},94))#2:^(94),1:""))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},12))#2:^(12),1:$s($d(^oddDEF({L1},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},13))#2:^(13),1:$s($d(^oddDEF({L1},13))#2:^(13),1:0))
LegacyInstanceContext%Boolean如果为 true,则将 %this 作为所有实例方法的第一个参数传递96 s {LegacyInstanceContext}=$s($d(^oddCOM({L1},96))#2:^(96),1:$s($d(^oddDEF({L1},96))#2:^(96),1:0))
Manifest%CacheString使用此类映射的项目数组,需要将其包含在我们从此类创建的任何部署包中103 n sub s {Manifest}="",sub="" f s sub=$o(^oddCOM({L1},103,sub)) q:sub="" s {Manifest}={Manifest}_$lb($lb(sub,$g(^oddCOM({L1},103,sub))))
MemberSuper%CacheString如果该类在成员继承中用作成员类,则这是要继承的类83 s {MemberSuper}=$s($d(^oddCOM({L1},83))#2:^(83),1:$s($d(^oddDEF({L1},83))#2:^(83),1:""))
ModificationAuxiliary%CacheString已弃用68 s {ModificationAuxiliary}=$s($d(^oddCOM({L1},68))#2:^(68),1:$s($d(^oddDEF({L1},68))#2:^(68),1:""))
ModificationLevel%Integer已弃用69 s {ModificationLevel}=$s($d(^oddCOM({L1},69))#2:^(69),1:$s($d(^oddDEF({L1},69))#2:^(69),1:9))
Modified%CacheString如果设置为 0,则类始终会被修改,因此它始终会被保存。40 s {Modified}=$s($d(^oddCOM({L1},40))#2:^(40),1:$s($d(^oddDEF({L1},40))#2:^(40),1:3))
Name%Dictionary.CacheClassname类名
NoContext%Boolean没有上下文42 s {NoContext}=$s($d(^oddCOM({L1},42))#2:^(42),1:$s($d(^oddDEF({L1},42))#2:^(42),1:0))
NoExtent%Boolean如果为 TRUE 将阻止此类实例化持久Extent76 s {NoExtent}=$s($d(^oddCOM({L1},76))#2:^(76),1:$s($d(^oddDEF({L1},76))#2:^(76),1:0))
OdbcType%CacheString对于数据类型类,指定通过 ODBCJDBC 公开时使用的类型。数据类型类必须指定 ODBC 类型。43 s {OdbcType}=$s($d(^oddCOM({L1},43))#2:^(43),1:$s($d(^oddDEF({L1},43))#2:^(43),1:"VARCHAR"))
OldHash%CacheString跟踪旧的哈希值,以便我们可以修改类而不将其标记为过时。101 s {OldHash}=$s($d(^oddCOM({L1},101))#2:^(101),1:$s($d(^oddDEF({L1},101))#2:^(101),1:""))
Owner%CacheString指定类及其对应表的所有者。默认情况下,类和表属于 _SYSTEM44 s {Owner}=$s($d(^oddCOM({L1},44))#2:^(44),1:$s($d(^oddDEF({L1},44))#2:^(44),1:""))
PrimarySuper%CacheString主父类45 s {PrimarySuper}=$s($d(^oddCOM({L1},45))#2:^(45),1:$s($d(^oddDEF({L1},45))#2:^(45),1:""))
ProcedureBlock%Boolean指定该类对方法代码使用过程块。46 s {ProcedureBlock}=$s($d(^oddCOM({L1},46))#2:^(46),1:$s($d(^oddDEF({L1},46))#2:^(46),1:1))
Procedures%CacheStringProcedures47 n sub s {Procedures}="",sub="" f s sub=$o(^oddCOM({L1},47,sub)) q:sub="" s {Procedures}={Procedures}_$lb($lb(sub,$g(^oddCOM({L1},47,sub))))
ProjectionClass%CacheString要继承的附加映射成员超类。82 s {ProjectionClass}=$s($d(^oddCOM({L1},82))#2:^(82),1:$s($d(^oddDEF({L1},82))#2:^(82),1:""))
PropertyClass%CacheString要继承的附加属性成员超类。48 s {PropertyClass}=$s($d(^oddCOM({L1},48))#2:^(48),1:$s($d(^oddDEF({L1},48))#2:^(48),1:""))
QueryClass%CacheString要继承的附加查询成员超类。79 s {QueryClass}=$s($d(^oddCOM({L1},79))#2:^(79),1:$s($d(^oddDEF({L1},79))#2:^(79),1:""))
RandomSig%CacheString每次编译类时都会更新的随机值102 s {RandomSig}=$s($d(^oddCOM({L1},102))#2:^(102),1:$s($d(^oddDEF({L1},102))#2:^(102),1:""))
RoutineCount%IntegerRoutine 计数49 s {RoutineCount}=$s($d(^oddCOM({L1},49))#2:^(49),1:$s($d(^oddDEF({L1},49))#2:^(49),1:0))
Routines%CacheStringRoutines50 n sub s {Routines}="",sub="" f s sub=$o(^oddCOM({L1},50,sub)) q:sub="" s {Routines}={Routines}_$lb($lb(sub,$g(^oddCOM({L1},50,sub))))
ServerOnly%CacheStringServerOnly88 s {ServerOnly}=$s($d(^oddCOM({L1},88))#2:^(88),1:$s($d(^oddDEF({L1},88))#2:^(88),1:""))
SlotCount%Integer插槽数51 s {SlotCount}=$s($d(^oddCOM({L1},51))#2:^(51),1:$s($d(^oddDEF({L1},51))#2:^(51),1:0))
SoapBindingStyle%CacheString指定该类用于通过 SOAP 发送和接收消息时所使用的 SOAP Binding70 s {SoapBindingStyle}=$s($d(^oddCOM({L1},70))#2:^(70),1:$s($d(^oddDEF({L1},70))#2:^(70),1:"document"))
SoapBodyUse%CacheString指定用于 SOAP 消息的编码。71 s {SoapBodyUse}=$s($d(^oddCOM({L1},71))#2:^(71),1:$s($d(^oddDEF({L1},71))#2:^(71),1:"literal"))
SqlCategory%CacheString对于数据类型类,指定用于 SQL 计算的类型。数据类型类必须指定 SQL 类别。52 s {SqlCategory}=$s($d(^oddCOM({L1},52))#2:^(52),1:$s($d(^oddDEF({L1},52))#2:^(52),1:"STRING"))
SqlQualifiedNameQ%CacheStringSqlQualifiedNameQ53 s {SqlQualifiedNameQ}=$s($d(^oddCOM({L1},53))#2:^(53),1:$s($d(^oddDEF({L1},53))#2:^(53),1:$g(^%qCacheObjectKey(1,"c",53))))
SqlRoutinePrefix%CacheString已弃用54 s {SqlRoutinePrefix}=$s($d(^oddCOM({L1},54))#2:^(54),1:$s($d(^oddDEF({L1},54))#2:^(54),1:""))
SqlRowIdName%CacheString对于持久类,指定用于 ID 列的备用字段名称。默认情况下,该 ID 称为 ID55 s {SqlRowIdName}=$s($d(^oddCOM({L1},55))#2:^(55),1:$s($d(^oddDEF({L1},55))#2:^(55),1:""))
SqlRowIdPrivate%Boolean对于持久类,指定 ID 列是否作为隐藏字段投影到 ODBC56 s {SqlRowIdPrivate}=$s($d(^oddCOM({L1},56))#2:^(56),1:$s($d(^oddDEF({L1},56))#2:^(56),1:0))
SqlSchemaName%CacheStringSQL 架构名称57 s {SqlSchemaName}=$s($d(^oddCOM({L1},57))#2:^(57),1:$s($d(^oddDEF({L1},57))#2:^(57),1:""))
SqlTableName%CacheString对于持久类,指定用于在 SQL 映射中标识该类的表名称。默认情况下,SQL 表名与类名相同。58 s {SqlTableName}=$s($d(^oddCOM({L1},58))#2:^(58),1:$s($d(^oddDEF({L1},58))#2:^(58),1:""))
StorageStrategy%CacheString指定用于控制此类的持久性的存储策略的名称。59 s {StorageStrategy}=$s($d(^oddCOM({L1},59))#2:^(59),1:$s($d(^oddDEF({L1},59))#2:^(59),1:""))
Structure%CacheString类“结构”的哈希值;这样我们就可以检测到SQL相关的类何时需要重新编译。90 s {Structure}=$s($d(^oddCOM({L1},90))#2:^(90),1:$s($d(^oddDEF({L1},90))#2:^(90),1:""))
Super%CacheString指定该类的一个或多个超类。60 s {Super}=$s($d(^oddCOM({L1},60))#2:^(60),1:$s($d(^oddDEF({L1},60))#2:^(60),1:""))
System%CacheString指定该类是实现的内部类。用户不应该用这个关键字来标记他们的类。61 s {System}=$s($d(^oddCOM({L1},61))#2:^(61),1:$s($d(^oddDEF({L1},61))#2:^(61),1:0))
Tables%CacheString62 n sub s {Tables}="",sub="" f s sub=$o(^oddCOM({L1},62,sub)) q:sub="" s {Tables}={Tables}_$lb($lb(sub,$g(^oddCOM({L1},62,sub))))
TimeChanged%CacheString给出对类进行最后更改的时间。63 s {TimeChanged}=$s($d(^oddCOM({L1},63))#2:^(63),1:$s($d(^oddDEF({L1},63))#2:^(63),1:""))
TimeCreated%CacheString给出类首次创建的时间。64 s {TimeCreated}=$s($d(^oddCOM({L1},64))#2:^(64),1:$s($d(^oddDEF({L1},64))#2:^(64),1:""))
TriggerClass%CacheString要继承的附加触发器成员超类。99 s {TriggerClass}=$s($d(^oddCOM({L1},99))#2:^(99),1:$s($d(^oddDEF({L1},99))#2:^(99),1:""))
ViewQuery%CacheString给出用于此类的视图定义的 SQL 查询。65 s {ViewQuery}=$s($d(^oddCOM({L1},65))#2:^(65),1:$s($d(^oddDEF({L1},65))#2:^(65),1:""))
Views%CacheString视图66 n sub s {Views}="",sub="" f s sub=$o(^oddCOM({L1},66,sub)) q:sub="" s {Views}={Views}_$lb($lb(sub,$g(^oddCOM({L1},66,sub))))
XMLData%CacheStringXMLData85 n sub s {XMLData}="",sub="" f s sub=$o(^oddCOM({L1},85,sub)) q:sub="" s {XMLData}={XMLData}_$lb($lb(sub,$g(^oddCOM({L1},85,sub))))
_Language 39 s {_Language}=$s($d(^oddCOM({L1},39))#2:^(39),1:$s($d(^oddDEF({L1},39))#2:^(39),1:"cache"))

%Dictionary.CompiledConstraint - 编译约束表

简介

创建约束定义时会自动生成改表,例如外键约约束。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"n",{%Dictionary.CompiledConstraint.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledConstraint.Name - 约束名

注:CompiledConstraint定义类中Relationship关键字字段。

示例

SQL查询该表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","n")
^oddCOM("User.Human","n","MenuFK",2)="User.Human"
^oddCOM("User.Human","n","MenuFK",5)="%Library.ConstraintForeignKey"
^oddCOM("User.Human","n","MenuFK",21)="fkey"
^oddCOM("User.Human","n","MenuFK",22)=0
^oddCOM("User.Human","n","MenuFK",23)="immediate"
^oddCOM("User.Human","n","MenuFK",24)="MenuFK"
^oddCOM("User.Human","n","MenuFK",25)="kp1"
^oddCOM("User.Human","n","MenuFK",26)=$lb($lb("kp1","%Library.String","",""))
^oddCOM("User.Human","n","MenuFK",27)="MenuFK"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Category%CacheString指定约束的类型。21 s {Category}=$s($d(^oddCOM({L1},"n",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"n",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},21))#2:^(21),1:"fkey"))
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"n",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"n",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},10))#2:^(10),1:0))
Deprecated%Boolean如果此约束已弃用,则为 True17 s {Deprecated}=$s($d(^oddCOM({L1},"n",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"n",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},17))#2:^(17),1:0))
Final%BooleanFinal7 s {Final}=$s($d(^oddCOM({L1},"n",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"n",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},7))#2:^(7),1:1))
FormalSpec%CacheString指定传递给约束的参数列表。25 s {FormalSpec}=$s($d(^oddCOM({L1},"n",{L3},25))#2:^(25),$d(^oddCOM($g(^(2),{L1}),"n",{L3},25))#2:^(25),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},25))#2:^(25),1:""))
FormalSpecParsed%CacheString正式规范解析26 s {FormalSpecParsed}=$s($d(^oddCOM({L1},"n",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"n",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},26))#2:^(26),1:""))
GeneratedFrom%CacheString指定生成此约束的类成员的名称,成员类型取决于 Category 关键字的值。27 s {GeneratedFrom}=$s($d(^oddCOM({L1},"n",{L3},27))#2:^(27),$d(^oddCOM($g(^(2),{L1}),"n",{L3},27))#2:^(27),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},27))#2:^(27),1:""))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"n",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"n",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},6))#2:^(6),1:0))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"n",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"n",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},8))#2:^(8),1:0))
Initialmode%CacheString初始模式23 s {Initialmode}=$s($d(^oddCOM({L1},"n",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"n",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},23))#2:^(23),1:""))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"n",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"n",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字已修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"n",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"n",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},13))#2:^(13),1:0))
Name%Dictionary.CacheIdentifier
NotInheritable%Boolean不可继承9 s {NotInheritable}=$s($d(^oddCOM({L1},"n",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"n",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},9))#2:^(9),1:0))
Origin%CacheString2 s {Origin}=$s($d(^oddCOM({L1},"n",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"n",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},2))#2:^(2),1:""))
Parameters%CacheString参数0 n sub s {Parameters}="",sub="" f s sub=$o(^oddCOM({L1},"n",{L3},"P",sub)) q:sub="" s {Parameters}={Parameters}_$lb($lb(sub,$s($d(^oddCOM({L1},"n",{L3},"P",sub))#2:^(sub),$d(^oddCOM($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},"P",sub))#2:^(sub),1:$g(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},"P",sub)))))
SqlName%CacheStringSQL名称24 s {SqlName}=$s($d(^oddCOM({L1},"n",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"n",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},24))#2:^(24),1:""))
Type%CacheString类型5 s {Type}=$s($d(^oddCOM({L1},"n",{L3},5))#2:^(5),$d(^oddCOM($g(^(2),{L1}),"n",{L3},5))#2:^(5),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},5))#2:^(5),1:""))
_Deferrable 22 s {_Deferrable}=$s($d(^oddCOM({L1},"n",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"n",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"n",{L3},2),{L1}),"n",{L3},22))#2:^(22),1:0))

%Dictionary.CompiledConstraintMethod - 编译约束表

简介

创建约束定义时会自动生成改表。

该表为%Dictionary.CompiledConstraint子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"n",{%Dictionary.CompiledConstraint.Name},"m",{%Dictionary.CompiledConstraintMethod.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledConstraint.Name - 约束名
  • %Dictionary.CompiledConstraintMethod.Name - 约束方法名

注:此表定义约束回调方法,自动生成。

示例

SQL查询该表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","n","MenuFK","m","Check",2)="%Library.ConstraintForeignKey"
^oddCOM("User.Human","n","MenuFK","m","Check",26)=$lb("","0")
^oddCOM("User.Human","n","MenuFK","m","Check",44)=1
^oddCOM("User.Human","n","MenuFK","m","Check",50)="%Library.String,%Library.Boolean"
^oddCOM("User.Human","n","MenuFK","m","Check",60)=$lb($lb("kp1","%Library.String","",""),$lb("lockonly","%Library.Boolean","","0"))
^oddCOM("User.Human","n","MenuFK","m","Check",69)="??"_$c(143)_"??????>."_$c(157)
^oddCOM("User.Human","n","MenuFK","m","Delete",2)="%Library.ConstraintForeignKey"
^oddCOM("User.Human","n","MenuFK","m","Delete",26)=$lb("")
^oddCOM("User.Human","n","MenuFK","m","Delete",44)=1
^oddCOM("User.Human","n","MenuFK","m","Delete",50)="%Library.String"
^oddCOM("User.Human","n","MenuFK","m","Delete",60)=$lb($lb("kp1","%Library.String","",""))
^oddCOM("User.Human","n","MenuFK","m","Delete",69)="2N;"_$c(23)_"Y#??"_$c(23)
^oddCOM("User.Human","n","MenuFK","m","SQLFKeyExists",2)="%Library.ConstraintForeignKey"
^oddCOM("User.Human","n","MenuFK","m","SQLFKeyExists",25)="s"
^oddCOM("User.Human","n","MenuFK","m","SQLFKeyExists",44)=1
^oddCOM("User.Human","n","MenuFK","m","SQLFKeyExists",69)="??pT)????"_$c(149)_"??"
^oddCOM("User.Human","n","MenuFK","m","SQLFKeyRefAction",2)="%Library.ConstraintForeignKey"
^oddCOM("User.Human","n","MenuFK","m","SQLFKeyRefAction",25)="s"
^oddCOM("User.Human","n","MenuFK","m","SQLFKeyRefAction",44)=1
^oddCOM("User.Human","n","MenuFK","m","SQLFKeyRefAction",69)="éG~"_$c(28)_"1??????"
^oddCOM("User.Human","n","MenuFK","m","Update",2)="%Library.ConstraintForeignKey"
^oddCOM("User.Human","n","MenuFK","m","Update",26)=$lb("","")
^oddCOM("User.Human","n","MenuFK","m","Update",44)=1
^oddCOM("User.Human","n","MenuFK","m","Update",50)="%Library.String,%Library.String"
^oddCOM("User.Human","n","MenuFK","m","Update",60)=$lb($lb("kp1","%Library.String","",""),$lb("nkp1","%Library.String","",""))
^oddCOM("User.Human","n","MenuFK","m","Update",69)=$zwc(661,15767,58841,19234)/*$bit(124378)*/
表结构

注:字段同%Dictionary.CompiledMethod字段。

%Dictionary.CompiledForeignKey - 编译外键表

简介

新建或更改外键并编译时会修改此表字段。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"f",{%Dictionary.CompiledForeignKey.Name}

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledForeignKey.Name - 外键名
示例

SQL查询该表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","f")
^oddCOM("User.Human","f","MenuFK",2)="User.Human"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"f",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"f",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},10))#2:^(10),1:0))
Deprecated%Boolean如果该外键已被弃用,则为真。17 s {Deprecated}=$s($d(^oddCOM({L1},"f",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"f",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},17))#2:^(17),1:0))
Description%CacheString提供外键的描述。4 s {Description}=$s($d(^oddCOM({L1},"f",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"f",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},4))#2:^(4),1:""))
Final%BooleanFinal7 s {Final}=$s($d(^oddCOM({L1},"f",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"f",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},7))#2:^(7),1:1))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"f",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"f",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},6))#2:^(6),1:0))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"f",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"f",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},8))#2:^(8),1:0))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"f",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"f",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"f",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"f",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"f",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"f",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},13))#2:^(13),1:0))
NoCheck%BooleanNoCheck27 s {NoCheck}=$s($d(^oddCOM({L1},"f",{L3},27))#2:^(27),$d(^oddCOM($g(^(2),{L1}),"f",{L3},27))#2:^(27),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},27))#2:^(27),1:0))
NotInheritable%Boolean不可继承9 s {NotInheritable}=$s($d(^oddCOM({L1},"f",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"f",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},9))#2:^(9),1:0))
OnDelete%CacheString指定从外表中删除键值时要采取的参考操作。21 s {OnDelete}=$s($d(^oddCOM({L1},"f",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"f",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},21))#2:^(21),1:"noaction"))
OnUpdate%CacheString指定当外部表中的键值更新时要采取的参考操作。22 s {OnUpdate}=$s($d(^oddCOM({L1},"f",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"f",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},22))#2:^(22),1:"noaction"))
Origin%CacheString2 s {Origin}=$s($d(^oddCOM({L1},"f",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"f",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},2))#2:^(2),1:""))
Properties%CacheString指定一个或多个属性,其值用于约束外键的值。23 s {Properties}=$s($d(^oddCOM({L1},"f",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"f",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},23))#2:^(23),1:""))
ReferencedClass%Dictionary.CacheClassname指定包含此外键定义引用的键的类的名称。24 s {ReferencedClass}=$s($d(^oddCOM({L1},"f",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"f",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},24))#2:^(24),1:""))
ReferencedKey%CacheString指定类中唯一索引的键名称,该类为此外键提供允许的值集。25 s {ReferencedKey}=$s($d(^oddCOM({L1},"f",{L3},25))#2:^(25),$d(^oddCOM($g(^(2),{L1}),"f",{L3},25))#2:^(25),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},25))#2:^(25),1:""))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"f",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"f",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},11))#2:^(11),1:0))
SqlName%CacheString指定通过 SQL 引用时该外键的备用名称。26 s {SqlName}=$s($d(^oddCOM({L1},"f",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"f",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},26))#2:^(26),1:""))

%Dictionary.CompiledIndex - 编译索引表

简介

新建或修改索引并且编译时会修改此表字段。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"i",{%Dictionary.CompiledIndex.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledIndex.Name - 索引名
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","i")
^oddCOM("User.Human","i","IDKEY",2)="User.Human"
^oddCOM("User.Human","i","IDKEY",5)="key"
^oddCOM("User.Human","i","IDKEY",10)=1
^oddCOM("User.Human","i","IDKEY",22)="001011~key~~~"
^oddCOM("User.Human","i","IDKEY",26)=1
^oddCOM("User.Human","i","IDKEY",29)="IDKEY"
^oddCOM("User.Human","i","IDKEY",30)=1
^oddCOM("User.Human","i","IDKEY",32)=1
^oddCOM("User.Human","i","IndexName",2)="User.Human"
^oddCOM("User.Human","i","IndexName",5)="index"
^oddCOM("User.Human","i","IndexName",22)="000000~index~name~~"
^oddCOM("User.Human","i","IndexName",29)="IndexName"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"f",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"f",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},10))#2:^(10),1:0))
Deprecated%Boolean如果此外键已弃用,则为 True17 s {Deprecated}=$s($d(^oddCOM({L1},"f",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"f",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},17))#2:^(17),1:0))
Description%CacheString提供外键的描述。4 s {Description}=$s($d(^oddCOM({L1},"f",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"f",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},4))#2:^(4),1:""))
Final%BooleanFinal7 s {Final}=$s($d(^oddCOM({L1},"f",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"f",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},7))#2:^(7),1:1))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"f",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"f",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},6))#2:^(6),1:0))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"f",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"f",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},8))#2:^(8),1:0))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"f",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"f",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"f",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"f",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"f",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"f",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},13))#2:^(13),1:0))
NoCheck%BooleanNoCheck27 s {NoCheck}=$s($d(^oddCOM({L1},"f",{L3},27))#2:^(27),$d(^oddCOM($g(^(2),{L1}),"f",{L3},27))#2:^(27),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},27))#2:^(27),1:0))
NotInheritable%Boolean不可继承9 s {NotInheritable}=$s($d(^oddCOM({L1},"f",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"f",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},9))#2:^(9),1:0))
OnDelete%CacheString指定从外表中删除键值时要采取的参考操作。21 s {OnDelete}=$s($d(^oddCOM({L1},"f",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"f",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},21))#2:^(21),1:"noaction"))
OnUpdate%CacheString指定当外部表中的键值更新时要采取的参考操作。22 s {OnUpdate}=$s($d(^oddCOM({L1},"f",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"f",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},22))#2:^(22),1:"noaction"))
Origin%CacheString2 s {Origin}=$s($d(^oddCOM({L1},"f",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"f",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},2))#2:^(2),1:""))
Properties%CacheString指定一个或多个属性,其值用于约束外键的值。23 s {Properties}=$s($d(^oddCOM({L1},"f",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"f",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},23))#2:^(23),1:""))
ReferencedClass%Dictionary.CacheClassname指定包含此外键定义引用的键的类的名称。24 s {ReferencedClass}=$s($d(^oddCOM({L1},"f",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"f",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},24))#2:^(24),1:""))
ReferencedKey%CacheString指定类中唯一索引的键名称,该类为此外键提供允许的值集。25 s {ReferencedKey}=$s($d(^oddCOM({L1},"f",{L3},25))#2:^(25),$d(^oddCOM($g(^(2),{L1}),"f",{L3},25))#2:^(25),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},25))#2:^(25),1:""))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"f",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"f",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},11))#2:^(11),1:0))
SqlName%CacheString指定通过 SQL 引用时该外键的备用名称。26 s {SqlName}=$s($d(^oddCOM({L1},"f",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"f",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"f",{L3},2),{L1}),"f",{L3},26))#2:^(26),1:""))

%Dictionary.CompiledIndexMethod - 编译索引方法表

简介

新建或修改索引并且编译时会修改此表字段。

该表为%Dictionary.CompiledIndex子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"i",{%Dictionary.CompiledIndex.Name},"m",{%Dictionary.CompiledIndexMethod.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledIndex.Name - 索引名
  • %Dictionary.CompiledIndexMethod.Name - 方法名。
示例

查询SQL表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","i","IndexName","m","Exists",2)="%Library.CacheIndex"
^oddCOM("User.Human","i","IndexName","m","Exists",26)=$lb("","""""")
^oddCOM("User.Human","i","IndexName","m","Exists",44)=1
^oddCOM("User.Human","i","IndexName","m","Exists",50)="%Library.String,%Library.String"
^oddCOM("User.Human","i","IndexName","m","Exists",60)=$lb($lb("K1","%Library.String","","",),$lb("id","%Library.String","&",""""""))
^oddCOM("User.Human","i","IndexName","m","Exists",69)="L??'-à??H??"
表结构

注:字段同%Dictionary.CompiledMethod字段。

%Dictionary.CompiledIndexProperty - 编译索引属性表

简介

新建或修改索引并且编译时会修改此表字段。

该表为%Dictionary.CompiledIndex子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"i",{%Dictionary.CompiledIndex.Name},"I",{%Dictionary.CompiledIndexProperty.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledIndex.Name - 索引名
  • %Dictionary.CompiledIndexProperty.Name - 索引字段

注:此表定义约束回调方法,自动生成。

示例

查询SQL表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","i","IndexName","I")=1
^oddCOM("User.Human","i","IndexName","I",1,23)="name"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Collation%CacheString排序规则21 s {Collation}=$s($d(^oddCOM({L1},"i",{L3},"I",{L5},21))#2:^(21),$d(^oddCOM($g(^(2),"*"),"I",{L5},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"i",{L3},"I",{L5},2),"*"),"I",{L5},21))#2:^(21),1:""))
CollationParms%CacheString排序规则参数22 s {CollationParms}=$s($d(^oddCOM({L1},"i",{L3},"I",{L5},22))#2:^(22),$d(^oddCOM($g(^(2),"*"),"I",{L5},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"i",{L3},"I",{L5},2),"*"),"I",{L5},22))#2:^(22),1:""))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"i",{L3},"I",{L5},12))#2:^(12),$d(^oddCOM($g(^(2),"*"),"I",{L5},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"i",{L3},"I",{L5},2),"*"),"I",{L5},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"i",{L3},"I",{L5},13))#2:^(13),$d(^oddCOM($g(^(2),"*"),"I",{L5},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"i",{L3},"I",{L5},2),"*"),"I",{L5},13))#2:^(13),1:0))
Property%CacheString属性23 s {Property}=$s($d(^oddCOM({L1},"i",{L3},"I",{L5},23))#2:^(23),$d(^oddCOM($g(^(2),"*"),"I",{L5},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"i",{L3},"I",{L5},2),"*"),"I",{L5},23))#2:^(23),1:""))

%Dictionary.CompiledInstanceVar - 编译实例变量表

简介

增加属性并编译会增加该表数据。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"v",{%Dictionary.CompiledInstanceVar.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledInstanceVar.Name - 属性名
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","v")
^oddCOM("User.Human","v","%%OID",2)="%Library.RegisteredObject"
^oddCOM("User.Human","v","%Concurrency",2)="%Library.Persistent"
^oddCOM("User.Human","v","age",2)="User.Human"
^oddCOM("User.Human","v","age",21)=""""""
^oddCOM("User.Human","v","menu",2)="User.Human"
^oddCOM("User.Human","v","menu",21)=""""""
^oddCOM("User.Human","v","name",2)="User.Human"
^oddCOM("User.Human","v","name",21)=""""""
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"v",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"v",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},10))#2:^(10),1:0))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"v",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"v",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},6))#2:^(6),1:0))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"v",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"v",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},8))#2:^(8),1:0))
InitialExpression%CacheString初始化表达式21 s {InitialExpression}=$s($d(^oddCOM({L1},"v",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"v",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},21))#2:^(21),1:""""""))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"v",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"v",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"v",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"v",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},13))#2:^(13),1:0))
ModifiedBit%Integer修改位22 s {ModifiedBit}=$s($d(^oddCOM({L1},"v",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"v",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},22))#2:^(22),1:0))
MultiDimensional%Boolean多维数组23 s {MultiDimensional}=$s($d(^oddCOM({L1},"v",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"v",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},23))#2:^(23),1:0))
NotInheritable%Boolean不可继承9 s {NotInheritable}=$s($d(^oddCOM({L1},"v",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"v",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},9))#2:^(9),1:0))
Origin%CacheString2 s {Origin}=$s($d(^oddCOM({L1},"v",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"v",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"v",{L3},2),{L1}),"v",{L3},2))#2:^(2),1:""))

%Dictionary.CompiledMethod - 编译方法表

简介

新建或修改方法并且编译时会修改此表字段。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"m",{%Dictionary.CompiledMethod.Name}

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledMethod.Name - 方法名
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","m")
^oddCOM("User.Human","m","%%OIDGet",2)="%Library.RegisteredObject"
^oddCOM("User.Human","m","%%OIDGet",44)=-1
^oddCOM("User.Human","m","%%OIDGet",72)="%%OID"
^oddCOM("User.Human","m","%%OIDIsValid",47)="%%OID.IsValid.a"
^oddCOM("User.Human","m","%%OIDSet",47)="%%OID.Set.a"
^oddCOM("User.Human","m","%1Check",2)="%Library.Persistent"
^oddCOM("User.Human","m","%1Check",44)=-1
^oddCOM("User.Human","m","%AcquireLock",2)="%Library.Persistent"

...
^oddCOM("User.Human","m","ageGet",47)="age.Get.a"
^oddCOM("User.Human","m","ageIsValid",47)="age.IsValid.a"
^oddCOM("User.Human","m","ageLogicalToDisplay",47)="age.LogicalToDisplay.a"
^oddCOM("User.Human","m","ageNormalize",47)="age.Normalize.a"
^oddCOM("User.Human","m","ageSet",47)="age.Set.a"
^oddCOM("User.Human","m","menuDisplayToLogical",47)="menu.DisplayToLogical.a"
^oddCOM("User.Human","m","menuGet",47)="menu.Get.a"
^oddCOM("User.Human","m","menuIsValid",47)="menu.IsValid.a"
^oddCOM("User.Human","m","menuLogicalToDisplay",47)="menu.LogicalToDisplay.a"
^oddCOM("User.Human","m","menuLogicalToOdbc",47)="menu.LogicalToOdbc.a"
^oddCOM("User.Human","m","menuNormalize",47)="menu.Normalize.a"
^oddCOM("User.Human","m","menuSet",47)="menu.Set.a"
^oddCOM("User.Human","m","nameDisplayToLogical",47)="name.DisplayToLogical.a"
^oddCOM("User.Human","m","nameGet",47)="name.Get.a"
^oddCOM("User.Human","m","nameIsValid",47)="name.IsValid.a"
^oddCOM("User.Human","m","nameLogicalToDisplay",47)="name.LogicalToDisplay.a"
^oddCOM("User.Human","m","nameLogicalToOdbc",47)="name.LogicalToOdbc.a"
^oddCOM("User.Human","m","nameNormalize",47)="name.Normalize.a"
^oddCOM("User.Human","m","nameSet",47)="name.Set.a"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Abstract%Boolean指定这是一个抽象方法。抽象方法没有实现,也没有为其生成可执行代码。抽象方法的存在仅仅是为了定义可以在一个或多个子类中重写和实现的方法签名或接口。21 s {Abstract}=$s($d(^oddCOM({L1},"m",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"m",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},21))#2:^(21),1:0))
ClassMethod%Boolean指定该方法是类方法。实例方法只能通过实例化的对象来调用,而类方法可以在没有对象实例的情况下直接调用。23 s {ClassMethod}=$s($d(^oddCOM({L1},"m",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"m",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},23))#2:^(23),1:0))
ClientMethod%Boolean如果为 true,则此方法仅在服务器上可用,并且将被投影为客户端方法。70 s {ClientMethod}=$s($d(^oddCOM({L1},"m",{L3},70))#2:^(70),$d(^oddCOM($g(^(2),{L1}),"m",{L3},70))#2:^(70),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},70))#2:^(70),1:0))
ClientName%CacheString客户端名称24 s {ClientName}=$s($d(^oddCOM({L1},"m",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"m",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},24))#2:^(24),1:""))
CodeMode%CacheString指定如何实现给定方法:作为例程调用、要编译的代码行、表达式或将生成结果方法或对象的方法。25 s {CodeMode}=$s($d(^oddCOM({L1},"m",{L3},25))#2:^(25),$d(^oddCOM($g(^(2),{L1}),"m",{L3},25))#2:^(25),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},25))#2:^(25),1:"code"))
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"m",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"m",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},10))#2:^(10),1:0))
DefaultArgs%CacheString默认参数26 s {DefaultArgs}=$s($d(^oddCOM({L1},"m",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"m",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},26))#2:^(26),1:""))
Deprecated%Boolean如果此方法已被弃用,则为 True17 s {Deprecated}=$s($d(^oddCOM({L1},"m",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"m",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},17))#2:^(17),1:0))
Description%CacheString指定方法的描述。4 s {Description}=$s($d(^oddCOM({L1},"m",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"m",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},4))#2:^(4),1:""))
ExternalProcName%CacheString指定外部数据库中的 SQL 过程名称。63 s {ExternalProcName}=$s($d(^oddCOM({L1},"m",{L3},63))#2:^(63),$d(^oddCOM($g(^(2),{L1}),"m",{L3},63))#2:^(63),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},63))#2:^(63),1:""))
Final%Boolean指定子类不能重写该方法的实现。7 s {Final}=$s($d(^oddCOM({L1},"m",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"m",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},7))#2:^(7),1:0))
ForceGenerate%Booleantrue 时,我们总是在每个子类中重新生成此方法,即使正常规则允许我们调用超类实现。71 s {ForceGenerate}=$s($d(^oddCOM({L1},"m",{L3},71))#2:^(71),$d(^oddCOM($g(^(2),{L1}),"m",{L3},71))#2:^(71),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},71))#2:^(71),1:0))
FormalSpec%CacheString指定传递给Execute方法的参数列表。每个参数的格式为`[&][:][=],其中&表示按引用传递,`表示仅输出。27
FormalSpecParsed%CacheString正式规范解析60 s {FormalSpecParsed}=$s($d(^oddCOM({L1},"m",{L3},60))#2:^(60),$d(^oddCOM($g(^(2),{L1}),"m",{L3},60))#2:^(60),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},60))#2:^(60),1:""))
FormalType%CacheString正式类型28 s {FormalType}=$s($d(^oddCOM({L1},"m",{L3},28))#2:^(28),$d(^oddCOM($g(^(2),{L1}),"m",{L3},28))#2:^(28),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},28))#2:^(28),1:""))
GenerateAfter%CacheString对于方法生成器方法,指定生成器应在生成列出的方法后调用。29 s {GenerateAfter}=$s($d(^oddCOM({L1},"m",{L3},29))#2:^(29),$d(^oddCOM($g(^(2),{L1}),"m",{L3},29))#2:^(29),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},29))#2:^(29),1:""))
Hash%CacheStringHash66 s {Hash}=$s($d(^oddCOM({L1},"m",{L3},66))#2:^(66),$d(^oddCOM($g(^(2),{L1}),"m",{L3},66))#2:^(66),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},66))#2:^(66),1:""))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"m",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"m",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},6))#2:^(6),1:0))
Implementation%Stream.TmpCharacter调用方法时执行的代码。对于表达式方法,这是一个表达式。对于调用方法,这是要调用的缓存例程的名称。0 s {Implementation}=""
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"m",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"m",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},8))#2:^(8),1:0))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"m",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"m",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"m",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"m",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"m",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"m",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},13))#2:^(13),1:0))
Label%CacheStringLabel31 s {Label}=$s($d(^oddCOM({L1},"m",{L3},31))#2:^(31),$d(^oddCOM($g(^(2),{L1}),"m",{L3},31))#2:^(31),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},31))#2:^(31),1:""))
NoContext%Boolean如果为 true 并且在数据类型方法中,这会阻止 * Set %val=..prop Set $this=""* 添加到属性方法中,以便您可以重写 Get/Set 方法等内容。33 s {NoContext}=$s($d(^oddCOM({L1},"m",{L3},33))#2:^(33),$d(^oddCOM($g(^(2),{L1}),"m",{L3},33))#2:^(33),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},33))#2:^(33),1:0))
NotForProperty%Boolean已弃用34 s {NotForProperty}=$s($d(^oddCOM({L1},"m",{L3},34))#2:^(34),$d(^oddCOM($g(^(2),{L1}),"m",{L3},34))#2:^(34),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},34))#2:^(34),1:0))
NotInheritable%Boolean指定该方法不在子类中继承。9 s {NotInheritable}=$s($d(^oddCOM({L1},"m",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"m",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},9))#2:^(9),1:0))
OptimizedMAC%CacheString优化的MAC35 s {OptimizedMAC}=$s($d(^oddCOM({L1},"m",{L3},35))#2:^(35),$d(^oddCOM($g(^(2),{L1}),"m",{L3},35))#2:^(35),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},35))#2:^(35),1:""))
OptimizedRun%CacheString优化运行36 s {OptimizedRun}=$s($d(^oddCOM({L1},"m",{L3},36))#2:^(36),$d(^oddCOM($g(^(2),{L1}),"m",{L3},36))#2:^(36),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},36))#2:^(36),1:""))
Origin%CacheString2 s {Origin}=$s($d(^oddCOM({L1},"m",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"m",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},2))#2:^(2),1:""))
OriginalName%CacheString源名称37 s {OriginalName}=$s($d(^oddCOM({L1},"m",{L3},37))#2:^(37),$d(^oddCOM($g(^(2),{L1}),"m",{L3},37))#2:^(37),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},37))#2:^(37),1:""))
PlaceAfter%CacheString指定类编译器应将此方法放置在它为类创建的例程中列出的方法之后。38 s {PlaceAfter}=$s($d(^oddCOM({L1},"m",{L3},38))#2:^(38),$d(^oddCOM($g(^(2),{L1}),"m",{L3},38))#2:^(38),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},38))#2:^(38),1:""))
Private%Boolean指定该方法是私有的。私有方法只能由此类或其子类的实例方法调用。39 s {Private}=$s($d(^oddCOM({L1},"m",{L3},39))#2:^(39),$d(^oddCOM($g(^(2),{L1}),"m",{L3},39))#2:^(39),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},39))#2:^(39),1:0))
ProcedureBlock%CacheString指定此方法使用方法代码的过程块。40 s {ProcedureBlock}=$s($d(^oddCOM({L1},"m",{L3},40))#2:^(40),$d(^oddCOM($g(^(2),{L1}),"m",{L3},40))#2:^(40),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},40))#2:^(40),1:""))
PublicList%CacheString指定公共列表。仅当 ProcedureBlock 关键字设置为 true 时才使用此关键字。41 s {PublicList}=$s($d(^oddCOM({L1},"m",{L3},41))#2:^(41),$d(^oddCOM($g(^(2),{L1}),"m",{L3},41))#2:^(41),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},41))#2:^(41),1:""))
ReturnResultsets%Boolean如果为 true,则此方法可能会在 %sqlcontext 中返回零个、一个或多个结果集。64 s {ReturnResultsets}=$s($d(^oddCOM({L1},"m",{L3},64))#2:^(64),$d(^oddCOM($g(^(2),{L1}),"m",{L3},64))#2:^(64),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},64))#2:^(64),1:0))
ReturnType%Dictionary.CacheClassname指定调用方法返回值的数据类型。将 ReturnType 设置为空字符串指定没有返回值。42 s {ReturnType}=$s($d(^oddCOM({L1},"m",{L3},42))#2:^(42),$d(^oddCOM($g(^(2),{L1}),"m",{L3},42))#2:^(42),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},42))#2:^(42),1:""))
ReturnTypeParams%CacheStringReturnType 关键字上的所有参数的逗号分隔列表。62 s {ReturnTypeParams}=$s($d(^oddCOM({L1},"m",{L3},62))#2:^(62),$d(^oddCOM($g(^(2),{L1}),"m",{L3},62))#2:^(62),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},62))#2:^(62),1:""))
RtnLabel%CacheStringRtnLabel43 s {RtnLabel}=$s($d(^oddCOM({L1},"m",{L3},43))#2:^(43),$d(^oddCOM($g(^(2),{L1}),"m",{L3},43))#2:^(43),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},43))#2:^(43),1:""))
Runnable%BooleanRunnable44 s {Runnable}=$s($d(^oddCOM({L1},"m",{L3},44))#2:^(44),$d(^oddCOM($g(^(2),{L1}),"m",{L3},44))#2:^(44),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},44))#2:^(44),1:0))
RuntimeClient%Boolean运行时客户端55 s {RuntimeClient}=$s($d(^oddCOM({L1},"m",{L3},55))#2:^(55),$d(^oddCOM($g(^(2),{L1}),"m",{L3},55))#2:^(55),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},55))#2:^(55),1:0))
RuntimeCodeMode%CacheString用于生成方法的 CodeMode56 s {RuntimeCodeMode}=$s($d(^oddCOM({L1},"m",{L3},56))#2:^(56),$d(^oddCOM($g(^(2),{L1}),"m",{L3},56))#2:^(56),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},56))#2:^(56),1:"code"))
RuntimeHash%CacheString运行时哈希69 s {RuntimeHash}=$s($d(^oddCOM({L1},"m",{L3},69))#2:^(69),$d(^oddCOM($g(^(2),{L1}),"m",{L3},69))#2:^(69),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},69))#2:^(69),1:""))
RuntimeLanguage%CacheString运行时语言58 s {RuntimeLanguage}=$s($d(^oddCOM({L1},"m",{L3},58))#2:^(58),$d(^oddCOM($g(^(2),{L1}),"m",{L3},58))#2:^(58),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},58))#2:^(58),1:"cache"))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"m",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"m",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},11))#2:^(11),1:0))
ServerOnly%CacheString指定方法不会投影到 JavaC++ 客户端。59 s {ServerOnly}=$s($d(^oddCOM({L1},"m",{L3},59))#2:^(59),$d(^oddCOM($g(^(2),{L1}),"m",{L3},59))#2:^(59),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},59))#2:^(59),1:""))
SoapAction%CacheString允许指定将此 Web 服务方法作为 Web 方法调用时必须使用的 HTTP SOAP 操作。对于 SOAP 1.1SOAP 操作是从 SOAPAction HTTP 标头获取的。对于 SOAP 1.2,它是从 Content-Type HTTP 标头获取的。67 s {SoapAction}=$s($d(^oddCOM({L1},"m",{L3},67))#2:^(67),$d(^oddCOM($g(^(2),{L1}),"m",{L3},67))#2:^(67),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},67))#2:^(67),1:"[default]"))
SoapBindingStyle%CacheString指定 Web 方法使用什么类型的 SOAP 调用。对于非 Web 方法,此关键字将被忽略。53 s {SoapBindingStyle}=$s($d(^oddCOM({L1},"m",{L3},53))#2:^(53),$d(^oddCOM($g(^(2),{L1}),"m",{L3},53))#2:^(53),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},53))#2:^(53),1:""))
SoapBodyUse%CacheString指定 Web 方法的输入和输出使用哪种 SOAP 编码。对于非 Web 方法,此关键字将被忽略。54 s {SoapBodyUse}=$s($d(^oddCOM({L1},"m",{L3},54))#2:^(54),$d(^oddCOM($g(^(2),{L1}),"m",{L3},54))#2:^(54),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},54))#2:^(54),1:""))
SoapMessageName%CacheString指定 Web 服务方法的响应消息正文的子元素的名称。68 s {SoapMessageName}=$s($d(^oddCOM({L1},"m",{L3},68))#2:^(68),$d(^oddCOM($g(^(2),{L1}),"m",{L3},68))#2:^(68),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},68))#2:^(68),1:""))
SoapNameSpace%CacheString覆盖此 Web 服务或 Web 服务客户端的 SOAPNAMESPACE 类参数。61 s {SoapNameSpace}=$s($d(^oddCOM({L1},"m",{L3},61))#2:^(61),$d(^oddCOM($g(^(2),{L1}),"m",{L3},61))#2:^(61),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},61))#2:^(61),1:""))
SoapRequestMessage%CacheString该关键字将反映 SOAP 请求中 SOAP 主体顶部元素的预期元素名称。需要此元素来区分具有相同 SoapAction 但不同顶级主体元素的多个请求。73 s {SoapRequestMessage}=$s($d(^oddCOM({L1},"m",{L3},73))#2:^(73),$d(^oddCOM($g(^(2),{L1}),"m",{L3},73))#2:^(73),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},73))#2:^(73),1:""))
SoapTypeNameSpace%CacheString覆盖此 Web 服务或 Web 服务客户端的 SOAPTYPENAMESPACE 类参数。65 s {SoapTypeNameSpace}=$s($d(^oddCOM({L1},"m",{L3},65))#2:^(65),$d(^oddCOM($g(^(2),{L1}),"m",{L3},65))#2:^(65),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},65))#2:^(65),1:""))
SqlName%CacheString如果此方法被映射为 SQL 存储过程,则此名称将用作存储过程的名称。45 s {SqlName}=$s($d(^oddCOM({L1},"m",{L3},45))#2:^(45),$d(^oddCOM($g(^(2),{L1}),"m",{L3},45))#2:^(45),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},45))#2:^(45),1:""))
SqlProc%Boolean指定该方法可以作为 SQL 存储过程调用。只有类方法才能作为 SQL 存储过程进行调用。46 s {SqlProc}=$s($d(^oddCOM({L1},"m",{L3},46))#2:^(46),$d(^oddCOM($g(^(2),{L1}),"m",{L3},46))#2:^(46),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},46))#2:^(46),1:0))
SqlRoutine%CacheString如果“程序”是那么这相当于 SqlProc 关键字,意味着类方法可以作为 SQL 过程调用。如果“函数”那么这个类方法就可以作为 SQL 函数来调用。74 s {SqlRoutine}=$s($d(^oddCOM({L1},"m",{L3},74))#2:^(74),$d(^oddCOM($g(^(2),{L1}),"m",{L3},74))#2:^(74),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},74))#2:^(74),1:""))
Stub%CacheString存根47 s {Stub}=$s($d(^oddCOM({L1},"m",{L3},47))#2:^(47),$d(^oddCOM($g(^(2),{L1}),"m",{L3},47))#2:^(47),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},47))#2:^(47),1:""))
StubMember%CacheString存根程袁72 s {StubMember}=$s($d(^oddCOM({L1},"m",{L3},72))#2:^(72),$d(^oddCOM($g(^(2),{L1}),"m",{L3},72))#2:^(72),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},72))#2:^(72),1:""))
TagGenerator%CacheString标签生成器48 s {TagGenerator}=$s($d(^oddCOM({L1},"m",{L3},48))#2:^(48),$d(^oddCOM($g(^(2),{L1}),"m",{L3},48))#2:^(48),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},48))#2:^(48),1:""))
UserActualType%CacheString用户实际类型50 s {UserActualType}=$s($d(^oddCOM({L1},"m",{L3},50))#2:^(50),$d(^oddCOM($g(^(2),{L1}),"m",{L3},50))#2:^(50),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},50))#2:^(50),1:""))
WebMethod%Boolean指定可以使用 SOAP 协议将方法作为 Web 方法进行调用。51 s {WebMethod}=$s($d(^oddCOM({L1},"m",{L3},51))#2:^(51),$d(^oddCOM($g(^(2),{L1}),"m",{L3},51))#2:^(51),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},51))#2:^(51),1:0))
ZenMethod%Boolean指定该方法应映射到 Web 客户端以在 Zen 框架中使用。52 s {ZenMethod}=$s($d(^oddCOM({L1},"m",{L3},52))#2:^(52),$d(^oddCOM($g(^(2),{L1}),"m",{L3},52))#2:^(52),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},52))#2:^(52),1:0))
_Language 32 s {_Language}=$s($d(^oddCOM({L1},"m",{L3},32))#2:^(32),$d(^oddCOM($g(^(2),{L1}),"m",{L3},32))#2:^(32),1:$s($d(^oddDEF($g(^oddCOM({L1},"m",{L3},2),{L1}),"m",{L3},32))#2:^(32),1:""))

%Dictionary.CompiledParameter - 编译参数表

简介

新建或修改参数并且编译时会修改此表字段。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"p",{%Dictionary.CompiledParameter.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledParameter.Name - 参数名
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","p")
^oddCOM("User.Human","p","AppName",2)="User.Human"
^oddCOM("User.Human","p","CAPTION",2)="%Library.RegisteredObject"
^oddCOM("User.Human","p","DEFAULTCONCURRENCY",2)="%Library.SwizzleObject"
^oddCOM("User.Human","p","DEFAULTGLOBAL",2)="%Library.Persistent"
^oddCOM("User.Human","p","DSINTERVAL",2)="%Library.Persistent"
^oddCOM("User.Human","p","DSTIME",2)="%Library.Persistent"
^oddCOM("User.Human","p","EXTENTQUERYSPEC",2)="%Library.Persistent"
^oddCOM("User.Human","p","EXTENTSIZE",2)="%Library.Persistent"
^oddCOM("User.Human","p","GUIDENABLED",2)="%Library.Persistent"
^oddCOM("User.Human","p","IDENTIFIEDBY",2)="%Library.Persistent"
^oddCOM("User.Human","p","IDTYPE",2)="%Library.Storage"
^oddCOM("User.Human","p","IDTYPE",9)=1
^oddCOM("User.Human","p","JAVATYPE",2)="%Library.RegisteredObject"
^oddCOM("User.Human","p","JOURNALSTREAM",2)="%Library.SwizzleObject"
^oddCOM("User.Human","p","MANAGEDEXTENT",2)="%Library.Persistent"
^oddCOM("User.Human","p","OBJJOURNAL",2)="%Library.SwizzleObject"
^oddCOM("User.Human","p","POPSPEC",2)="%Library.Populate"
^oddCOM("User.Human","p","PROPERTYVALIDATION",2)="%Library.RegisteredObject"
^oddCOM("User.Human","p","READONLY",2)="%Library.Persistent"
^oddCOM("User.Human","p","ROWLEVELSECURITY",2)="%Library.Persistent"
^oddCOM("User.Human","p","SQLENABLED",2)="%Library.Storage"
^oddCOM("User.Human","p","SQLENABLED",9)=1
^oddCOM("User.Human","p","SQLPREVENTFULLSCAN",2)="%Library.Persistent"
^oddCOM("User.Human","p","STORAGECOMPILERCLASS",2)="%Library.CacheSQLStorage"
^oddCOM("User.Human","p","STORAGECOMPILERCLASS",9)=1
^oddCOM("User.Human","p","STORAGEINTERFACE",2)="%Library.Storage"
^oddCOM("User.Human","p","STORAGEINTERFACE",9)=1
^oddCOM("User.Human","p","VERSIONCLIENTNAME",2)="%Library.Persistent"
^oddCOM("User.Human","p","VERSIONPROPERTY",2)="%Library.Persistent"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Abstract%BooleanAbstract24 s {Abstract}=$s($d(^oddCOM({L1},"p",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"p",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},24))#2:^(24),1:0))
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"p",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"p",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},10))#2:^(10),1:0))
Deprecated%Boolean如果此参数已弃用,则为 True17 s {Deprecated}=$s($d(^oddCOM({L1},"p",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"p",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},17))#2:^(17),1:0))
Description%CacheString指定参数的描述。4 s {Description}=$s($d(^oddCOM({L1},"p",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"p",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},4))#2:^(4),1:""))
Encoded%Boolean如果为 true,则参数值采用 Base64 编码。27 s {Encoded}=$s($d(^oddCOM({L1},"p",{L3},27))#2:^(27),$d(^oddCOM($g(^(2),{L1}),"p",{L3},27))#2:^(27),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},27))#2:^(27),1:0))
Expression%CacheString在编译时计算种子参数的表达式,如果指定,则优先于 Default 关键字。25 s {Expression}=$s($d(^oddCOM({L1},"p",{L3},25))#2:^(25),$d(^oddCOM($g(^(2),{L1}),"p",{L3},25))#2:^(25),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},25))#2:^(25),1:""))
Final%Boolean指定子类不能覆盖参数的定义。7 s {Final}=$s($d(^oddCOM({L1},"p",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"p",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},7))#2:^(7),1:0))
Flags%CacheString指定参数类型的任何附加修饰符标志。23 s {Flags}=$s($d(^oddCOM({L1},"p",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"p",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},23))#2:^(23),1:""))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"p",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"p",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},6))#2:^(6),1:0))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"p",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"p",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},8))#2:^(8),1:0))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"p",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"p",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"p",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"p",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"p",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"p",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},13))#2:^(13),1:0))
NotInheritable%BooleanNotInheritable9 s {NotInheritable}=$s($d(^oddCOM({L1},"p",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"p",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},9))#2:^(9),1:0))
Origin%CacheStringOrigin2 s {Origin}=$s($d(^oddCOM({L1},"p",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"p",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},2))#2:^(2),1:""))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"p",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"p",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},11))#2:^(11),1:0))
TagGenerator%CacheString标签生成器26 s {TagGenerator}=$s($d(^oddCOM({L1},"p",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"p",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},26))#2:^(26),1:""))
Type%CacheString指定参数的类型。 Studio 使用该类型为参数提供输入验证。5 s {Type}=$s($d(^oddCOM({L1},"p",{L3},5))#2:^(5),$d(^oddCOM($g(^(2),{L1}),"p",{L3},5))#2:^(5),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},5))#2:^(5),1:""))
_Constraint 21 s {_Constraint}=$s($d(^oddCOM({L1},"p",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"p",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},21))#2:^(21),1:""))
_Default 22 s {_Default}=$s($d(^oddCOM({L1},"p",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"p",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"p",{L3},2),{L1}),"p",{L3},22))#2:^(22),1:""))

%Dictionary.CompiledProjection - 编译映射表

简介

新建或修改映射并且编译时会修改此表字段。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"j",{%Dictionary.CompiledProjection.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledProjection.Name - 映射字段名

注:Projection关键字声明的字段储存。

示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","j")
^oddCOM("User.Human","j","JavaClient",2)="User.Human"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Deprecated%Boolean如果此映射已被弃用,则为真。17 s {Deprecated}=$s($d(^oddCOM({L1},"j",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"j",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},17))#2:^(17),1:0))
Description%CacheString指定映射的描述。4 s {Description}=$s($d(^oddCOM({L1},"j",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"j",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},4))#2:^(4),1:""))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"j",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"j",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"j",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"j",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"j",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"j",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},13))#2:^(13),1:0))
NotInheritable%Boolean指定该映射不在子类中继承。9 s {NotInheritable}=$s($d(^oddCOM({L1},"j",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"j",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},9))#2:^(9),1:0))
Origin%CacheStringOrigin2 s {Origin}=$s($d(^oddCOM({L1},"j",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"j",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},2))#2:^(2),1:""))
Parameters%CacheStringParameter0 n sub s {Parameters}="",sub="" f s sub=$o(^oddCOM({L1},"j",{L3},"P",sub)) q:sub="" s {Parameters}={Parameters}_$lb($lb(sub,$s($d(^oddCOM({L1},"j",{L3},"P",sub))#2:^(sub),$d(^oddCOM($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},"P",sub))#2:^(sub),1:$g(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},"P",sub)))))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"j",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"j",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},11))#2:^(11),1:0))
Type%Dictionary.CacheClassname指定与映射关联的类的名称。5 s {Type}=$s($d(^oddCOM({L1},"j",{L3},5))#2:^(5),$d(^oddCOM($g(^(2),{L1}),"j",{L3},5))#2:^(5),1:$s($d(^oddDEF($g(^oddCOM({L1},"j",{L3},2),{L1}),"j",{L3},5))#2:^(5),1:""))

%Dictionary.CompiledProperty - 编译属性表

简介

新建或修改属性并且编译时会修改此表字段。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"a",{%Dictionary.CompiledProperty.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledProperty.Name - 属性名
示例

查询SQL表:
在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","a")
^oddCOM("User.Human","a","%%OID",2)="%Library.RegisteredObject"
^oddCOM("User.Human","a","%%OID","P","CALCSELECTIVITY")=1
^oddCOM("User.Human","a","%%OID","P","CAPTION")=""
^oddCOM("User.Human","a","%%OID","P","EXTERNALSQLNAME")=""
^oddCOM("User.Human","a","%%OID","P","EXTERNALSQLTYPE")=""
^oddCOM("User.Human","a","%%OID","P","JAVATYPE")=""
^oddCOM("User.Human","a","%%OID","P","POPORDER")=""
^oddCOM("User.Human","a","%%OID","P","POPSPEC")=""
^oddCOM("User.Human","a","%%OID","m","IsValid",2)="%Library.CacheLiteral"
^oddCOM("User.Human","a","%%OID","m","IsValid",44)=-1
^oddCOM("User.Human","a","%%OID","m","IsValid",69)=$c(130,151,146,157)_"""U0÷"
^oddCOM("User.Human","a","%%OID","m","Set",2)="%Library.CacheLiteral"
^oddCOM("User.Human","a","%%OID","m","Set",39)=1
^oddCOM("User.Human","a","%%OID","m","Set",44)=-1
^oddCOM("User.Human","a","%%OID","m","Set",69)=-1
^oddCOM("User.Human","a","%Concurrency",2)="%Library.Persistent"
^oddCOM("User.Human","a","%Concurrency","P","CALCSELECTIVITY")=1
^oddCOM("User.Human","a","%Concurrency","P","CAPTION")=""
^oddCOM("User.Human","a","%Concurrency","P","EXTERNALSQLNAME")=""
^oddCOM("User.Human","a","%Concurrency","P","EXTERNALSQLTYPE")=""
^oddCOM("User.Human","a","%Concurrency","P","JAVATYPE")=""
^oddCOM("User.Human","a","%Concurrency","P","POPORDER")=""
^oddCOM("User.Human","a","%Concurrency","P","POPSPEC")=""
^oddCOM("User.Human","a","%Concurrency","m","Get",2)="%Library.CacheLiteral"
^oddCOM("User.Human","a","%Concurrency","m","Get",42)="%Library.CacheString"
^oddCOM("User.Human","a","%Concurrency","m","Get",44)=-1
^oddCOM("User.Human","a","%Concurrency","m","Get",69)=-1
^oddCOM("User.Human","a","%Concurrency","m","IsValid",2)="%Library.CacheLiteral"
^oddCOM("User.Human","a","%Concurrency","m","IsValid",44)=-1
^oddCOM("User.Human","a","%Concurrency","m","IsValid",69)=$c(130,151,146,157)_"""U0÷"
^oddCOM("User.Human","a","age",2)="User.Human"
^oddCOM("User.Human","a","age",5)="%Library.Integer"
^oddCOM("User.Human","a","age",40)="%Library.Integer"
^oddCOM("User.Human","a","age",47)="age"
^oddCOM("User.Human","a","age",50)=1
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Aliases%CacheString该属性的别名列表。58 s {Aliases}=$s($d(^oddCOM({L1},"a",{L3},58))#2:^(58),$d(^oddCOM($g(^(2),{L1}),"a",{L3},58))#2:^(58),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},58))#2:^(58),1:""))
Calculated%Boolean指定在实例化包含该属性的对象时,没有为其分配内存存储。23 s {Calculated}=$s($d(^oddCOM({L1},"a",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"a",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},23))#2:^(23),1:0))
Cardinality%CacheString指定关系属性的基数。关系属性需要 Cardinality 关键字。它被非关系属性忽略。24 s {Cardinality}=$s($d(^oddCOM({L1},"a",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"a",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},24))#2:^(24),1:""))
ClientName%CacheString客户端名称26 s {ClientName}=$s($d(^oddCOM({L1},"a",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"a",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},26))#2:^(26),1:""))
Collection%CacheString指定属性是集合属性以及它是什么类型的集合。27 s {Collection}=$s($d(^oddCOM({L1},"a",{L3},27))#2:^(27),$d(^oddCOM($g(^(2),{L1}),"a",{L3},27))#2:^(27),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},27))#2:^(27),1:""))
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"a",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"a",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},10))#2:^(10),1:0))
ComputeDependency%CacheStringSQLCOMPUTECODE 引用的属性列表。54 s {ComputeDependency}=$s($d(^oddCOM({L1},"a",{L3},54))#2:^(54),$d(^oddCOM($g(^(2),{L1}),"a",{L3},54))#2:^(54),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},54))#2:^(54),1:""))
ComputeTriggers%CacheString当此属性更改时要计算的属性列表。55 s {ComputeTriggers}=$s($d(^oddCOM({L1},"a",{L3},55))#2:^(55),$d(^oddCOM($g(^(2),{L1}),"a",{L3},55))#2:^(55),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},55))#2:^(55),1:""))
Deprecated%Boolean如果此属性已被弃用,则为真。17 s {Deprecated}=$s($d(^oddCOM({L1},"a",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"a",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},17))#2:^(17),1:0))
Description%CacheString指定属性的描述。4 s {Description}=$s($d(^oddCOM({L1},"a",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"a",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},4))#2:^(4),1:""))
DirectRefOnGet%Boolean已弃用29 s {DirectRefOnGet}=$s($d(^oddCOM({L1},"a",{L3},29))#2:^(29),$d(^oddCOM($g(^(2),{L1}),"a",{L3},29))#2:^(29),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},29))#2:^(29),1:0))
DirectRefOnSet%Boolean已弃用30 s {DirectRefOnSet}=$s($d(^oddCOM({L1},"a",{L3},30))#2:^(30),$d(^oddCOM($g(^(2),{L1}),"a",{L3},30))#2:^(30),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},30))#2:^(30),1:0))
Final%Boolean指定子类不能覆盖此属性的定义。7 s {Final}=$s($d(^oddCOM({L1},"a",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"a",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},7))#2:^(7),1:0))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"a",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"a",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},6))#2:^(6),1:0))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"a",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"a",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},8))#2:^(8),1:0))
InitialExpression%CacheString指定属性的初始值。31 s {InitialExpression}=$s($d(^oddCOM({L1},"a",{L3},31))#2:^(31),$d(^oddCOM($g(^(2),{L1}),"a",{L3},31))#2:^(31),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},31))#2:^(31),1:""""""))
Internal%Boolean如果为真,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"a",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"a",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},14))#2:^(14),1:0))
Inverse%CacheString指定关系的反面名称。即相关类中对应关系属性的名称。逆属性必须存在于相关类中并且具有正确的基数值。关系属性需要 Inverse 关键字。它被非关系属性忽略。32 s {Inverse}=$s($d(^oddCOM({L1},"a",{L3},32))#2:^(32),$d(^oddCOM($g(^(2),{L1}),"a",{L3},32))#2:^(32),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},32))#2:^(32),1:""))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"a",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"a",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"a",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"a",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},13))#2:^(13),1:0))
MultiDimensional%Boolean指定属性具有多维数组的特征。33 s {MultiDimensional}=$s($d(^oddCOM({L1},"a",{L3},33))#2:^(33),$d(^oddCOM($g(^(2),{L1}),"a",{L3},33))#2:^(33),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},33))#2:^(33),1:0))
NoModBit%Boolean已弃用53 s {NoModBit}=$s($d(^oddCOM({L1},"a",{L3},53))#2:^(53),$d(^oddCOM($g(^(2),{L1}),"a",{L3},53))#2:^(53),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},53))#2:^(53),1:0))
NotInheritable%Boolean已弃用9 s {NotInheritable}=$s($d(^oddCOM({L1},"a",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"a",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},9))#2:^(9),1:0))
OnDelete%CacheString指定从外表中删除键值时要采取的参考操作。59 s {OnDelete}=$s($d(^oddCOM({L1},"a",{L3},59))#2:^(59),$d(^oddCOM($g(^(2),{L1}),"a",{L3},59))#2:^(59),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},59))#2:^(59),1:""))
Origin%CacheStringOrigin2 s {Origin}=$s($d(^oddCOM({L1},"a",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"a",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},2))#2:^(2),1:""))
Parameters%CacheString参数0 n sub s {Parameters}="",sub="" f s sub=$o(^oddCOM({L1},"a",{L3},"P",sub)) q:sub="" s {Parameters}={Parameters}_$lb($lb(sub,$s($d(^oddCOM({L1},"a",{L3},"P",sub))#2:^(sub),$d(^oddCOM($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},"P",sub))#2:^(sub),1:$g(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},"P",sub)))))
Private%Boolean指定该属性是私有的。私有属性只能由此类或其子类的实例方法使用。35 s {Private}=$s($d(^oddCOM({L1},"a",{L3},35))#2:^(35),$d(^oddCOM($g(^(2),{L1}),"a",{L3},35))#2:^(35),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},35))#2:^(35),1:0))
ReadOnly%Boolean指定该属性是只读的。52 s {ReadOnly}=$s($d(^oddCOM({L1},"a",{L3},52))#2:^(52),$d(^oddCOM($g(^(2),{L1}),"a",{L3},52))#2:^(52),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},52))#2:^(52),1:0))
Relationship%Boolean指定属性是关系属性。36 s {Relationship}=$s($d(^oddCOM({L1},"a",{L3},36))#2:^(36),$d(^oddCOM($g(^(2),{L1}),"a",{L3},36))#2:^(36),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},36))#2:^(36),1:0))
Required%Boolean对于持久类,指定必须先为属性的值指定一个值,然后才能将其存储到磁盘。37 s {Required}=$s($d(^oddCOM({L1},"a",{L3},37))#2:^(37),$d(^oddCOM($g(^(2),{L1}),"a",{L3},37))#2:^(37),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},37))#2:^(37),1:0))
RuntimeType%CacheString运行时类型40 s {RuntimeType}=$s($d(^oddCOM({L1},"a",{L3},40))#2:^(40),$d(^oddCOM($g(^(2),{L1}),"a",{L3},40))#2:^(40),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},40))#2:^(40),1:""))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"a",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"a",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},11))#2:^(11),1:0))
ServerOnly%CacheString指定属性不会投影到 JavaC++ 客户端。57 s {ServerOnly}=$s($d(^oddCOM({L1},"a",{L3},57))#2:^(57),$d(^oddCOM($g(^(2),{L1}),"a",{L3},57))#2:^(57),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},57))#2:^(57),1:""))
SqlCollation%CacheString已弃用42 s {SqlCollation}=$s($d(^oddCOM({L1},"a",{L3},42))#2:^(42),$d(^oddCOM($g(^(2),{L1}),"a",{L3},42))#2:^(42),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},42))#2:^(42),1:""))
SqlColumnNumber%CacheString显式设置此属性的 SQL 列号。这是为了支持遗留应用程序而提供的。43 s {SqlColumnNumber}=$s($d(^oddCOM({L1},"a",{L3},43))#2:^(43),$d(^oddCOM($g(^(2),{L1}),"a",{L3},43))#2:^(43),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},43))#2:^(43),1:""))
SqlComputeCode%CacheString指定计算字段值的 ObjectScript 代码。44 s {SqlComputeCode}=$s($d(^oddCOM({L1},"a",{L3},44))#2:^(44),$d(^oddCOM($g(^(2),{L1}),"a",{L3},44))#2:^(44),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},44))#2:^(44),1:""))
SqlComputeOnChange%CacheString指定一个或多个属性,其修改将触发 SQL 中此计算字段的重新计算。46 s {SqlComputeOnChange}=$s($d(^oddCOM({L1},"a",{L3},46))#2:^(46),$d(^oddCOM($g(^(2),{L1}),"a",{L3},46))#2:^(46),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},46))#2:^(46),1:""))
SqlComputed%Boolean指定此属性是 SQL 计算字段。45 s {SqlComputed}=$s($d(^oddCOM({L1},"a",{L3},45))#2:^(45),$d(^oddCOM($g(^(2),{L1}),"a",{L3},45))#2:^(45),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},45))#2:^(45),1:0))
SqlFieldName%CacheString对于持久类,指定用于标识其 SQL 映射中的属性的列名。默认情况下,SQL列名称与属性名称相同。47 s {SqlFieldName}=$s($d(^oddCOM({L1},"a",{L3},47))#2:^(47),$d(^oddCOM($g(^(2),{L1}),"a",{L3},47))#2:^(47),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},47))#2:^(47),1:""))
SqlListDelimiter%CacheString指定 SQL 中用于列表的分隔符。这是为了支持遗留应用程序而提供的。48 s {SqlListDelimiter}=$s($d(^oddCOM({L1},"a",{L3},48))#2:^(48),$d(^oddCOM($g(^(2),{L1}),"a",{L3},48))#2:^(48),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},48))#2:^(48),1:""))
SqlListType%CacheString指定用于列表的表示形式。49 s {SqlListType}=$s($d(^oddCOM({L1},"a",{L3},49))#2:^(49),$d(^oddCOM($g(^(2),{L1}),"a",{L3},49))#2:^(49),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},49))#2:^(49),1:""))
Storable%Boolean可储存50 s {Storable}=$s($d(^oddCOM({L1},"a",{L3},50))#2:^(50),$d(^oddCOM($g(^(2),{L1}),"a",{L3},50))#2:^(50),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},50))#2:^(50),1:0))
Transient%Boolean对于持久类,指定该属性不存储在数据库中。51 s {Transient}=$s($d(^oddCOM({L1},"a",{L3},51))#2:^(51),$d(^oddCOM($g(^(2),{L1}),"a",{L3},51))#2:^(51),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},51))#2:^(51),1:0))
Type%Dictionary.CacheClassname指定与属性关联的类的名称,该类可以是数据类型类、持久类或可嵌入串行类。5 s {Type}=$s($d(^oddCOM({L1},"a",{L3},5))#2:^(5),$d(^oddCOM($g(^(2),{L1}),"a",{L3},5))#2:^(5),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},5))#2:^(5),1:""))
_Identity 56 s {_Identity}=$s($d(^oddCOM({L1},"a",{L3},56))#2:^(56),$d(^oddCOM($g(^(2),{L1}),"a",{L3},56))#2:^(56),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},2),{L1}),"a",{L3},56))#2:^(56),1:0))

%Dictionary.CompiledPropertyMethod - 编译属性方法表

简介

新建或修改属性并且编译时会修改此表字段。

该表为%Dictionary.CompiledProperty子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"a",{%Dictionary.CompiledProperty.Name},"m",{%Dictionary.CompiledPropertyMethod.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledProperty.Name - 属性名
  • %Dictionary.CompiledPropertyMethod.Name - 方法名。
示例

查询SQL表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","a","age","m","DisplayToLogical",2)="%Library.Integer"
^oddCOM("User.Human","a","age","m","DisplayToLogical",69)=";??&??S5"_$c(151,138)
^oddCOM("User.Human","a","age","m","Get",2)="%Library.CacheLiteral"
^oddCOM("User.Human","a","age","m","Get",42)="%Library.Integer"
^oddCOM("User.Human","a","age","m","Get",44)=-1
^oddCOM("User.Human","a","age","m","Get",69)=-1
^oddCOM("User.Human","a","age","m","IsValid",2)="%Library.Integer"
^oddCOM("User.Human","a","age","m","IsValid",69)=$c(141)_"5"_$c(7)_"????{"_$c(31)_"??"
^oddCOM("User.Human","a","age","m","LogicalToDisplay",2)="%Library.Integer"
^oddCOM("User.Human","a","age","m","LogicalToDisplay",43)="-2:Same"
^oddCOM("User.Human","a","age","m","LogicalToDisplay",69)="A"_$c(151)_"I¤6J??@"
^oddCOM("User.Human","a","age","m","Normalize",2)="%Library.Integer"
^oddCOM("User.Human","a","age","m","Set",2)="%Library.CacheLiteral"
^oddCOM("User.Human","a","age","m","Set",44)=-1
^oddCOM("User.Human","a","age","m","Set",69)=-1

注:字段同%Dictionary.CompiledMethod字段。

%Dictionary.CompiledPropertyUDLText - 编译UDL表

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"a",{%Dictionary.CompiledProperty.Name},"u",{%Dictionary.CompiledPropertyUDLText.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledProperty.Name - 属性名
  • %Dictionary.CompiledPropertyUDLText.Name - UDLText名。
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Category%CacheStringCategory23 s {Category}=$s($d(^oddCOM({L1},"a",{L3},"u",{L5},23))#2:^(23),$d(^oddCOM($g(^(2),"*"),"u",{L5},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},"u",{L5},2),"*"),"u",{L5},23))#2:^(23),1:"comment"))
Content%Stream.TmpCharacter保存 UDL 文本的内容。0 s {Content}=""
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"a",{L3},"u",{L5},12))#2:^(12),$d(^oddCOM($g(^(2),"*"),"u",{L5},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},"u",{L5},2),"*"),"u",{L5},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"a",{L3},"u",{L5},13))#2:^(13),$d(^oddCOM($g(^(2),"*"),"u",{L5},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},"u",{L5},2),"*"),"u",{L5},13))#2:^(13),1:0))
Position%CacheString位置24 s {Position}=$s($d(^oddCOM({L1},"a",{L3},"u",{L5},24))#2:^(24),$d(^oddCOM($g(^(2),"*"),"u",{L5},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},"u",{L5},2),"*"),"u",{L5},24))#2:^(24),1:"body"))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"a",{L3},"u",{L5},11))#2:^(11),$d(^oddCOM($g(^(2),"*"),"u",{L5},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},"u",{L5},2),"*"),"u",{L5},11))#2:^(11),1:0))
TextType%Integer文本类型22 s {TextType}=$s($d(^oddCOM({L1},"a",{L3},"u",{L5},22))#2:^(22),$d(^oddCOM($g(^(2),"*"),"u",{L5},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"a",{L3},"u",{L5},2),"*"),"u",{L5},22))#2:^(22),1:0))

%Dictionary.CompiledQuery - 编译Query

简介

新建或修改Query定义并且编译时会修改此表字段。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"q",{%Dictionary.CompiledQuery.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledQuery.Name - Query
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","q")
^oddCOM("User.Human","q","Extent",2)="%Library.Persistent"
^oddCOM("User.Human","q","Extent",5)="%Library.ExtentSQLQuery"
^oddCOM("User.Human","q","Extent",21)=$lb($lb($lb("ID",5,"ID")),"",$lb(1,"User.Human"))
^oddCOM("User.Human","q","Extent",22)="ID"
^oddCOM("User.Human","q","Extent",23)=$lb("ID")
^oddCOM("User.Human","q","Extent",25)=""
^oddCOM("User.Human","q","Extent",27)="Human_Extent"
^oddCOM("User.Human","q","Extent",29)=" SELECT id FROM SQLUser.Human"
^oddCOM("User.Human","q","Extent",31)="Extent"
^oddCOM("User.Human","q","Extent",34)=""
^oddCOM("User.Human","q","Extent",38)=$lb("",$lb($lb("","")))
^oddCOM("User.Human","q","Extent",40)=1
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Cardinality%IntegerCardinality40 s {Cardinality}=$s($d(^oddCOM({L1},"q",{L3},40))#2:^(40),$d(^oddCOM($g(^(2),{L1}),"q",{L3},40))#2:^(40),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},40))#2:^(40),1:0))
ClientInfo%CacheStringClientInfo21 s {ClientInfo}=$s($d(^oddCOM({L1},"q",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"q",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},21))#2:^(21),1:""))
ClientName%CacheStringClientName41 s {ClientName}=$s($d(^oddCOM({L1},"q",{L3},41))#2:^(41),$d(^oddCOM($g(^(2),{L1}),"q",{L3},41))#2:^(41),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},41))#2:^(41),1:""))
ColCaptions%CacheString列描述22 s {ColCaptions}=$s($d(^oddCOM({L1},"q",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"q",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},22))#2:^(22),1:""))
ColNames%CacheString列名称23 s {ColNames}=$s($d(^oddCOM({L1},"q",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"q",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},23))#2:^(23),1:""))
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"q",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"q",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},10))#2:^(10),1:0))
Deprecated%Boolean如果此查询已弃用,则为 True17 s {Deprecated}=$s($d(^oddCOM({L1},"q",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"q",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},17))#2:^(17),1:0))
Description%CacheString指定查询的描述。4 s {Description}=$s($d(^oddCOM({L1},"q",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"q",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},4))#2:^(4),1:""))
ExtendedInfo%CacheString扩展信息38 s {ExtendedInfo}=$s($d(^oddCOM({L1},"q",{L3},38))#2:^(38),$d(^oddCOM($g(^(2),{L1}),"q",{L3},38))#2:^(38),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},38))#2:^(38),1:""))
Final%Boolean指定子类不能覆盖查询的定义。7 s {Final}=$s($d(^oddCOM({L1},"q",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"q",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},7))#2:^(7),1:0))
FormalSpec%CacheString指定传递给Execute方法的参数列表。每个参数的格式为`[&][:][=],其中&表示按引用传递,`表示仅输出。
FormalSpecParsed%CacheString正式规范解析34 s {FormalSpecParsed}=$s($d(^oddCOM({L1},"q",{L3},34))#2:^(34),$d(^oddCOM($g(^(2),{L1}),"q",{L3},34))#2:^(34),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},34))#2:^(34),1:""))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"q",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"q",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},6))#2:^(6),1:0))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"q",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"q",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},8))#2:^(8),1:0))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"q",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"q",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"q",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"q",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"q",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"q",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},13))#2:^(13),1:0))
NotInheritable%Boolean已弃用9 s {NotInheritable}=$s($d(^oddCOM({L1},"q",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"q",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},9))#2:^(9),1:0))
Origin%CacheStringOrigin2 s {Origin}=$s($d(^oddCOM({L1},"q",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"q",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},2))#2:^(2),1:""))
Parameters%CacheString参数0 n sub s {Parameters}="",sub="" f s sub=$o(^oddCOM({L1},"q",{L3},"P",sub)) q:sub="" s {Parameters}={Parameters}_$lb($lb(sub,$s($d(^oddCOM({L1},"q",{L3},"P",sub))#2:^(sub),$d(^oddCOM($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},"P",sub))#2:^(sub),1:$g(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},"P",sub)))))
ParmNames%CacheString参数名称25 s {ParmNames}=$s($d(^oddCOM({L1},"q",{L3},25))#2:^(25),$d(^oddCOM($g(^(2),{L1}),"q",{L3},25))#2:^(25),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},25))#2:^(25),1:""))
Private%Boolean已弃用26 s {Private}=$s($d(^oddCOM({L1},"q",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"q",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},26))#2:^(26),1:0))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"q",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"q",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},11))#2:^(11),1:0))
SoapBindingStyle%CacheString指定 Web 方法使用什么类型的 SOAP 调用。对于非 Web 方法,此关键字将被忽略。35 s {SoapBindingStyle}=$s($d(^oddCOM({L1},"q",{L3},35))#2:^(35),$d(^oddCOM($g(^(2),{L1}),"q",{L3},35))#2:^(35),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},35))#2:^(35),1:""))
SoapBodyUse%CacheString指定 Web 方法的输入和输出使用哪种 SOAP 编码。对于非 Web 方法,此关键字将被忽略。36 s {SoapBodyUse}=$s($d(^oddCOM({L1},"q",{L3},36))#2:^(36),$d(^oddCOM($g(^(2),{L1}),"q",{L3},36))#2:^(36),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},36))#2:^(36),1:""))
SoapNameSpace%CacheStringSoapNameSpace37 s {SoapNameSpace}=$s($d(^oddCOM({L1},"q",{L3},37))#2:^(37),$d(^oddCOM($g(^(2),{L1}),"q",{L3},37))#2:^(37),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},37))#2:^(37),1:""))
SqlName%CacheString如果此查询被映射为 SQL 存储过程,则此名称将用作存储过程的名称。27 s {SqlName}=$s($d(^oddCOM({L1},"q",{L3},27))#2:^(27),$d(^oddCOM($g(^(2),{L1}),"q",{L3},27))#2:^(27),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},27))#2:^(27),1:""))
SqlProc%Boolean指定查询可以作为 SQL 存储过程调用。28 s {SqlProc}=$s($d(^oddCOM({L1},"q",{L3},28))#2:^(28),$d(^oddCOM($g(^(2),{L1}),"q",{L3},28))#2:^(28),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},28))#2:^(28),1:0))
SqlQuery%CacheString指定用于基于 SQL 的查询的 SQL 语句。29 s {SqlQuery}=$s($d(^oddCOM({L1},"q",{L3},29))#2:^(29),$d(^oddCOM($g(^(2),{L1}),"q",{L3},29))#2:^(29),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},29))#2:^(29),1:""))
SqlQueryGen%CacheStringSqlQueryGen39 s {SqlQueryGen}=$s($d(^oddCOM({L1},"q",{L3},39))#2:^(39),$d(^oddCOM($g(^(2),{L1}),"q",{L3},39))#2:^(39),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},39))#2:^(39),1:""))
SqlView%Boolean指定是否将此查询映射为 SQL 视图。30 s {SqlView}=$s($d(^oddCOM({L1},"q",{L3},30))#2:^(30),$d(^oddCOM($g(^(2),{L1}),"q",{L3},30))#2:^(30),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},30))#2:^(30),1:0))
SqlViewName%CacheString指定从此查询映射的视图的 SQL 别名。31 s {SqlViewName}=$s($d(^oddCOM({L1},"q",{L3},31))#2:^(31),$d(^oddCOM($g(^(2),{L1}),"q",{L3},31))#2:^(31),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},31))#2:^(31),1:""))
Type%Dictionary.CacheClassname指定用于提供查询接口实现的Query 类。5 s {Type}=$s($d(^oddCOM({L1},"q",{L3},5))#2:^(5),$d(^oddCOM($g(^(2),{L1}),"q",{L3},5))#2:^(5),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},5))#2:^(5),1:""))
UserActualType%CacheStringUserActualType32 s {UserActualType}=$s($d(^oddCOM({L1},"q",{L3},32))#2:^(32),$d(^oddCOM($g(^(2),{L1}),"q",{L3},32))#2:^(32),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},32))#2:^(32),1:""))
WebMethod%Boolean指定可以使用 SOAP 协议调用此查询。33 s {WebMethod}=$s($d(^oddCOM({L1},"q",{L3},33))#2:^(33),$d(^oddCOM($g(^(2),{L1}),"q",{L3},33))#2:^(33),1:$s($d(^oddDEF($g(^oddCOM({L1},"q",{L3},2),{L1}),"q",{L3},33))#2:^(33),1:0))

%Dictionary.CompiledQueryMethod - 编译Query方法表

简介

新建或修改Query定义并且编译时会修改此表字段。

该表为%Dictionary.CompiledQuery子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"q",{%Dictionary.CompiledQuery.Name},"m",{%Dictionary.CompiledQueryMethod.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledQuery.Name - Query
  • %Dictionary.CompiledQueryMethod.Name - 方法名。
示例

查询SQL表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","q","QueryPersonByName","m","Close",2)="%Library.SQLQuery"
^oddCOM("User.Human","q","QueryPersonByName","m","Close",44)=1
^oddCOM("User.Human","q","QueryPersonByName","m","Close",69)=$c(17)_"{??INì"_$c(10)_"°"
^oddCOM("User.Human","q","QueryPersonByName","m","Execute",2)="%Library.SQLQuery"
^oddCOM("User.Human","q","QueryPersonByName","m","Execute",26)=$lb("","""""")
^oddCOM("User.Human","q","QueryPersonByName","m","Execute",44)=1
^oddCOM("User.Human","q","QueryPersonByName","m","Execute",50)="%Library.Binary,%Library.String"
^oddCOM("User.Human","q","QueryPersonByName","m","Execute",60)=$lb($lb("%qHandle","%Library.Binary","&",""),$lb("name","%Library.String","",""""""))
^oddCOM("User.Human","q","QueryPersonByName","m","Execute",69)=$c(155)_"??§ü????????"
^oddCOM("User.Human","q","QueryPersonByName","m","Fetch",2)="%Library.SQLQuery"
^oddCOM("User.Human","q","QueryPersonByName","m","Fetch",44)=1
^oddCOM("User.Human","q","QueryPersonByName","m","Fetch",69)="ì"_$c(29)_"=·R"_$c(0)_"??±"
^oddCOM("User.Human","q","QueryPersonByName","m","FetchRows",2)="%Library.SQLQuery"
^oddCOM("User.Human","q","QueryPersonByName","m","FetchRows",44)=1
^oddCOM("User.Human","q","QueryPersonByName","m","FetchRows",69)="TB????N·??"_$c(131)
^oddCOM("User.Human","q","QueryPersonByName","m","Func",2)="%Library.SQLQuery"
^oddCOM("User.Human","q","QueryPersonByName","m","Func",26)=$lb("""""")
^oddCOM("User.Human","q","QueryPersonByName","m","Func",44)=1
^oddCOM("User.Human","q","QueryPersonByName","m","Func",50)="%Library.String"
^oddCOM("User.Human","q","QueryPersonByName","m","Func",60)=$lb($lb("name","%Library.String","",""""""))
^oddCOM("User.Human","q","QueryPersonByName","m","Func",69)="c??V"_$c(142)_"u!3x"
^oddCOM("User.Human","q","QueryPersonByName","m","GetInfo",2)="%Library.SQLQuery"
^oddCOM("User.Human","q","QueryPersonByName","m","GetInfo",44)=1
^oddCOM("User.Human","q","QueryPersonByName","m","GetInfo",69)="I"_$c(155)_"??k3J"_$c(129)_"??"
^oddCOM("User.Human","q","QueryPersonByName","m","GetODBCInfo",2)="%Library.Query"
^oddCOM("User.Human","q","QueryPersonByName","m","GetODBCInfo",44)=1
^oddCOM("User.Human","q","QueryPersonByName","m","GetODBCInfo",69)=$c(146)_"??"_$c(21,158,7)_"M""ü"
^oddCOM("User.Human","q","QueryPersonByName","m","Prepare",2)="%Library.Query"
^oddCOM("User.Human","q","QueryPersonByName","m","SendODBC",2)="%Library.SQLQuery"
^oddCOM("User.Human","q","QueryPersonByName","m","SendODBC",44)=1
^oddCOM("User.Human","q","QueryPersonByName","m","SendODBC",69)="é"_$c(140,27)_"??????¨f"
表结构

注:字段同%Dictionary.CompiledMethod字段。

%Dictionary.CompiledStorage - 编译Storage

简介

新建或修改Storage定义并编译时会修改此表字段。

该表为%Dictionary.CompiledClassn子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","s")
^oddCOM("User.Human","s","Default")=""
^oddCOM("User.Human","s","Default",5)="%Library.CacheStorage"
^oddCOM("User.Human","s","Default",11)=15
^oddCOM("User.Human","s","Default",21)="^User.HumanD"
^oddCOM("User.Human","s","Default",22)="HumanDefaultData"
^oddCOM("User.Human","s","Default",24)="^User.HumanD"
^oddCOM("User.Human","s","Default",25)="^User.HumanI"
^oddCOM("User.Human","s","Default",33)="^User.HumanS"
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"s",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"s",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},10))#2:^(10),1:0))
CounterLocation%CacheString指定类型为 %Library.Counter 的属性的计数器的基本位置。通常,这将是Global引用,例如 ^User.PersonCGlobal引用还可以包括一个或多个前导下标。36 s {CounterLocation}=$s($d(^oddCOM({L1},"s",{L3},36))#2:^(36),$d(^oddCOM($g(^(2),{L1}),"s",{L3},36))#2:^(36),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},36))#2:^(36),1:""))
DataLocation%CacheString指定表达式,该表达式是该类的数据存储位置。通常,这将是Global引用,例如 ^User.PersonDGlobal引用还可以包括一个或多个前导下标。21 s {DataLocation}=$s($d(^oddCOM({L1},"s",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"s",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},21))#2:^(21),1:""))
DefaultData%CacheString指定类编译器数据结构生成器用来放置任何以前未存储的属性的 DATA 定义的名称。如果属性可存储,但未在任何 DATA 定义中列出,则该属性未存储。22 s {DefaultData}=$s($d(^oddCOM({L1},"s",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"s",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},22))#2:^(22),1:""))
Deprecated%Boolean如果此存储已弃用,则为 true17 s {Deprecated}=$s($d(^oddCOM({L1},"s",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"s",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},17))#2:^(17),1:0))
Description%CacheString指定存储定义的描述。此描述由在线课程参考显示。4 s {Description}=$s($d(^oddCOM({L1},"s",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"s",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},4))#2:^(4),1:""))
ExtentSize%CacheString范围大小34 s {ExtentSize}=$s($d(^oddCOM({L1},"s",{L3},34))#2:^(34),$d(^oddCOM($g(^(2),{L1}),"s",{L3},34))#2:^(34),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},34))#2:^(34),1:""))
Final`%Boolean指定子类不能修改存储定义。7 s {Final}=$s($d(^oddCOM({L1},"s",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"s",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},7))#2:^(7),1:0))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"s",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"s",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},6))#2:^(6),1:0))
IdExpression%CacheStringId 表达式23 s {IdExpression}=$s($d(^oddCOM({L1},"s",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"s",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},23))#2:^(23),1:""))
IdFunction%CacheString指定用于分配新 id 值的系统函数。37 s {IdFunction}=$s($d(^oddCOM({L1},"s",{L3},37))#2:^(37),$d(^oddCOM($g(^(2),{L1}),"s",{L3},37))#2:^(37),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},37))#2:^(37),1:""))
IdLocation%CacheString指定 ID 计数器的位置。24 s {IdLocation}=$s($d(^oddCOM({L1},"s",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"s",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},24))#2:^(24),1:""))
IndexLocation%CacheString指定用于此类索引的Global。如果未指定,则索引位置为 ^MyApp.MyClassI,其中 MyApp.MyClass 是类名。25 s {IndexLocation}=$s($d(^oddCOM({L1},"s",{L3},25))#2:^(25),$d(^oddCOM($g(^(2),{L1}),"s",{L3},25))#2:^(25),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},25))#2:^(25),1:""))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"s",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"s",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},8))#2:^(8),1:0))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"s",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"s",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"s",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"s",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字已修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"s",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"s",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},13))#2:^(13),1:0))
NotInheritable%BooleanNotInheritable9 s {NotInheritable}=$s($d(^oddCOM({L1},"s",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"s",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},9))#2:^(9),1:0))
Origin%CacheStringOrigin2 s {Origin}=$s($d(^oddCOM({L1},"s",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"s",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},2))#2:^(2),1:""))
RootClass%Boolean根类26 s {RootClass}=$s($d(^oddCOM({L1},"s",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"s",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},26))#2:^(26),1:0))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"s",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"s",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},11))#2:^(11),1:0))
SqlChildSub%CacheStringSqlChildSub27 s {SqlChildSub}=$s($d(^oddCOM({L1},"s",{L3},27))#2:^(27),$d(^oddCOM($g(^(2),{L1}),"s",{L3},27))#2:^(27),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},27))#2:^(27),1:""))
SqlIdExpression%CacheStringSqlIdExpression28 s {SqlIdExpression}=$s($d(^oddCOM({L1},"s",{L3},28))#2:^(28),$d(^oddCOM($g(^(2),{L1}),"s",{L3},28))#2:^(28),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},28))#2:^(28),1:""))
SqlRowIdName%CacheString指定映射到 SQL 的行 ID 列的名称。29 s {SqlRowIdName}=$s($d(^oddCOM({L1},"s",{L3},29))#2:^(29),$d(^oddCOM($g(^(2),{L1}),"s",{L3},29))#2:^(29),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},29))#2:^(29),1:""))
SqlRowIdProperty%CacheString指定 SQL RowId 属性。此关键字仅由从早期 产品迁移的类使用。30 s {SqlRowIdProperty}=$s($d(^oddCOM({L1},"s",{L3},30))#2:^(30),$d(^oddCOM($g(^(2),{L1}),"s",{L3},30))#2:^(30),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},30))#2:^(30),1:""))
SqlTableNumber%CacheString指定内部 SQL 表编号。此关键字仅由从早期 产品迁移的类使用。31 s {SqlTableNumber}=$s($d(^oddCOM({L1},"s",{L3},31))#2:^(31),$d(^oddCOM($g(^(2),{L1}),"s",{L3},31))#2:^(31),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},31))#2:^(31),1:""))
State%CacheString对于串行嵌入类,此关键字指定使用哪个数据定义来定义对象的序列化状态。这也是默认结构生成器将添加未存储属性的默认数据定义。32 s {State}=$s($d(^oddCOM({L1},"s",{L3},32))#2:^(32),$d(^oddCOM($g(^(2),{L1}),"s",{L3},32))#2:^(32),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},32))#2:^(32),1:""))
StreamLocation%CacheString指定用于存储此类中任何流属性的默认Global值。如果未指定,则索引位置为 ^MyApp.MyClassS,其中 MyApp.MyClass 是类名。33 s {StreamLocation}=$s($d(^oddCOM({L1},"s",{L3},33))#2:^(33),$d(^oddCOM($g(^(2),{L1}),"s",{L3},33))#2:^(33),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},33))#2:^(33),1:""))
Type%Dictionary.CacheClassname指定用于为此类提供持久性的存储类。5 s {Type}=$s($d(^oddCOM({L1},"s",{L3},5))#2:^(5),$d(^oddCOM($g(^(2),{L1}),"s",{L3},5))#2:^(5),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},5))#2:^(5),1:""))
VersionLocation%CacheString指定%Version计数器的位置。35 s {VersionLocation}=$s($d(^oddCOM({L1},"s",{L3},35))#2:^(35),$d(^oddCOM($g(^(2),{L1}),"s",{L3},35))#2:^(35),1:$s($d(^oddDEF($g(^oddCOM({L1},"s",{L3},2),{L1}),"s",{L3},35))#2:^(35),1:""))

%Dictionary.CompiledStorageData - 编译Storage节点表

简介

新建或修改StorageData定义编译时会修改此表字段。

该表为%Dictionary.CompiledStorage子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"D",{%Dictionary.CompiledStorageData.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageData.Name - 数据节点名
示例

查询SQL表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","s","Default","D","HumanDefaultData")=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",1)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",1,21)="%%CLASSNAME"
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",2)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",2,21)="name"
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",3)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",3,21)="age"
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",4)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",4,21)="menu"
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",5)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",5,21)="role"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Attribute%CacheStringAttribute0 s {Attribute}=$g(^oddCOM({L1},"s",{L3},"D",{L5},21),$g(^%qCacheObjectKey(1,"D",21)))
KeywordError%Boolean关键字错误0 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"D",{L5},12),$g(^%qCacheObjectKey(1,"D",12)))
KeywordModified%Boolean关键字已修改0 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"D",{L5},13),$g(^%qCacheObjectKey(1,"D",13)))
Structure%CacheString指定如何将数据存储到Global节点中。0 s {Structure}=$g(^oddCOM({L1},"s",{L3},"D",{L5},22),$g(^%qCacheObjectKey(1,"D",22)))
Subscript%CacheString下标0 s {Subscript}=$g(^oddCOM({L1},"s",{L3},"D",{L5},23),$g(^%qCacheObjectKey(1,"D",23)))

%Dictionary.CompiledStorageDataValue - 编译Storage节点值表

简介

新建或修改StorageDataValue定义编译时会修改此表字段。

该表为%Dictionary.CompiledStorageData子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"D",{%Dictionary.CompiledStorageData.Name},"V",{%Dictionary.CompiledStorageDataValue.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageData.Name - 数据节点名
  • %Dictionary.CompiledStorageDataValue.Name - 节点顺序
示例

查询SQL表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",1)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",1,21)="%%CLASSNAME"
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",2)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",2,21)="name"
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",3)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",3,21)="age"
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",4)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",4,21)="menu"
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",5)=""
^oddCOM("User.Human","s","Default","D","HumanDefaultData","V",5,21)="role"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
KeywordError%Boolean关键字错误12 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"D",{L5},"V",{L7},12),$g(^%qCacheObjectKey(1,"V",12)))
KeywordModified%Boolean关键字已修改13 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"D",{L5},"V",{L7},13),$g(^%qCacheObjectKey(1,"V",13)))
Value%CacheString21 s {Value}=$g(^oddCOM({L1},"s",{L3},"D",{L5},"V",{L7},21),$g(^%qCacheObjectKey(1,"V",21)))

%Dictionary.CompiledStorageIndex - 编译Storage索引表

简介

新建或修改StorageIndex定义编译时会修改此表字段。

该表为%Dictionary.CompiledStorage子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"X",{%Dictionary.CompiledStorageIndex.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageIndex.Name - 索引名

注:此表储存类关键字指定StorageStrategy

示例

查询SQL表:
在这里插入图片描述
Global示例:

^oddCOM("User.Human","s","Default","X","IndexName")=""
^oddCOM("User.Human","s","Default","X","IndexName",21)="^User.HumanI"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
KeywordError%Boolean关键字错误12 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"X",{L5},12),$g(^%qCacheObjectKey(1,"X",12)))
KeywordModified%Boolean关键字已修改13 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"X",{L5},13),$g(^%qCacheObjectKey(1,"X",13)))
Location%CacheString位置21 s {Location}=$g(^oddCOM({L1},"s",{L3},"X",{L5},21),$g(^%qCacheObjectKey(1,"X",21)))

%Dictionary.CompiledStorageProperty - 编译Storage属性表

简介

新建或修改StorageProperty定义编译时会修改此表字段。

进行调优表时会自动添加该属性,调优表时需要表存在数据。

该表为%Dictionary.CompiledStorage子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"M",{%Dictionary.CompiledStorageProperty.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageProperty.Name - 属性名

注:获取属性离散值,选择性。

示例

查询SQL表:

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-PwYVfkMA-1692500074319)(C:\Users\hp\AppData\Roaming\Typora\typora-user-images\image-20230819145417537.png)]

Global示例:

USER>zw ^oddCOM("User.Status","s","Default","M")
^oddCOM("User.Status","s","Default","M","%%CLASSNAME")=""
^oddCOM("User.Status","s","Default","M","%%CLASSNAME",21)="100.0000%"
^oddCOM("User.Status","s","Default","M","%%CLASSNAME",26)=1
^oddCOM("User.Status","s","Default","M","%%ID")=""
^oddCOM("User.Status","s","Default","M","%%ID",21)=1
^oddCOM("User.Status","s","Default","M","%%ID",26)=1.1
^oddCOM("User.Status","s","Default","M","code")=""
^oddCOM("User.Status","s","Default","M","code",21)="33.3333%"
^oddCOM("User.Status","s","Default","M","code",26)=3
^oddCOM("User.Status","s","Default","M","name")=""
^oddCOM("User.Status","s","Default","M","name",21)="33.3333%"
^oddCOM("User.Status","s","Default","M","name",26)=2
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
AverageFieldSize%CacheString平均字段大小26 s {AverageFieldSize}=$g(^oddCOM({L1},"s",{L3},"M",{L5},26),$g(^%qCacheObjectKey(1,"M",26)))
BiasQueriesAsOutlier%CacheString将查询作为异常值进行偏置25 s {BiasQueriesAsOutlier}=$g(^oddCOM({L1},"s",{L3},"M",{L5},25),$g(^%qCacheObjectKey(1,"M",25)))
ChildBlockCount%CacheString子块计数27 s {ChildBlockCount}=$g(^oddCOM({L1},"s",{L3},"M",{L5},27),$g(^%qCacheObjectKey(1,"M",27)))
ChildExtentSize%CacheString子区大小23 s {ChildExtentSize}=$g(^oddCOM({L1},"s",{L3},"M",{L5},23),$g(^%qCacheObjectKey(1,"M",23)))
KeywordError%Boolean关键字错误12 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"M",{L5},12),$g(^%qCacheObjectKey(1,"M",12)))
KeywordModified%Boolean关键字已修改13 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"M",{L5},13),$g(^%qCacheObjectKey(1,"M",13)))
OutlierSelectivity%CacheString异常值选择性24 s {OutlierSelectivity}=$g(^oddCOM({L1},"s",{L3},"M",{L5},24),$g(^%qCacheObjectKey(1,"M",24)))
Selectivity%CacheStringSelectivity21 s {Selectivity}=$g(^oddCOM({L1},"s",{L3},"M",{L5},21),$g(^%qCacheObjectKey(1,"M",21)))
StreamLocation%CacheString流位置22 s {StreamLocation}=$g(^oddCOM({L1},"s",{L3},"M",{L5},22),$g(^%qCacheObjectKey(1,"M",22)))

%Dictionary.CompiledStorageSQLMap - 编译StorageSQL映射表

简介

新建或修改StorageSQLMap定义编译时会修改此表字段。

此表为储存定义为SQLStorage时生效。

该表为%Dictionary.CompiledStorage子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageProperty.Name - 映射字段名
示例

查询SQL表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","s","SQLStorage","S","Master")=""
^oddCOM("User.Human","s","SQLStorage","S","Master",5)="data"
^oddCOM("User.Human","s","SQLStorage","S","Master",24)="^User.Human"
^oddCOM("User.Human","s","SQLStorage","S","Master",26)="nonnull"
^oddCOM("User.Human","s","SQLStorage","S","Master","B",1)=""
^oddCOM("User.Human","s","SQLStorage","S","Master","B",1,24)="{id}"
^oddCOM("User.Human","s","SQLStorage","S","Master","R",1)=""
^oddCOM("User.Human","s","SQLStorage","S","Master","R",1,21)="{L1}"
^oddCOM("User.Human","s","SQLStorage","S","Master","R",1,22)="id"
^oddCOM("User.Human","s","SQLStorage","S","Master","T","age")=""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","age",21)="""^"""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","age",23)=2
^oddCOM("User.Human","s","SQLStorage","S","Master","T","menu")=""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","menu",21)="""^"""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","menu",23)=3
^oddCOM("User.Human","s","SQLStorage","S","Master","T","name")=""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","name",21)="""^"""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","name",23)=1
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
BlockCount%Integer块数29 s {BlockCount}=$g(^oddCOM({L1},"s",{L3},"S",{L5},29),$g(^%qCacheObjectKey(1,"S",29)))
Condition%CacheString条件21 s {Condition}=$g(^oddCOM({L1},"s",{L3},"S",{L5},21),$g(^%qCacheObjectKey(1,"S",21)))
ConditionFields%CacheString条件字段23 s {ConditionFields}=$g(^oddCOM({L1},"s",{L3},"S",{L5},23),$g(^%qCacheObjectKey(1,"S",23)))
ConditionalWithHostVars%Boolean有条件的主机变量22 s {ConditionalWithHostVars}=$g(^oddCOM({L1},"s",{L3},"S",{L5},22),$g(^%qCacheObjectKey(1,"S",22)))
KeywordError%Boolean关键字错误12 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"S",{L5},12),$g(^%qCacheObjectKey(1,"S",12)))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"S",{L5},13),$g(^%qCacheObjectKey(1,"S",13)))
PopulationPct%CacheString填充百分比25 s {PopulationPct}=$g(^oddCOM({L1},"s",{L3},"S",{L5},25),$g(^%qCacheObjectKey(1,"S",25)))
PopulationType%CacheString填充类型26 s {PopulationType}=$g(^oddCOM({L1},"s",{L3},"S",{L5},26),$g(^%qCacheObjectKey(1,"S",26)))
RowReference%CacheString行引用27 s {RowReference}=$g(^oddCOM({L1},"s",{L3},"S",{L5},27),$g(^%qCacheObjectKey(1,"S",27)))
Structure%CacheString结构28 s {Structure}=$g(^oddCOM({L1},"s",{L3},"S",{L5},28),$g(^%qCacheObjectKey(1,"S",28)))
Type%CacheString指定这是什么类型的映射。5 s {Type}=$g(^oddCOM({L1},"s",{L3},"S",{L5},5),$g(^%qCacheObjectKey(1,"S",5)))
_Global 24 s {_Global}=$g(^oddCOM({L1},"s",{L3},"S",{L5},24),$g(^%qCacheObjectKey(1,"S",24)))

%Dictionary.CompiledStorageSQLMapData - 编译StorageSQL映射数据表

简介

新建或修改StorageSQLMapData定义编译时会修改此表字段。

此表为储存定义为SQLStorage时生效。

该表为%Dictionary.CompiledStorageSQLMap子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"T",{%Dictionary.CompiledStorageSQLMapData.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageProperty.Name - 映射字段名
  • %Dictionary.CompiledStorageSQLMapData.Name - 映射属性名
示例

查询SQL表:

在这里插入图片描述

Global示例:

^oddCOM("User.Human","s","SQLStorage","S","Master","T","age")=""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","age",21)="""^"""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","age",23)=2
^oddCOM("User.Human","s","SQLStorage","S","Master","T","menu")=""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","menu",21)="""^"""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","menu",23)=3
^oddCOM("User.Human","s","SQLStorage","S","Master","T","name")=""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","name",21)="""^"""
^oddCOM("User.Human","s","SQLStorage","S","Master","T","name",23)=1
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Delimiter%CacheString分隔符21 s {Delimiter}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"T",{L7},21),$g(^%qCacheObjectKey(1,"T",21)))
KeywordError%Boolean关键字错误12 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"T",{L7},12),$g(^%qCacheObjectKey(1,"T",12)))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"T",{L7},13),$g(^%qCacheObjectKey(1,"T",13)))
Node%CacheString节点22 s {Node}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"T",{L7},22),$g(^%qCacheObjectKey(1,"T",22)))
Piece%CacheString位置23 s {Piece}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"T",{L7},23),$g(^%qCacheObjectKey(1,"T",23)))
RetrievalCode%CacheString检索码24 s {RetrievalCode}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"T",{L7},24),$g(^%qCacheObjectKey(1,"T",24)))

%Dictionary.CompiledStorageSQLMapRowIdSpec - 编译StorageSQL映射行位置字段表

简介

新建或修改StorageSQLMapRowIdSpec定义编译时会修改此表字段。

此表为储存定义为SQLStorage时生效。

该表为%Dictionary.CompiledStorageSQLMap子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"R",{%Dictionary.CompiledStorageSQLMapRowIdSpec.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageProperty.Name - 映射字段名
  • %Dictionary.CompiledStorageSQLMapRowIdSpec.Name - 行位置属性名
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","s","SQLStorage","S","Master","R")
^oddCOM("User.Human","s","SQLStorage","S","Master","R",1)=""
^oddCOM("User.Human","s","SQLStorage","S","Master","R",1,21)="{L1}"
^oddCOM("User.Human","s","SQLStorage","S","Master","R",1,22)="id"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Expression%CacheString表达式0 s {Expression}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"R",{L7},21),$g(^%qCacheObjectKey(1,"R",21)))
Field%CacheString字段0 s {Field}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"R",{L7},22),$g(^%qCacheObjectKey(1,"R",22)))
KeywordError%Boolean关键字错误0 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"R",{L7},12),$g(^%qCacheObjectKey(1,"R",12)))
KeywordModified%Boolean关键字修改0 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"R",{L7},13),$g(^%qCacheObjectKey(1,"R",13)))

%Dictionary.CompiledStorageSQLMapSub - 编译StorageSQLMapSub

简介

新建或修改StorageSQLMapSub定义时会修改此表字段。

此表为储存定义为SQLStorage时生效。

该表为%Dictionary.CompiledStorageSQLMap子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"B",{%Dictionary.CompiledStorageSQLMapSub.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageProperty.Name - 映射字段名
  • %Dictionary.CompiledStorageSQLMapSub.Name - 序号名
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","s","SQLStorage","S","Master","B")
^oddCOM("User.Human","s","SQLStorage","S","Master","B",1)=""
^oddCOM("User.Human","s","SQLStorage","S","Master","B",1,24)="{id}"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
AccessType%CacheString接入类型21 s {AccessType}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},21),$g(^%qCacheObjectKey(1,"B",21)))
DataAccess%CacheString数据存取22 s {DataAccess}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},22),$g(^%qCacheObjectKey(1,"B",22)))
Delimiter%CacheString分隔符23 s {Delimiter}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},23),$g(^%qCacheObjectKey(1,"B",23)))
Expression%CacheString表达式24 s {Expression}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},24),$g(^%qCacheObjectKey(1,"B",24)))
KeywordError%Boolean关键字错误12 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},12),$g(^%qCacheObjectKey(1,"B",12)))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},13),$g(^%qCacheObjectKey(1,"B",13)))
LoopInitValue%CacheString循环初始值25 s {LoopInitValue}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},25),$g(^%qCacheObjectKey(1,"B",25)))
NextCode%CacheString下一个代码26 s {NextCode}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},26),$g(^%qCacheObjectKey(1,"B",26)))
NullMarker%CacheString空标记27 s {NullMarker}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},27),$g(^%qCacheObjectKey(1,"B",27)))
StartValue%CacheString起始值28 s {StartValue}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},28),$g(^%qCacheObjectKey(1,"B",28)))
StopExpression%CacheString停止表达29 s {StopExpression}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},29),$g(^%qCacheObjectKey(1,"B",29)))
StopValue%CacheString结束值30 s {StopValue}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},30),$g(^%qCacheObjectKey(1,"B",30)))

%Dictionary.CompiledStorageSQLMapSubAccessvar - 编译StorageSQLMapSubAccessvar

简介

新建或修改StorageSQLMapSubAccessvar定义时会修改此表字段。

此表为储存定义为SQLStorage时生效。

该表为%Dictionary.CompiledStorageSQLMapSub子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"B",{%Dictionary.CompiledStorageSQLMapSub.Name},"A",{%Dictionary.CompiledStorageSQLMapSubAccessvar.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageProperty.Name - 映射字段名
  • %Dictionary.CompiledStorageSQLMapSub.Name - 序号名
  • %Dictionary.CompiledStorageSQLMapSubAccessvar.Name - 变量名
示例

查询SQL表:

在这里插入图片描述

Global示例:

IMP>zw ^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B","1","A")
^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B",1,"A",1)=""
^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B",1,"A",1,21)=" s {1D1}=$zu(67,3,{L1})"
^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B",1,"A",1,22)="{1D1}"
^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B",1,"A",2)=""
^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B",1,"A",2,21)=" s {1D2}="""""
^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B",1,"A",2,22)="{1D2}"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Code%CacheString代码21 s {Code}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},"A",{L9},21),$g(^%qCacheObjectKey(1,"A",21)))
KeywordError%Boolean关键字错误12 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},"A",{L9},12),$g(^%qCacheObjectKey(1,"A",12)))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},"A",{L9},13),$g(^%qCacheObjectKey(1,"A",13)))
Variable%CacheString变量22 s {Variable}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},"A",{L9},22),$g(^%qCacheObjectKey(1,"A",22)))

%Dictionary.CompiledStorageSQLMapSubInvalidcondition - 编译CompiledStorageSQLMapSubInvalidcondition

简介

新建或修改StorageSQLMapSubInvalidcondition定义时会修改此表字段。

此表为储存定义为SQLStorage时生效。

该表为%Dictionary.CompiledStorageSQLMapSub子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"B",{%Dictionary.CompiledStorageSQLMapSub.Name},"N",{%Dictionary.CompiledStorageSQLMapSubInvalidcondition.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledStorage.Name - Storage
  • %Dictionary.CompiledStorageProperty.Name - 映射字段名
  • %Dictionary.CompiledStorageSQLMapSub.Name - 序号名
  • %Dictionary.CompiledStorageSQLMapSubInvalidcondition.Name - 条件名
示例

查询SQ表:

在这里插入图片描述

Global示例:

^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B",1,"N",1)=""
^oddCOM("%SYS.ProcessQuery","s","Process","S","Map1","B",1,"N",1,21)="##Class(%SYS.ProcessQuery).AllowToOpen({L1})'=1"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Expression%CacheString表达式21 s {Expression}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},"N",{L9},21),$g(^%qCacheObjectKey(1,"N",21)))
KeywordError%Boolean关键字错误12 s {KeywordError}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},"N",{L9},12),$g(^%qCacheObjectKey(1,"N",12)))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$g(^oddCOM({L1},"s",{L3},"S",{L5},"B",{L7},"N",{L9},13),$g(^%qCacheObjectKey(1,"N",13)))

%Dictionary.CompiledTrigger - 编译触发器表

简介

新建或修改触发器编译时会修改此表字段。

该表为%Dictionary.ClassDefinition子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"t",{%Dictionary.CompiledTrigger.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledTrigger.Name - 触发器名
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","t")
^oddCOM("User.Human","t","%OBJGUID",2)="%Library.Persistent"
^oddCOM("User.Human","t","%OBJJRND",2)="%Library.Persistent"
^oddCOM("User.Human","t","%OBJJRNIU",2)="%Library.Persistent"
^oddCOM("User.Human","t","LogEvent",2)="User.Human"
^oddCOM("User.Human","t","LogEvent","m","Execute",2)="%Library.CacheTrigger"
^oddCOM("User.Human","t","LogEvent","m","Execute",44)=1
^oddCOM("User.Human","t","LogEvent","m","Execute",69)="????"_$c(16)_">"_$c(128)_"??0R"

表结构

字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Code%CacheString触发触发器时执行的代码。21 s {Code}=$s($d(^oddCOM({L1},"t",{L3},21))#2:^(21),$d(^oddCOM($g(^(2),{L1}),"t",{L3},21))#2:^(21),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},21))#2:^(21),1:""))
CodeMode%CacheString指定如何实现给定方法:要编译的代码行,或将生成结果方法或对象的方法。31 s {CodeMode}=$s($d(^oddCOM({L1},"t",{L3},31))#2:^(31),$d(^oddCOM($g(^(2),{L1}),"t",{L3},31))#2:^(31),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},31))#2:^(31),1:"code"))
CompilerGenerated%Boolean编译器生成10 s {CompilerGenerated}=$s($d(^oddCOM({L1},"t",{L3},10))#2:^(10),$d(^oddCOM($g(^(2),{L1}),"t",{L3},10))#2:^(10),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},10))#2:^(10),1:0))
Deprecated%Boolean如果此触发器已弃用,则为 True17 s {Deprecated}=$s($d(^oddCOM({L1},"t",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"t",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},17))#2:^(17),1:0))
Description%CacheString指定 SQL 触发器的描述。4 s {Description}=$s($d(^oddCOM({L1},"t",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"t",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},4))#2:^(4),1:""))
Event%CacheString指定将触发触发器的 SQL 事件。22 s {Event}=$s($d(^oddCOM({L1},"t",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"t",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},22))#2:^(22),1:""))
Final%Boolean指定子类不能覆盖 SQL 触发器的定义。7 s {Final}=$s($d(^oddCOM({L1},"t",{L3},7))#2:^(7),$d(^oddCOM($g(^(2),{L1}),"t",{L3},7))#2:^(7),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},7))#2:^(7),1:0))
Foreach%CacheString指示是否将为每行、行和对象或每个语句调用触发器26 s {Foreach}=$s($d(^oddCOM({L1},"t",{L3},26))#2:^(26),$d(^oddCOM($g(^(2),{L1}),"t",{L3},26))#2:^(26),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},26))#2:^(26),1:""))
Id%IntegerId6 s {Id}=$s($d(^oddCOM({L1},"t",{L3},6))#2:^(6),$d(^oddCOM($g(^(2),{L1}),"t",{L3},6))#2:^(6),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},6))#2:^(6),1:0))
InheritedId%BooleanInheritedId8 s {InheritedId}=$s($d(^oddCOM({L1},"t",{L3},8))#2:^(8),$d(^oddCOM($g(^(2),{L1}),"t",{L3},8))#2:^(8),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},8))#2:^(8),1:0))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"t",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"t",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"t",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"t",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"t",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"t",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},13))#2:^(13),1:0))
NewTable%CacheString保存触发器旧值的 SQL 表的名称。29 s {NewTable}=$s($d(^oddCOM({L1},"t",{L3},29))#2:^(29),$d(^oddCOM($g(^(2),{L1}),"t",{L3},29))#2:^(29),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},29))#2:^(29),1:""))
NotInheritable%BooleanNotInheritable9 s {NotInheritable}=$s($d(^oddCOM({L1},"t",{L3},9))#2:^(9),$d(^oddCOM($g(^(2),{L1}),"t",{L3},9))#2:^(9),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},9))#2:^(9),1:0))
OldTable%CacheString保存触发器旧值的 SQL 表的名称。30 s {OldTable}=$s($d(^oddCOM({L1},"t",{L3},30))#2:^(30),$d(^oddCOM($g(^(2),{L1}),"t",{L3},30))#2:^(30),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},30))#2:^(30),1:""))
Order%Integer如果同一事件和时间有多个触发器,请指定触发器的触发顺序。23 s {Order}=$s($d(^oddCOM({L1},"t",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"t",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},23))#2:^(23),1:0))
Origin%CacheStringOrigin2 s {Origin}=$s($d(^oddCOM({L1},"t",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"t",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},2))#2:^(2),1:""))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"t",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"t",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},11))#2:^(11),1:0))
SqlName%CacheString指定 SQL 使用此触发器时的备用名称。24 s {SqlName}=$s($d(^oddCOM({L1},"t",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"t",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},24))#2:^(24),1:""))
TagGenerator%CacheString标签生成器32 s {TagGenerator}=$s($d(^oddCOM({L1},"t",{L3},32))#2:^(32),$d(^oddCOM($g(^(2),{L1}),"t",{L3},32))#2:^(32),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},32))#2:^(32),1:""))
UpdateColumnList%CacheString指定一列或多列,其修改会导致 SQL 拉动触发器。28 s {UpdateColumnList}=$s($d(^oddCOM({L1},"t",{L3},28))#2:^(28),$d(^oddCOM($g(^(2),{L1}),"t",{L3},28))#2:^(28),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},28))#2:^(28),1:""))
_Language 27 s {_Language}=$s($d(^oddCOM({L1},"t",{L3},27))#2:^(27),$d(^oddCOM($g(^(2),{L1}),"t",{L3},27))#2:^(27),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},27))#2:^(27),1:""))
_Time 25 s {_Time}=$s($d(^oddCOM({L1},"t",{L3},25))#2:^(25),$d(^oddCOM($g(^(2),{L1}),"t",{L3},25))#2:^(25),1:$s($d(^oddDEF($g(^oddCOM({L1},"t",{L3},2),{L1}),"t",{L3},25))#2:^(25),1:"BEFORE"))

%Dictionary.CompiledUDLText - 编译UDLText

简介

新建或修改UDLText编译时会修改此表字段。

该注释只在类中生效,在方法中不会添加到此表中。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"u",{%Dictionary.CompiledUDLText.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledUDLText.Name - UDLText
示例

查询SQL表:

select * from %Dictionary.CompiledUDLText where parent = 'User.Human'

Global示例:

USER>zw ^oddCOM("User.Human","u")                         
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Category%CacheStringCategory23 s {Category}=$s($d(^oddCOM({L1},"u",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"u",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"u",{L3},2),{L1}),"u",{L3},23))#2:^(23),1:"comment"))
Content%Stream.TmpCharacter保存 UDL 文本的内容。0 s {Content}=""
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"u",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"u",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"u",{L3},2),{L1}),"u",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"u",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"u",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"u",{L3},2),{L1}),"u",{L3},13))#2:^(13),1:0))
Position%CacheString位置24 s {Position}=$s($d(^oddCOM({L1},"u",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"u",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"u",{L3},2),{L1}),"u",{L3},24))#2:^(24),1:"body"))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"u",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"u",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"u",{L3},2),{L1}),"u",{L3},11))#2:^(11),1:0))
TextType%Integer文本类型22 s {TextType}=$s($d(^oddCOM({L1},"u",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"u",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"u",{L3},2),{L1}),"u",{L3},22))#2:^(22),1:0))

%Dictionary.CompiledXData - 编译XData

简介

新建或修改XData时会修改此表字段。

该表为%Dictionary.CompiledClass子表。

索引

取值索引 - ^oddCOM({%Dictionary.CompiledClass.Name},"x",{%Dictionary.CompiledXData.Name})

  • %Dictionary.CompiledClass.Name - 类名
  • %Dictionary.CompiledXData.Name - XData
示例

查询SQL表:

在这里插入图片描述

Global示例:

USER>zw ^oddCOM("User.Human","x")
^oddCOM("User.Human","x","XmlData",2)="User.Human"
表结构
字检类型描述位置检索码
ID1
parent%Dictionary.CompiledClass指向包含父对象的指针
Name%Dictionary.CacheIdentifier
Data%Stream.TmpCharacter数据流。0 s {Data}=""
Deprecated%Boolean如果此 XDATA 已弃用,则为 True。17 s {Deprecated}=$s($d(^oddCOM({L1},"x",{L3},17))#2:^(17),$d(^oddCOM($g(^(2),{L1}),"x",{L3},17))#2:^(17),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},17))#2:^(17),1:0))
Description%CacheString指定 XData 的描述。4 s {Description}=$s($d(^oddCOM({L1},"x",{L3},4))#2:^(4),$d(^oddCOM($g(^(2),{L1}),"x",{L3},4))#2:^(4),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},4))#2:^(4),1:""))
Internal%Boolean如果为 true,则不在自动文档中显示此项。14 s {Internal}=$s($d(^oddCOM({L1},"x",{L3},14))#2:^(14),$d(^oddCOM($g(^(2),{L1}),"x",{L3},14))#2:^(14),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},14))#2:^(14),1:0))
KeywordError%Boolean关键字错误12 s {KeywordError}=$s($d(^oddCOM({L1},"x",{L3},12))#2:^(12),$d(^oddCOM($g(^(2),{L1}),"x",{L3},12))#2:^(12),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},12))#2:^(12),1:0))
KeywordModified%Boolean关键字修改13 s {KeywordModified}=$s($d(^oddCOM({L1},"x",{L3},13))#2:^(13),$d(^oddCOM($g(^(2),{L1}),"x",{L3},13))#2:^(13),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},13))#2:^(13),1:0))
MimeType%CacheStringXData 块的 Mime 类型。24 s {MimeType}=$s($d(^oddCOM({L1},"x",{L3},24))#2:^(24),$d(^oddCOM($g(^(2),{L1}),"x",{L3},24))#2:^(24),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},24))#2:^(24),1:"text/xml"))
Origin%CacheStringOrigin2 s {Origin}=$s($d(^oddCOM({L1},"x",{L3},2))#2:^(2),$d(^oddCOM($g(^(2),{L1}),"x",{L3},2))#2:^(2),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},2))#2:^(2),1:""))
SchemaSpec%CacheString数据的模式定义。22 s {SchemaSpec}=$s($d(^oddCOM({L1},"x",{L3},22))#2:^(22),$d(^oddCOM($g(^(2),{L1}),"x",{L3},22))#2:^(22),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},22))#2:^(22),1:""))
SequenceNumber%Integer序列号11 s {SequenceNumber}=$s($d(^oddCOM({L1},"x",{L3},11))#2:^(11),$d(^oddCOM($g(^(2),{L1}),"x",{L3},11))#2:^(11),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},11))#2:^(11),1:0))
XMLNamespace%CacheStringXDATA 的默认 XML 命名空间。23 s {XMLNamespace}=$s($d(^oddCOM({L1},"x",{L3},23))#2:^(23),$d(^oddCOM($g(^(2),{L1}),"x",{L3},23))#2:^(23),1:$s($d(^oddDEF($g(^oddCOM({L1},"x",{L3},2),{L1}),"x",{L3},23))#2:^(23),1:""))

^oddCOM一览

表名索引关键字索引
%Dictionary.CompiledClass^oddCOM({%Dictionary.CompiledClass.Name})
%Dictionary.CompiledConstraintn^oddCOM({%Dictionary.CompiledClass.Name},"n",{%Dictionary.CompiledConstraint.Name})
%Dictionary.CompiledConstraintMethodn,m^oddCOM({%Dictionary.CompiledClass.Name},"n",{%Dictionary.CompiledConstraint.Name},"m",{%Dictionary.CompiledConstraintMethod.Name})
%Dictionary.CompiledForeignKeyf^oddCOM({%Dictionary.CompiledClass.Name},"f",{%Dictionary.CompiledForeignKey.Name}
%Dictionary.CompiledIndexi^oddCOM({%Dictionary.CompiledClass.Name},"i",{%Dictionary.CompiledIndex.Name})
%Dictionary.CompiledIndexMethodi,m^oddCOM({%Dictionary.CompiledClass.Name},"i",{%Dictionary.CompiledIndex.Name},"m",{%Dictionary.CompiledIndexMethod.Name})
%Dictionary.CompiledIndexPropertyi,I^oddCOM({%Dictionary.CompiledClass.Name},"i",{%Dictionary.CompiledIndex.Name},"I",{%Dictionary.CompiledIndexProperty.Name})
%Dictionary.CompiledInstanceVarv^oddCOM({%Dictionary.CompiledClass.Name},"v",{%Dictionary.CompiledInstanceVar.Name})
%Dictionary.CompiledMethodm^oddCOM({%Dictionary.CompiledClass.Name},"m",{%Dictionary.CompiledMethod.Name}
%Dictionary.CompiledParameterp^oddCOM({%Dictionary.CompiledClass.Name},"p",{%Dictionary.CompiledParameter.Name})
%Dictionary.CompiledProjectionj^oddCOM({%Dictionary.CompiledClass.Name},"j",{%Dictionary.CompiledProjection.Name})
%Dictionary.CompiledPropertya^oddCOM({%Dictionary.CompiledClass.Name},"a",{%Dictionary.CompiledProperty.Name})
%Dictionary.CompiledPropertyMethoda,m^oddCOM({%Dictionary.CompiledClass.Name},"a",{%Dictionary.CompiledProperty.Name},"m",{%Dictionary.CompiledPropertyMethod.Name})
%Dictionary.CompiledPropertyUDLTexta,u^oddCOM({%Dictionary.CompiledClass.Name},"a",{%Dictionary.CompiledProperty.Name},"u",{%Dictionary.CompiledPropertyUDLText.Name})
%Dictionary.CompiledQueryq^oddCOM({%Dictionary.CompiledClass.Name},"q",{%Dictionary.CompiledQuery.Name})
%Dictionary.CompiledQueryMethodq,m^oddCOM({%Dictionary.CompiledClass.Name},"q",{%Dictionary.CompiledQuery.Name},"m",{%Dictionary.CompiledQueryMethod.Name})
%Dictionary.CompiledStorages^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name})
%Dictionary.CompiledStorageDatas,D^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"D",{%Dictionary.CompiledStorageData.Name})
%Dictionary.CompiledStorageDataValues,D,V^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"D",{%Dictionary.CompiledStorageData.Name},"V",{%Dictionary.CompiledStorageDataValue.Name})
%Dictionary.CompiledStorageIndexs,X^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"X",{%Dictionary.CompiledStorageIndex.Name})
%Dictionary.CompiledStoragePropertys,M^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"M",{%Dictionary.CompiledStorageProperty.Name})
%Dictionary.CompiledStorageSQLMaps,S^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name})
%Dictionary.CompiledStorageSQLMapDatas,S,T^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"T",{%Dictionary.CompiledStorageSQLMapData.Name})
%Dictionary.CompiledStorageSQLMapRowIdSpecs,S,R^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"R",{%Dictionary.CompiledStorageSQLMapRowIdSpec.Name})
%Dictionary.CompiledStorageSQLMapSubs,S,B^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"B",{%Dictionary.CompiledStorageSQLMapSub.Name})
%Dictionary.CompiledStorageSQLMapSubAccessvars,S,B,A^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"B",{%Dictionary.CompiledStorageSQLMapSub.Name},"A",{%Dictionary.CompiledStorageSQLMapSubAccessvar.Name})
%Dictionary.CompiledStorageSQLMapSubInvalidconditions,S,B,N^oddCOM({%Dictionary.CompiledClass.Name},"s",{%Dictionary.CompiledStorage.Name},"S",{%Dictionary.CompiledStorageSQLMap.Name},"B",{%Dictionary.CompiledStorageSQLMapSub.Name},"N",{%Dictionary.CompiledStorageSQLMapSubInvalidcondition.Name})
%Dictionary.CompiledTriggert^oddCOM({%Dictionary.CompiledClass.Name},"t",{%Dictionary.CompiledTrigger.Name})
%Dictionary.CompiledUDLTextu^oddCOM({%Dictionary.CompiledClass.Name},"u",{%Dictionary.CompiledUDLText.Name})
%Dictionary.CompiledXDatax^oddCOM({%Dictionary.CompiledClass.Name},"x",{%Dictionary.CompiledXData.Name})
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

yaoxin521123

谢谢您的支持!

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值