📄 emp.rtm
字号:
end
end
object TdaDataModule
object TdaODACQueryDataView
Report = ppReport
UserName = 'Query_Dept'
Left = 4
Top = 7
Width = 238
Height = 304
AutoSearchTabOrder = 0
object plDept: TppChildDBPipeline
AutoCreateFields = False
UserName = 'plDept'
object TppField
FieldAlias = 'Deptno'
FieldName = 'DEPTNO'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 0
TableName = 'SCOTT.DEPT'
end
object TppField
FieldAlias = 'Dname'
FieldName = 'DNAME'
FieldLength = 14
DisplayWidth = 14
Position = 1
TableName = 'SCOTT.DEPT'
end
object TppField
FieldAlias = 'Loc'
FieldName = 'LOC'
FieldLength = 13
DisplayWidth = 13
Position = 2
TableName = 'SCOTT.DEPT'
end
end
object TdaSQL
DatabaseName = 'seDatabase'
DatabaseType = dtOracle
DataPipelineName = 'plDept'
Description = 'Dept'
SQLText.Strings = (
'SELECT SCOTT_DEPT.DEPTNO, SCOTT_DEPT.DNAME, '
' SCOTT_DEPT.LOC'
'FROM SCOTT.DEPT SCOTT_DEPT')
SQLType = sqSQL1
object TdaField
Alias = 'Deptno'
DataType = dtInteger
FieldAlias = 'Deptno'
FieldName = 'DEPTNO'
TableName = 'SCOTT.DEPT'
SQLFieldName = 'DEPTNO'
TableAlias = 'Dept'
TableSQLAlias = 'SCOTT_DEPT'
end
object TdaField
Alias = 'Dname'
FieldAlias = 'Dname'
FieldName = 'DNAME'
TableName = 'SCOTT.DEPT'
SQLFieldName = 'DNAME'
TableAlias = 'Dept'
TableSQLAlias = 'SCOTT_DEPT'
end
object TdaField
Alias = 'Loc'
FieldAlias = 'Loc'
FieldName = 'LOC'
TableName = 'SCOTT.DEPT'
SQLFieldName = 'LOC'
TableAlias = 'Dept'
TableSQLAlias = 'SCOTT_DEPT'
end
object TdaTable
ChildType = 5
Alias = 'Dept'
OwnerName = 'SCOTT'
TableAlias = 'Dept'
TableName = 'DEPT'
SQLAlias = 'SCOTT_DEPT'
JoinType = dajtNone
end
end
end
object TdaODACQueryDataView
Report = ppReport
UserName = 'Query_Emp'
Left = 249
Top = 7
Width = 241
Height = 305
AutoSearchTabOrder = 0
object plEmp: TppChildDBPipeline
AutoCreateFields = False
UserName = 'plEmp'
object TppField
FieldAlias = 'Empno'
FieldName = 'EMPNO'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 0
TableName = 'SCOTT.EMP'
end
object TppField
FieldAlias = 'Ename'
FieldName = 'ENAME'
FieldLength = 10
DisplayWidth = 10
Position = 1
TableName = 'SCOTT.EMP'
end
object TppField
FieldAlias = 'Job'
FieldName = 'JOB'
FieldLength = 9
DisplayWidth = 9
Position = 2
TableName = 'SCOTT.EMP'
end
object TppField
FieldAlias = 'Mgr'
FieldName = 'MGR'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 3
TableName = 'SCOTT.EMP'
end
object TppField
FieldAlias = 'Hiredate'
FieldName = 'HIREDATE'
FieldLength = 0
DataType = dtDateTime
DisplayWidth = 18
Position = 4
TableName = 'SCOTT.EMP'
end
object TppField
FieldAlias = 'Sal'
FieldName = 'SAL'
FieldLength = 0
DataType = dtDouble
DisplayWidth = 10
Position = 5
TableName = 'SCOTT.EMP'
end
object TppField
FieldAlias = 'Comm'
FieldName = 'COMM'
FieldLength = 0
DataType = dtDouble
DisplayWidth = 10
Position = 6
TableName = 'SCOTT.EMP'
end
object TppField
FieldAlias = 'Deptno'
FieldName = 'DEPTNO'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 7
TableName = 'SCOTT.EMP'
end
end
object TdaSQL
DatabaseName = 'seDatabase'
DatabaseType = dtOracle
DataPipelineName = 'plEmp'
Description = 'Emp'
SQLText.Strings = (
'SELECT SCOTT_EMP.EMPNO, SCOTT_EMP.ENAME, '
' SCOTT_EMP.JOB, SCOTT_EMP.MGR, '
' SCOTT_EMP.HIREDATE, SCOTT_EMP.SAL, '
' SCOTT_EMP.COMM, SCOTT_EMP.DEPTNO'
'FROM SCOTT.EMP SCOTT_EMP')
SQLType = sqSQL1
object TdaField
Alias = 'Empno'
DataType = dtInteger
FieldAlias = 'Empno'
FieldName = 'EMPNO'
TableName = 'SCOTT.EMP'
SQLFieldName = 'EMPNO'
TableAlias = 'Emp'
TableSQLAlias = 'SCOTT_EMP'
end
object TdaField
Alias = 'Ename'
FieldAlias = 'Ename'
FieldName = 'ENAME'
TableName = 'SCOTT.EMP'
SQLFieldName = 'ENAME'
TableAlias = 'Emp'
TableSQLAlias = 'SCOTT_EMP'
end
object TdaField
Alias = 'Job'
FieldAlias = 'Job'
FieldName = 'JOB'
TableName = 'SCOTT.EMP'
SQLFieldName = 'JOB'
TableAlias = 'Emp'
TableSQLAlias = 'SCOTT_EMP'
end
object TdaField
Alias = 'Mgr'
DataType = dtInteger
FieldAlias = 'Mgr'
FieldName = 'MGR'
TableName = 'SCOTT.EMP'
SQLFieldName = 'MGR'
TableAlias = 'Emp'
TableSQLAlias = 'SCOTT_EMP'
end
object TdaField
Alias = 'Hiredate'
DataType = dtDateTime
FieldAlias = 'Hiredate'
FieldName = 'HIREDATE'
TableName = 'SCOTT.EMP'
SQLFieldName = 'HIREDATE'
TableAlias = 'Emp'
TableSQLAlias = 'SCOTT_EMP'
end
object TdaField
Alias = 'Sal'
DataType = dtDouble
FieldAlias = 'Sal'
FieldName = 'SAL'
TableName = 'SCOTT.EMP'
SQLFieldName = 'SAL'
TableAlias = 'Emp'
TableSQLAlias = 'SCOTT_EMP'
end
object TdaField
Alias = 'Comm'
DataType = dtDouble
FieldAlias = 'Comm'
FieldName = 'COMM'
TableName = 'SCOTT.EMP'
SQLFieldName = 'COMM'
TableAlias = 'Emp'
TableSQLAlias = 'SCOTT_EMP'
end
object TdaField
Alias = 'Deptno'
DataType = dtInteger
FieldAlias = 'Deptno'
FieldName = 'DEPTNO'
TableName = 'SCOTT.EMP'
SQLFieldName = 'DEPTNO'
TableAlias = 'Emp'
TableSQLAlias = 'SCOTT_EMP'
end
object TdaTable
ChildType = 5
Alias = 'Emp'
OwnerName = 'SCOTT'
TableAlias = 'Emp'
TableName = 'EMP'
SQLAlias = 'SCOTT_EMP'
JoinType = dajtNone
end
end
end
object TdaODACQueryDataView
Report = ppReport
UserName = 'Query_Query'
Left = 596
Top = 9
Width = 242
Height = 305
AutoSearchTabOrder = 0
object plQuery: TppChildDBPipeline
AutoCreateFields = False
UserName = 'plQuery'
object TppField
FieldAlias = 'DEPTNO'
FieldName = 'DEPTNO'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 0
end
object TppField
FieldAlias = 'DNAME'
FieldName = 'DNAME'
FieldLength = 14
DisplayWidth = 14
Position = 1
end
object TppField
FieldAlias = 'LOC'
FieldName = 'LOC'
FieldLength = 13
DisplayWidth = 13
Position = 2
end
object TppField
FieldAlias = 'EMPNO'
FieldName = 'EMPNO'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 3
end
object TppField
FieldAlias = 'ENAME'
FieldName = 'ENAME'
FieldLength = 10
DisplayWidth = 10
Position = 4
end
object TppField
FieldAlias = 'JOB'
FieldName = 'JOB'
FieldLength = 9
DisplayWidth = 9
Position = 5
end
object TppField
FieldAlias = 'MGR'
FieldName = 'MGR'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 6
end
object TppField
FieldAlias = 'HIREDATE'
FieldName = 'HIREDATE'
FieldLength = 0
DataType = dtDateTime
DisplayWidth = 18
Position = 7
end
object TppField
FieldAlias = 'SAL'
FieldName = 'SAL'
FieldLength = 0
DataType = dtDouble
DisplayWidth = 10
Position = 8
end
object TppField
FieldAlias = 'COMM'
FieldName = 'COMM'
FieldLength = 0
DataType = dtDouble
DisplayWidth = 10
Position = 9
end
object TppField
FieldAlias = 'DEPTNO_1'
FieldName = 'DEPTNO_1'
FieldLength = 0
DataType = dtInteger
DisplayWidth = 10
Position = 10
end
end
object TdaSQL
DatabaseName = 'seDatabase'
DatabaseType = dtOracle
DataPipelineName = 'plQuery'
Description = 'Query'
EditSQLAsText = True
SQLText.Strings = (
'SELECT SCOTT_DEPT.DEPTNO, SCOTT_DEPT.DNAME, '
' SCOTT_DEPT.LOC, SCOTT_EMP.EMPNO, '
' SCOTT_EMP.ENAME, SCOTT_EMP.JOB, '
' SCOTT_EMP.MGR, SCOTT_EMP.HIREDATE, '
' SCOTT_EMP.SAL, SCOTT_EMP.COMM, '
' SCOTT_EMP.DEPTNO'
'FROM SCOTT.DEPT SCOTT_DEPT, SCOTT.EMP SCOTT_EMP'
'WHERE (SCOTT_EMP.DEPTNO(+) = SCOTT_DEPT.DEPTNO)')
SQLType = sqSQL1
object TdaField
Alias = 'DEPTNO'
DataType = dtInteger
FieldAlias = 'DEPTNO'
FieldName = 'DEPTNO'
SQLFieldName = 'DEPTNO'
end
object TdaField
Alias = 'DNAME'
FieldAlias = 'DNAME'
FieldName = 'DNAME'
SQLFieldName = 'DNAME'
end
object TdaField
Alias = 'LOC'
FieldAlias = 'LOC'
FieldName = 'LOC'
SQLFieldName = 'LOC'
end
object TdaField
Alias = 'EMPNO'
DataType = dtInteger
FieldAlias = 'EMPNO'
FieldName = 'EMPNO'
SQLFieldName = 'EMPNO'
end
object TdaField
Alias = 'ENAME'
FieldAlias = 'ENAME'
FieldName = 'ENAME'
SQLFieldName = 'ENAME'
end
object TdaField
Alias = 'JOB'
FieldAlias = 'JOB'
FieldName = 'JOB'
SQLFieldName = 'JOB'
end
object TdaField
Alias = 'MGR'
DataType = dtInteger
FieldAlias = 'MGR'
FieldName = 'MGR'
SQLFieldName = 'MGR'
end
object TdaField
Alias = 'HIREDATE'
DataType = dtDateTime
FieldAlias = 'HIREDATE'
FieldName = 'HIREDATE'
SQLFieldName = 'HIREDATE'
end
object TdaField
Alias = 'SAL'
DataType = dtDouble
FieldAlias = 'SAL'
FieldName = 'SAL'
SQLFieldName = 'SAL'
end
object TdaField
Alias = 'COMM'
DataType = dtDouble
FieldAlias = 'COMM'
FieldName = 'COMM'
SQLFieldName = 'COMM'
end
object TdaField
Alias = 'DEPTNO_1'
DataType = dtInteger
FieldAlias = 'DEPTNO_1'
FieldName = 'DEPTNO_1'
SQLFieldName = 'DEPTNO_1'
end
end
end
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -