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