home *** CD-ROM | disk | FTP | other *** search
/ DOS/V Power Report 1997 August / VPR9708A.ISO / D3TRIAL / INSTALL / DATA.Z / DbX.DbI < prev    next >
Windows Setup INFormation  |  1997-05-09  |  36KB  |  774 lines
  1.  
  2.  
  3. [Version]
  4. DbXName="ﾃﾞｰﾀﾍﾞｰｽ ｴｸｽﾌﾟﾛｰﾗ"
  5. DbXVersion=3.00
  6.  
  7. [Properties]
  8. DEFAULT DRIVER:Values=Closed,PARADOX,DBASE,ASCIIDRV
  9. NET PROTOCOL:Values1=Closed,TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  10. NET PROTOCOL:Values2=APPC,ASYNC
  11. OPEN MODE:Values=Closed,READ/WRITE,READ ONLY
  12. SHARE MODE:Values=Closed,EXCLUSIVE,SHARED
  13. STRICTINTEGRTY:Values=Closed,FALSE,TRUE
  14. SQLPASSTHRU MODE:Values=Closed,NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  15. LIST SYNONYMS:Values=Closed,NONE,ALL,PRIVATE
  16. BLOB EDIT LOGGING:Values=Closed,FALSE,TRUE
  17. ENABLE SCHEMA CACHE:Values=Closed,FALSE,TRUE
  18. ENABLE BCD:Values=Closed,FALSE,TRUE
  19. ENABLE INTEGERS:Values=Closed,FALSE,TRUE
  20. LOCAL SHARE:Values=Closed,FALSE,TRUE
  21. AUTO ODBC:Values=Closed,FALSE,TRUE
  22. FOURDIGITYEAR:Values=Closed,FALSE,TRUE
  23. YEARBIASED:Values=Closed,FALSE,TRUE
  24. LEADINGZEROM:Values=Closed,FALSE,TRUE
  25. LEADINGZEROD:Values=Closed,FALSE,TRUE
  26. TWELVEHOUR:Values=Closed,FALSE,TRUE
  27. SECONDS:Values=Closed,FALSE,TRUE
  28. MILSECONDS:Values=Closed,FALSE,TRUE
  29. LEADINGZERON:Values=Closed,FALSE,TRUE
  30. COLLCHAR:Values=Closed,0,1,2
  31. DBNLS:Values=Closed,0,1,2
  32. SQLQRYMODE:Values=Closed,LOCAL,SERVER
  33.  
  34. :HelpContext=4039
  35. DB2:HelpContext=4038
  36. INFORMIX:HelpContext=4035
  37. INTRBASE:HelpContext=4037
  38. MSACCESS:HelpContext=4042
  39. MSSQL:HelpContext=4036
  40. ORACLE:HelpContext=4034
  41. STANDARD:HelpContext=4045
  42. SYBASE:HelpContext=4033
  43.  
  44.  
  45.  
  46. [STANDARD Properties]
  47. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  48. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  49. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  50. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  51. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  52. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  53. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  54. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  55. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  56. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  57. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  58. FamilyMemberType:Values1=Closed,0="Unknown",1="Table",2="Index",3="Form",4="Report"
  59. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  60. FamilyMemberType:Values3=8="Blob File"
  61.  
  62. STANDARD:Objects=O:C:0M::"Tables":Table
  63.  
  64. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  65. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  66. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  67. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  68. Table:Dataset5=PROTECTED=Word,VALID=Word
  69.  
  70. Table:Category=Dataset
  71. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  72. Table:Attrs2=DATE="Date"
  73. Table:Attrs3=TIME="Time"
  74. Table:Attrs4=VERSION="Version":2
  75. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  76. Table:Attrs6=STRUCTURE="Structure":2
  77. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  78. Table:Name=FILENAME,EXTENSION
  79. Table:Objects1=O:P:1M::"Fields":Column
  80. Table:Objects2=O:O:0M::"Indices":Index
  81. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  82. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  83. Table:Objects5=O:O:0M::"Security Specs":Security
  84. Table:Objects6=O:C:1M::"Family Members":Family
  85.  
  86. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  87. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  88. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  89.  
  90. Column:Category=Column
  91. Column:Order=FIELDNUM
  92. Column:Attrs1=FIELDNUM="Order":2:NR
  93. Column:Attrs2=TYPE="Type":1:NR
  94. Column:Attrs3=UNITS1="Size":1:N
  95. Column:Attrs4=UNITS2="Scale":1:N
  96. Column:Attrs5=LENGTH="Physical Length"
  97. Column:Name=NAME
  98.  
  99. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  100. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  101. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  102. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  103. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  104. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  105.  
  106. Index:Category=Index
  107. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  108. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  109. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  110. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  111. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  112. Index:Attrs6=FORMAT="Format":2
  113. Index:Attrs7=BLOCKSIZE="Block Size":2
  114. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  115. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  116. Index:Attrs10=EXPRESSION="Expression":2:N
  117. Index:Attrs11=CONDITION="Subset Condition":2:N
  118. Index:Name=NAME
  119. Index:OnAfterLoad=GetIndexInfo
  120.  
  121. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  122. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  123. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  124. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  125.  
  126. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  127. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  128. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  129. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  130. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  131. ValCheck:Attrs6=PICTURE="Picture":2:N
  132. ValCheck:Name=FIELDNUM
  133.  
  134. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  135.  
  136. Family:Attrs1=TYPE="Type":1::::VM=FamilyMemberType
  137. Family:Attrs2=NAME="Object Name":1
  138. Family:Name=FILENAME
  139.  
  140. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  141. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  142. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  143.  
  144. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  145. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  146. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  147. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  148. Reference:Name=NAME
  149. Reference:OnAfterLoad=GetReferenceInfo
  150.  
  151. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  152. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  153.  
  154. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  155. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  156. Security:Name=PASSWORD
  157.  
  158. [MSACCESS Properties]
  159. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  160. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  161. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  162. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  163. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  164. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  165. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  166. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  167. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  168. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  169. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  170.  
  171. MSACCESS:Objects=O:C:0M::"Tables":Table
  172.  
  173. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  174. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  175. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  176. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  177. Table:Dataset5=PROTECTED=Word,VALID=Word
  178.  
  179. Table:Category=Dataset
  180. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  181. Table:Attrs2=DATE="Date"
  182. Table:Attrs3=TIME="Time"
  183. Table:Attrs4=VERSION="Version":2
  184. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  185. Table:Attrs6=STRUCTURE="Structure":2
  186. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  187. Table:Name=FILENAME,EXTENSION
  188. Table:Objects1=O:P:1M::"Fields":Column
  189. Table:Objects2=O:O:0M::"Indices":Index
  190. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  191. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  192. Table:Objects5=O:O:0M::"Security Specs":Security
  193.  
  194. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  195. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  196. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  197.  
  198. Column:Category=Column
  199. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  200. Column:Attrs2=LENGTH="Physical Length"
  201. Column:Name=NAME
  202.  
  203. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  204. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  205. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  206. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  207. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  208. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  209.  
  210. Index:Category=Index
  211. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  212. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  213. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  214. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  215. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  216. Index:Attrs6=FORMAT="Format":2
  217. Index:Attrs7=BLOCKSIZE="Block Size":2
  218. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  219. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  220. Index:Attrs10=EXPRESSION="Expression":2:N
  221. Index:Attrs11=CONDITION="Subset Condition":2:N
  222. Index:Name=NAME
  223. Index:OnAfterLoad=GetIndexInfo
  224.  
  225. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  226. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  227. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  228. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  229.  
  230. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  231. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  232. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  233. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  234. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  235. ValCheck:Attrs6=PICTURE="Picture":2:N
  236. ValCheck:Name=FIELDNUM
  237.  
  238. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  239. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  240. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  241.  
  242. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  243. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  244. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  245. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  246. Reference:Name=NAME
  247. Reference:OnAfterLoad=GetReferenceInfo
  248.  
  249. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  250. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  251.  
  252. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  253. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  254. Security:Name=PASSWORD
  255.  
  256. [ODBC Properties]
  257. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  258. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  259. FieldVChecks:Values=Closed,0=,1="Has Validity Checks",2=
  260. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=
  261. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  262. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  263. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  264. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  265. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  266. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  267. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  268.  
  269. ODBC:Objects1=O:C:0M::"Tables":Table
  270. ODBC:Objects2=O:C:0M::"Procedures":Procedure
  271.  
  272. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  273. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  274. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  275. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  276. Table:Dataset5=PROTECTED=Word,VALID=Word
  277.  
  278. Table:Category=Dataset
  279. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  280. Table:Attrs2=DATE="Date"
  281. Table:Attrs3=TIME="Time"
  282. Table:Attrs4=VERSION="Version":2
  283. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  284. Table:Attrs6=STRUCTURE="Structure":2
  285. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  286. Table:Name=FILENAME,EXTENSION
  287. Table:Objects1=O:P:1M::"Fields":Column
  288. Table:Objects2=O:O:0M::"Indices":Index
  289. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  290. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  291. Table:Objects5=O:O:0M::"Security Specs":Security
  292.  
  293. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  294. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  295. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  296.  
  297. Column:Category=Column
  298. Column:Order=FIELDNUM
  299. Column:Attrs1=FIELDNUM="Order":2:NR
  300. Column:Attrs2=TYPE="Type":1:NR
  301. Column:Attrs3=UNITS1="Size":1:N
  302. Column:Attrs4=UNITS2="Scale":1:N
  303. Column:Attrs5=LENGTH="Physical Length"
  304. Column:Name=NAME
  305.  
  306. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  307. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  308. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  309. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  310. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  311. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  312.  
  313. Index:Category=Index
  314. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  315. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  316. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  317. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  318. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  319. Index:Attrs6=FORMAT="Format":2
  320. Index:Attrs7=BLOCKSIZE="Block Size":2
  321. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  322. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  323. Index:Attrs10=EXPRESSION="Expression":2:N
  324. Index:Attrs11=CONDITION="Subset Condition":2:N
  325. Index:Name=NAME
  326. Index:OnAfterLoad=GetIndexInfo
  327.  
  328. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  329. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  330. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  331. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  332.  
  333. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  334. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  335. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  336. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  337. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  338. ValCheck:Attrs6=PICTURE="Picture":2:N
  339. ValCheck:Name=FIELDNUM
  340.  
  341. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  342. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  343. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  344.  
  345. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  346. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  347. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  348. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  349. Reference:Name=NAME
  350. Reference:OnAfterLoad=GetReferenceInfo
  351.  
  352. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  353. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  354.  
  355. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  356. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  357. Security:Name=PASSWORD
  358.  
  359. Procedure:Dataset=NAME=String,DATE=Date,TIME=Time
  360.  
  361. Procedure:Category=Executable
  362. Procedure:Attrs=DATE="Date":1,TIME="Time":1
  363. Procedure:EAttrs=Data
  364. Procedure:Name=NAME
  365.  
  366. [MISC]
  367.  
  368. [INTRBASE Properties]
  369. TFieldType:Values1=Closed,7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  370. TFieldType:Values2=11=DOUBLE PRECISION,14=`'CHAR('=Length')'`:CHAR,27=NUMERIC
  371. TFieldType:Values3=35=DATE,37=`'VARCHAR('=Length')'`:VARCHAR
  372. TFieldType:Values4=40=`'CSTRING('=Length')'`:CSTRING
  373. TFieldType:Values5=261=`'BLOB'``!' SUB_TYPE ' =SubType`:BLOB
  374. TFieldSubType:Values1=Closed,0=0:,1=1:"Text",2=2:"BLR",3=3:"ACL",4=4:"Ranges",5=5:"Summary"
  375. TFieldSubType:Values2=6=6:"Format",7=7:"Transaction Desc",8=8:"Ext File Desc"
  376. TNulls:Values=Closed,=:"Yes",1=NOT NULL:"No"
  377. TUniqueIndex:Values=Closed,=:"No",0=:"No",1=UNIQUE:"Yes"
  378. TDescendingIndex:Values=Closed,=ASCENDING:"No",1=DESCENDING:"Yes"
  379. TTriggerType:Values1=Closed,1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  380. TTriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  381. TParamKind:Values=Closed,0=:"Input",1=:"Output"
  382. TFnParamKind:Values=Closed,0=BY VALUE:"Value",1=:"Reference",3=:"Handle"
  383.  
  384. INTRBASE:Comments=/*,*/
  385.  
  386. INTRBASE:Objects1=O:C:0M::"Domains":Type
  387. INTRBASE:Objects2=O:C:0M::"Tables":Table
  388. INTRBASE:Objects3=O:C:0M::"Views":View
  389. INTRBASE:Objects4=O:C:0M::"Procedures":Procedure
  390. INTRBASE:Objects5=O:C:0M::"Functions":Function
  391. INTRBASE:Objects6=O:C:0M::"Generators":Generator
  392. INTRBASE:Objects7=O:C:0M::"Exceptions":Exception
  393. INTRBASE:Objects8=O:C:0M::"Blob Filters":BlobFilter
  394.  
  395. RDB$RELATIONS:Name=RDB$RELATION_NAME
  396. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner"
  397. RDB$RELATIONS:Attrs2=RDB$DESCRIPTION="Description"
  398. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  399.  
  400. RDB$RELATION_FIELDS:Key=RDB$RELATION_NAME,RDB$FIELD_NAME
  401. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  402. RDB$RELATION_FIELDS:Order=RDB$FIELD_POSITION
  403. RDB$RELATION_FIELDS:Objects=P:R:M1::"Domain":Type
  404. RDB$RELATION_FIELDS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  405. RDB$RELATION_FIELDS:Attrs2=RDB$DEFAULT_SOURCE=Default="Default"::E
  406. RDB$RELATION_FIELDS:Attrs3=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  407. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE
  408.  
  409. RDB$FIELDS:Name=RDB$FIELD_NAME
  410. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  411. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  412. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH=Length="Length"::E
  413. RDB$FIELDS:Attrs4=RDB$FIELD_SCALE=Scale="Scale"::E
  414. RDB$FIELDS:Attrs5=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  415. RDB$FIELDS:Attrs6=RDB$SEGMENT_LENGTH=SegmentSize="Segment Size":2:E
  416. RDB$FIELDS:Attrs7=RDB$DEFAULT_SOURCE=Default="Default":2:E
  417. RDB$FIELDS:Attrs8=RDB$VALIDATION_SOURCE=Rule="Constraint":2:E
  418. RDB$FIELDS:Attrs9=RDB$DESCRIPTION=Description="Description"
  419.  
  420. RDB$FIELD_DIMENSIONS:Key=RDB$FIELD_NAME,RDB$DIMENSION
  421. RDB$FIELD_DIMENSIONS:Name=RDB$DIMENSION
  422. RDB$FIELD_DIMENSIONS:Order=RDB$DIMENSION
  423. RDB$FIELD_DIMENSIONS:Attrs1=RDB$DIMENSION="Order":2:ER
  424. RDB$FIELD_DIMENSIONS:Attrs2=RDB$LOWER_BOUND=LowerBound="Lower Bound"::ER
  425. RDB$FIELD_DIMENSIONS:Attrs3=RDB$UPPER_BOUND=UpperBound="Upper Bound"::ER
  426.  
  427. RDB$FUNCTIONS:Name=RDB$FUNCTION_NAME
  428. RDB$FUNCTIONS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  429. RDB$FUNCTIONS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  430. RDB$FUNCTIONS:Attrs3=RDB$QUERY_NAME=AlternateName="Alternate Name"
  431. RDB$FUNCTIONS:Attrs4=RDB$DESCRIPTION=Description="Description":2
  432. RDB$FUNCTIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  433.  
  434. RDB$FUNCTION_ARGUMENTS:Key=RDB$FUNCTION_NAME,RDB$ARGUMENT_POSITION
  435. RDB$FUNCTION_ARGUMENTS:Name=RDB$ARGUMENT_POSITION
  436. RDB$FUNCTION_ARGUMENTS:Order=RDB$ARGUMENT_POSITION
  437. RDB$FUNCTION_ARGUMENTS:Attrs1=RDB$ARGUMENT_POSITION="Order":2:ER
  438. RDB$FUNCTION_ARGUMENTS:Attrs2=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  439. RDB$FUNCTION_ARGUMENTS:Attrs3=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  440. RDB$FUNCTION_ARGUMENTS:Attrs4=RDB$FIELD_LENGTH=Length="Length"::E
  441. RDB$FUNCTION_ARGUMENTS:Attrs5=RDB$FIELD_SCALE=Scale="Scale"::E
  442.  
  443. RDB$FILTERS:Name=RDB$FUNCTION_NAME
  444. RDB$FILTERS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  445. RDB$FILTERS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  446. RDB$FILTERS:Attrs3=RDB$INPUT_SUB_TYPE=InputType="Input"::ER:::VM=TFieldSubType
  447. RDB$FILTERS:Attrs4=RDB$OUTPUT_SUB_TYPE=OutputType="Output"::ER:::VM=TFieldSubType
  448. RDB$FILTERS:Attrs5=RDB$DESCRIPTION=Description="Description":2
  449. RDB$FILTERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  450.  
  451. RDB$INDICES:Name=RDB$INDEX_NAME
  452. RDB$INDICES:Objects=T:P:1M::"Columns":IndexColumn
  453. RDB$INDICES:Attrs1=RDB$UNIQUE_FLAG=Unique="Unique"::E:::VM=TUniqueIndex
  454. RDB$INDICES:Attrs2=RDB$INDEX_TYPE=Descending="Descending"::E:::VM=TDescendingIndex
  455. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  456.  
  457. RDB$INDEX_SEGMENTS:Key=RDB$INDEX_NAME,RDB$FIELD_NAME
  458. RDB$INDEX_SEGMENTS:Name=Column
  459. RDB$INDEX_SEGMENTS:Order=RDB$FIELD_POSITION
  460. RDB$INDEX_SEGMENTS:Objects1=P:R:M1::"Column":Column:<<>Column
  461. RDB$INDEX_SEGMENTS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  462. RDB$INDEX_SEGMENTS:Reference:"Column"=,RDB$FIELD_NAME
  463.  
  464. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  465. RDB$PROCEDURES:Attrs1=RDB$OWNER_NAME="Owner"
  466. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  467.  
  468. RDB$PROCEDURE_PARAMETERS:Key=RDB$PROCEDURE_NAME,RDB$PARAMETER_NAME
  469. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  470. RDB$PROCEDURE_PARAMETERS:Order=RDB$PARAMETER_NUMBER
  471. RDB$PROCEDURE_PARAMETERS:Objects=P:R:M1::"Domain":Type
  472. RDB$PROCEDURE_PARAMETERS:Attrs1=RDB$PARAMETER_NUMBER="Order":2
  473. RDB$PROCEDURE_PARAMETERS:Attrs2=RDB$PARAMETER_TYPE=Kind="Kind":1:ER:::VM=TParamKind
  474. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE
  475.  
  476. RDB$TYPES:Key=RDB$FIELD_NAME,RDB$TYPE
  477. RDB$TYPES:Name=RDB$TYPE_NAME
  478. RDB$TYPES:Order=RDB$TYPE
  479. RDB$TYPES:Attrs=RDB$TYPE="Value"
  480.  
  481. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  482. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  483.  
  484. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  485. RDB$EXCEPTIONS:Attrs1=RDB$MESSAGE=Message="Message"::E
  486.  
  487. RDB$TRIGGERS:Key=RDB$RELATION_NAME,RDB$TRIGGER_NAME
  488. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  489. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE=Type="Type"::ER:::VM=TTriggerType
  490. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE=Position="Position"::ER
  491. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  492.  
  493. RDB$RELATION_CONSTRAINTS:Key=RDB$RELATION_NAME,RDB$CONSTRAINT_NAME
  494. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  495. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  496. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  497. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME
  498.  
  499. RDB$REF_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  500. RDB$REF_CONSTRAINTS:Objects1=P:R:01::"Primary Key":PrimaryKey
  501. RDB$REF_CONSTRAINTS:Objects2=P:R:11::"Foreign Key":ForeignKey
  502. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  503. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  504. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  505. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  506. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  507. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  508. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  509.  
  510. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  511. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  512.  
  513. Table:Definition=Root=RDB$RELATIONS
  514. View:Definition=Root=RDB$RELATIONS
  515. Procedure:Definition=Root=RDB$PROCEDURES
  516. Function:Definition=Root=RDB$FUNCTIONS
  517. Trigger:Definition=Root=RDB$TRIGGERS
  518. PrimaryKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  519. ForeignKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  520. UniqueConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  521. CheckConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  522. Exception:Definition=Root=RDB$EXCEPTIONS
  523. Generator:Definition=Root=RDB$GENERATORS
  524. Index:Definition=Root=RDB$INDICES
  525. IndexColumn:Definition=Root=RDB$INDEX_SEGMENTS
  526. Column:Definition=Root=RDB$RELATION_FIELDS
  527. Type:Definition=Root=RDB$FIELDS
  528. Enumeration:Definition=Root=RDB$TYPES
  529. Parameter:Definition=Root=RDB$PROCEDURE_PARAMETERS
  530. FunctionParameter:Definition=Root=RDB$FUNCTION_ARGUMENTS
  531. FunctionResult:Definition=Root=RDB$FUNCTION_ARGUMENTS
  532. BlobFilter:Definition=Root=RDB$FILTERS
  533. Dimension:Definition=Root=RDB$FIELD_DIMENSIONS
  534.  
  535. Exception:Warning=Loss
  536. Exception:EAttrs=Text,New,Delete,Modify,Rename,Save
  537. Exception:Text:Get=CREATE EXCEPTION `\N '  ' N \N`  "`=Message`"
  538. Exception:Text:RE=CREATE EXCEPTION\_+(\w+)\_+"(.*)"
  539. Exception:Text:Set=*N=1,Message=2
  540. Exception:Delete:Text=DROP EXCEPTION `O`
  541.  
  542. Generator:Attrs:Q=gen_id=Integer::"Current Value":2:ER
  543. Generator:AttrReference:gen_id=select distinct gen_id(`O`, 0) from RDB$GENERATORS
  544. Generator:Warning=Loss
  545. Generator:EAttrs=Text,New:';',Delete,Modify,Rename,Save
  546. Generator:Text:Init1=CREATE GENERATOR `EDefaultName ';' \N`
  547. Generator:Text:Init2=SET GENERATOR `EDefaultName` TO 0
  548. Generator:Text:Get=CREATE GENERATOR `N`;`\N 'SET GENERATOR ' N ' TO ' =gen_id`
  549. Generator:Text:RE=CREATE GENERATOR\_+(\w+);(\_*SET GENERATOR \w+ TO (\w*))?\_*$
  550. Generator:Text:Set=*N=1,gen_id=3
  551. Generator:Delete:Text1=DELETE FROM RDB$GENERATORS
  552. Generator:Delete:Text2=WHERE RDB$GENERATOR_NAME=`OQ`
  553.  
  554. Table:Category=Dataset
  555. Table:Values=A.RDB$VIEW_SOURCE IS NULL
  556. Table:Objects1=T:P:1M::"Columns":Column
  557. Table:Objects2=T:O:0M::"Indices":Index
  558. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  559. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  560. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  561. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  562. Table:Objects7=T:O:0M::"Triggers":Trigger
  563. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  564. Table:Warning=DataLoss
  565. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  566. Table:Text:Get=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  567. Table:Text:RE=CREATE TABLE\_+(\w+)\_*(\(.*\))
  568. Table:Text:Set=*N=1
  569. Table:Delete:Text=DROP TABLE `O`
  570.  
  571. View:Category=Dataset
  572. View:Values=A.RDB$VIEW_SOURCE IS NOT NULL
  573. View:Objects=T:P:0M:NMDR:"Columns":Column
  574. View:Attrs:Q=Text=Memo::"Text"::ER
  575. View:AttrReference:Text1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  576. View:AttrReference:Text2=where RDB$RELATION_ID=`:RDB$RELATION_ID`
  577. View:Warning=Loss
  578. View:EAttrs=Data,Text,New,Modify,Rename,Delete,Save
  579. View:Text:Init=CREATE VIEW `EDefaultName` AS SELECT
  580. View:Text:Get=CREATE VIEW `N` `'('[Column:%s,%s:\N '  ' N] \N ') '`AS`=Text`
  581. View:Text:RE=CREATE VIEW\_+(\w+)\_*(\(.*\))?\_+AS(.*)
  582. View:Text:Set=Text=3,*N=1
  583. View:Delete:Text=DROP VIEW `O`
  584.  
  585. Index:Category=Index
  586. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  587. Index:Text:Get1=CREATE `!=Unique ' ' ``!=Descending ' ' `INDEX `N`
  588. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:*]`)
  589. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  590. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  591. Index:Delete:Text=DROP INDEX `O`
  592.  
  593. Column:Category=Column
  594. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:E::PResetType
  595. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:E::PResetType
  596. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:E::PResetType
  597. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:E::PResetType
  598. Column:Attrs:R=Type:"Domain":"Type":1:E::PSetType
  599. Column:OnAfterLoad=ColumnLoaded
  600. Column:OnCopyFrom=CopyWithDomain
  601. Column:AttrReference:FieldType=RDB$FIELD_SOURCE
  602. Column:AttrReference:SubType=RDB$FIELD_SOURCE
  603. Column:AttrReference:Length=RDB$FIELD_SOURCE
  604. Column:AttrReference:Scale=RDB$FIELD_SOURCE
  605. Column:EAttrs=Text,New,Delete,Modify,Rename
  606. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  607.  
  608. IndexColumn:Category=ColumnReference
  609. IndexColumn:Attrs:R=Column:::2:ER
  610. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  611. IndexColumn:Text:Get=`N`
  612.  
  613. Type:Category=Type
  614. Type:Objects1=T:P:0M::"Dimensions":Dimension
  615. Type:Objects2=T:C:0M::"Values":Enumeration
  616. ; Convert DEFAULT (.*) in Default and CHECK \((.*)\) in Rule
  617. Type:OnAfterLoad=TypeLoaded
  618. Type:Reference:"Dimensions":Text=`' [' [Dimension:%s, %s:*] ']'`
  619. Type:Warning=Loss
  620. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  621. Type:Text:Get1=CREATE DOMAIN `N` AS` \N '  ' EPhysicalType`
  622. Type:Text:Get2=`!\N '  DEFAULT '=Default`
  623. Type:Text:Get3=`!\N '  ' =Null`
  624. Type:Text:Get4=`!\N '  CHECK (' =Rule ')'`
  625. Type:Delete:Text=DROP DOMAIN `O`
  626.  
  627. Dimension:EAttrs=Text,New,Delete,Modify,Rename
  628. Dimension:Text:Get=`=LowerBound ':' =UpperBound`
  629.  
  630. Procedure:Category=Executable
  631. Procedure:Objects=T:P:0M::"Parameters":Parameter
  632. Procedure:Reference:"Parameters":Text1=`!'(' \N {>Parameter} EParametersIn \N')'`
  633. Procedure:Reference:"Parameters":Text2=`!'RETURNS (' \N {>Parameter} EParametersOut \N ')'`
  634. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  635. Procedure:AttrReference:Text1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  636. Procedure:AttrReference:Text2=where RDB$PROCEDURE_NAME=`OQ`
  637. Procedure:Warning=Loss
  638. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  639. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS`\N`BEGIN`\N`END
  640. Procedure:Text:Get1=CREATE PROCEDURE `N`
  641. Procedure:Text:Get2=`{>Parameter} *`
  642. Procedure:Text:Get3=AS `=Text`
  643. Procedure:Text:RE=CREATE PROCEDURE\_+(\w+)\_*(.*)\_AS\_(.*)
  644. Procedure:Text:Set=Text=3,*>Parameter=2,*N=1
  645. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  646. Procedure:Modify:Set=1=`'ALTER'`
  647. Procedure:Delete:Text=DROP PROCEDURE `O`
  648.  
  649. Parameter:Category=Column
  650. Parameter:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:-E::PResetType
  651. Parameter:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:-E::PResetType
  652. Parameter:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:-E::PResetType
  653. Parameter:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:-E::PResetType
  654. Parameter:Attrs:R=Type:"Domain":"Type":1:::PSetType
  655. Parameter:AttrReference:FieldType=RDB$FIELD_SOURCE
  656. Parameter:AttrReference:SubType=RDB$FIELD_SOURCE
  657. Parameter:AttrReference:Length=RDB$FIELD_SOURCE
  658. Parameter:AttrReference:Scale=RDB$FIELD_SOURCE
  659. Parameter:EAttrs=Text
  660. Parameter:Text:Get=`N ' ' EType`
  661. Parameter:OnAfterLoad=AdjustTypeInfo
  662. Parameter:OnCopyFrom=CopyWithDomain
  663.  
  664. Function:Category=Executable
  665. Function:Objects1=T:P:0M::"Parameters":FunctionParameter
  666. Function:Objects2=T:P:11::"Result":FunctionResult
  667. Function:Reference:"Parameters":Text=`[FunctionParameter:%s, %s:*]`
  668. Function:Reference:"Result":Text=`[FunctionResult::*]`
  669. Function:Warning=Loss
  670. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  671. Function:Text:Get1=DECLARE EXTERNAL FUNCTION `N \N`
  672. Function:Text:Get2=`!'  ' {>FunctionParameter} * \N`
  673. Function:Text:Get3=`'  RETURNS ' {>FunctionResult} * \N`
  674. Function:Text:Get4= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  675. Function:Delete:Text=DROP EXTERNAL FUNCTION `O`
  676.  
  677. FunctionParameter:Category=Column
  678. FunctionParameter:Values=A.RDB$ARGUMENT_POSITION <> `:RDB$RETURN_ARGUMENT`
  679. FunctionParameter:EAttrs=Text,New,Delete,Modify,Rename
  680. FunctionParameter:Text:Get=`EPhysicalType`
  681.  
  682. FunctionResult:Category=Column
  683. FunctionResult:Values=A.RDB$ARGUMENT_POSITION = `:RDB$RETURN_ARGUMENT`
  684. FunctionResult:Attrs=RDB$MECHANISM=Kind="Kind"::E:::VM=TFnParamKind
  685. FunctionResult:EAttrs=Text,New,Delete,Modify,Rename
  686. FunctionResult:Text:Get=`EPhysicalType``! ' ' =Kind`
  687.  
  688. BlobFilter:Category=Executable
  689. BlobFilter:Warning=Loss
  690. BlobFilter:EAttrs=Text,New,Delete,Modify,Rename,Save
  691. BlobFilter:Text:Get1=DECLARE FILTER `N \N`
  692. BlobFilter:Text:Get2= INPUT_TYPE `=InputType`  OUTPUT_TYPE `=OutputType``\N`
  693. BlobFilter:Text:Get3= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  694. BlobFilter:Delete:Text=DROP FILTER `O`
  695.  
  696. CheckConstraint:Category=Expression
  697. CheckConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'CHECK'
  698. CheckConstraint:Attrs:Q=Text=Memo::"Constraint Text":2:ER:PStripCheck
  699. CheckConstraint:AttrReference:Text1=select t.RDB$TRIGGER_SOURCE
  700. CheckConstraint:AttrReference:Text2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  701. CheckConstraint:AttrReference:Text3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  702. CheckConstraint:AttrReference:Text4=t.RDB$TRIGGER_TYPE=1 and
  703. CheckConstraint:AttrReference:Text5=c.RDB$CONSTRAINT_NAME=`OQ`
  704. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  705. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  706. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  707. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  708. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  709. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  710.  
  711. UniqueConstraint:Category=UniqueConstraint
  712. UniqueConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'UNIQUE'
  713. UniqueConstraint:Objects1=T:P:1M::"Columns":IndexColumn
  714. UniqueConstraint:Objects2=P:R:M1::"Index":Index:<>Index
  715. UniqueConstraint:Reference:"Columns"=RDB$INDEX_NAME
  716. UniqueConstraint:Reference:"Index"=RDB$INDEX_NAME
  717. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  718. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  719. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [IndexColumn:%s, %s:N] ')'`
  720. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  721.  
  722. PrimaryKey:Category=PrimaryKey
  723. PrimaryKey:Values=A.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  724. PrimaryKey:Objects1=T:P:1M::"Columns":IndexColumn
  725. PrimaryKey:Objects2=P:R:M1::"Index":Index:<>Index
  726. PrimaryKey:Reference:"Columns"=RDB$INDEX_NAME
  727. PrimaryKey:Reference:"Index"=RDB$INDEX_NAME
  728. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  729. PrimaryKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  730. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [IndexColumn:%s, %s:N] ')'`
  731. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  732.  
  733. ForeignKey:Category=ForeignKey
  734. ForeignKey:Values=A.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
  735. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  736. ForeignKey:Objects2=T:P:1M::"Columns":IndexColumn
  737. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  738. ForeignKey:Reference:"Index"=RDB$INDEX_NAME
  739. ForeignKey:Reference:"Columns"=RDB$INDEX_NAME
  740. ForeignKey:Reference:"Reference Table"=ReferenceTable
  741. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION=MatchOption
  742. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE=UpdateRule
  743. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE=DeleteRule
  744. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  745. ForeignKey:Attrs:R=Table::::ER
  746. ForeignKey:AttrReference:ReferenceTable1=select RDB$RELATION_NAME
  747. ForeignKey:AttrReference:ReferenceTable2=from RDB$REF_CONSTRAINTS A, RDB$RELATION_CONSTRAINTS B
  748. ForeignKey:AttrReference:ReferenceTable3=where A.RDB$CONST_NAME_UQ = B.RDB$CONSTRAINT_NAME
  749. ForeignKey:AttrReference:ReferenceTable4=and A.RDB$CONSTRAINT_NAME = `:RDB$CONSTRAINT_NAME`
  750. ForeignKey:AttrReference:MatchOption=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  751. ForeignKey:AttrReference:UpdateRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  752. ForeignKey:AttrReference:DeleteRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  753. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  754. ForeignKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  755. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [IndexColumn:%s, %s:N] ')'`
  756. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  757. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  758.  
  759. Trigger:Category=Executable
  760. Trigger:Attrs:Q=Text=Memo::"Text"::ER:PROOName
  761. Trigger:AttrReference:Text1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  762. Trigger:AttrReference:Text2=where RDB$TRIGGER_NAME=`OQ`
  763. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  764. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName` FOR `{<}N`
  765. Trigger:Text:Init2=AFTER UPDATE POSITION 0 AS`\N`BEGIN`\N`END
  766. Trigger:Text:Get1=CREATE TRIGGER `N` FOR `{<}N`
  767. Trigger:Text:Get2=`=Type` POSITION `=Position` `=Text`
  768. Trigger:Text:RE=CREATE\_+TRIGGER\_+(\w+)\_+FOR\_+(\w+)\_+(\w+\_\w+)\_+POSITION\_+(\w+)\_+(.*)
  769. Trigger:Text:Set=*N=1,2=`{<}N`,Type=3,Position=4,Text=5
  770. Trigger:Delete:Text=DROP TRIGGER `O`
  771.  
  772.  
  773.  
  774.