emp.rtm

Crlab公司用来连接MySQL数据库的控件

          FieldName = 'DEPTNO'
          FieldLength = 0
          DataType = dtInteger
          DisplayWidth = 0
          Position = 0
          TableName = 'DEPT'
        end
        object ppField2: TppField
          FieldAlias = 'Dname'
          FieldName = 'DNAME'
          FieldLength = 0
          DisplayWidth = 0
          Position = 1
          TableName = 'DEPT'
        end
        object ppField3: TppField
          FieldAlias = 'Loc'
          FieldName = 'LOC'
          FieldLength = 0
          DisplayWidth = 0
          Position = 2
          TableName = 'DEPT'
        end
      end
      object daSQL1: TdaSQL
        DatabaseName = 'seDatabase'
        DatabaseType = dtOracle
        DataPipelineName = 'plDept'
        LinkColor = clBlack
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT DEPT.DEPTNO, DEPT.DNAME, DEPT.LOC'
          'FROM DEPT DEPT')
        SQLType = sqSQL1
        object TdaField
          Alias = 'Deptno'
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = 'Deptno'
          FieldLength = 0
          FieldName = 'DEPTNO'
          SQLFieldName = 'DEPTNO'
          TableAlias = 'DEPT'
          TableName = 'DEPT'
          TableSQLAlias = 'DEPT'
        end
        object TdaField
          Alias = 'Dname'
          DisplayWidth = 0
          FieldAlias = 'Dname'
          FieldLength = 0
          FieldName = 'DNAME'
          SQLFieldName = 'DNAME'
          TableAlias = 'DEPT'
          TableName = 'DEPT'
          TableSQLAlias = 'DEPT'
        end
        object TdaField
          Alias = 'Loc'
          DisplayWidth = 0
          FieldAlias = 'Loc'
          FieldLength = 0
          FieldName = 'LOC'
          SQLFieldName = 'LOC'
          TableAlias = 'DEPT'
          TableName = 'DEPT'
          TableSQLAlias = 'DEPT'
        end
        object TdaTable
          ChildType = 5
          Alias = 'DEPT'
          JoinType = dajtNone
          OwnerName = ''
          SQLAlias = 'DEPT'
          TableAlias = 'DEPT'
          TableName = 'DEPT'
        end
      end
    end
    object MyDACQueryDataView2: TdaMyDACQueryDataView
      UserName = 'Query_Emp'
      Height = 305
      Left = 289
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 7
      TypeColumnWidth = 52
      Width = 241
      AutoSearchTabOrder = 0
      object plEmp: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'plEmp'
        object ppField1: TppField
          FieldAlias = 'Empno'
          FieldName = 'EMPNO'
          FieldLength = 0
          DataType = dtInteger
          DisplayWidth = 0
          Position = 0
          TableName = 'EMP'
        end
        object ppField2: TppField
          FieldAlias = 'Ename'
          FieldName = 'ENAME'
          FieldLength = 0
          DisplayWidth = 0
          Position = 1
          TableName = 'EMP'
        end
        object ppField3: TppField
          FieldAlias = 'Job'
          FieldName = 'JOB'
          FieldLength = 0
          DisplayWidth = 0
          Position = 2
          TableName = 'EMP'
        end
        object ppField4: TppField
          FieldAlias = 'Mgr'
          FieldName = 'MGR'
          FieldLength = 0
          DataType = dtInteger
          DisplayWidth = 0
          Position = 3
          TableName = 'EMP'
        end
        object ppField5: TppField
          FieldAlias = 'Hiredate'
          FieldName = 'HIREDATE'
          FieldLength = 0
          DataType = dtDateTime
          DisplayWidth = 0
          Position = 4
          TableName = 'EMP'
        end
        object ppField6: TppField
          FieldAlias = 'Sal'
          FieldName = 'SAL'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 0
          Position = 5
          TableName = 'EMP'
        end
        object ppField7: TppField
          FieldAlias = 'Comm'
          FieldName = 'COMM'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 0
          Position = 6
          TableName = 'EMP'
        end
        object ppField8: TppField
          FieldAlias = 'Deptno'
          FieldName = 'DEPTNO'
          FieldLength = 0
          DataType = dtInteger
          DisplayWidth = 0
          Position = 7
          TableName = 'EMP'
        end
      end
      object daSQL2: TdaSQL
        DatabaseName = 'seDatabase'
        DatabaseType = dtOracle
        DataPipelineName = 'plEmp'
        LinkColor = clBlack
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, '
          '       EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO'
          'FROM EMP EMP')
        SQLType = sqSQL1
        object TdaField
          Alias = 'Empno'
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = 'Empno'
          FieldLength = 0
          FieldName = 'EMPNO'
          SQLFieldName = 'EMPNO'
          TableAlias = 'EMP'
          TableName = 'EMP'
          TableSQLAlias = 'EMP'
        end
        object TdaField
          Alias = 'Ename'
          DisplayWidth = 0
          FieldAlias = 'Ename'
          FieldLength = 0
          FieldName = 'ENAME'
          SQLFieldName = 'ENAME'
          TableAlias = 'EMP'
          TableName = 'EMP'
          TableSQLAlias = 'EMP'
        end
        object TdaField
          Alias = 'Job'
          DisplayWidth = 0
          FieldAlias = 'Job'
          FieldLength = 0
          FieldName = 'JOB'
          SQLFieldName = 'JOB'
          TableAlias = 'EMP'
          TableName = 'EMP'
          TableSQLAlias = 'EMP'
        end
        object TdaField
          Alias = 'Mgr'
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = 'Mgr'
          FieldLength = 0
          FieldName = 'MGR'
          SQLFieldName = 'MGR'
          TableAlias = 'EMP'
          TableName = 'EMP'
          TableSQLAlias = 'EMP'
        end
        object TdaField
          Alias = 'Hiredate'
          DataType = dtDateTime
          DisplayWidth = 0
          FieldAlias = 'Hiredate'
          FieldLength = 0
          FieldName = 'HIREDATE'
          SQLFieldName = 'HIREDATE'
          TableAlias = 'EMP'
          TableName = 'EMP'
          TableSQLAlias = 'EMP'
        end
        object TdaField
          Alias = 'Sal'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Sal'
          FieldLength = 0
          FieldName = 'SAL'
          SQLFieldName = 'SAL'
          TableAlias = 'EMP'
          TableName = 'EMP'
          TableSQLAlias = 'EMP'
        end
        object TdaField
          Alias = 'Comm'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Comm'
          FieldLength = 0
          FieldName = 'COMM'
          SQLFieldName = 'COMM'
          TableAlias = 'EMP'
          TableName = 'EMP'
          TableSQLAlias = 'EMP'
        end
        object TdaField
          Alias = 'Deptno'
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = 'Deptno'
          FieldLength = 0
          FieldName = 'DEPTNO'
          SQLFieldName = 'DEPTNO'
          TableAlias = 'EMP'
          TableName = 'EMP'
          TableSQLAlias = 'EMP'
        end
        object TdaTable
          ChildType = 5
          Alias = 'EMP'
          JoinType = dajtNone
          OwnerName = ''
          SQLAlias = 'EMP'
          TableAlias = 'EMP'
          TableName = 'EMP'
        end
      end
    end
    object MyDACQueryDataView3: TdaMyDACQueryDataView
      UserName = 'Query_Query'
      Height = 305
      Left = 572
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 242
      AutoSearchTabOrder = 0
      object plQuery: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'plQuery'
        object ppField1: TppField
          FieldAlias = 'DEPTNO'
          FieldName = 'DEPTNO'
          FieldLength = 10
          DataType = dtInteger
          DisplayWidth = 10
          Position = 0
        end
        object ppField2: TppField
          FieldAlias = 'DNAME'
          FieldName = 'DNAME'
          FieldLength = 10
          DisplayWidth = 10
          Position = 1
        end
        object ppField3: TppField
          FieldAlias = 'LOC'
          FieldName = 'LOC'
          FieldLength = 10
          DisplayWidth = 10
          Position = 2
        end
        object ppField4: TppField
          FieldAlias = 'EMPNO'
          FieldName = 'EMPNO'
          FieldLength = 10
          DataType = dtInteger
          DisplayWidth = 10
          Position = 3
        end
        object ppField5: TppField
          FieldAlias = 'ENAME'
          FieldName = 'ENAME'
          FieldLength = 10
          DisplayWidth = 10
          Position = 4
        end
        object ppField6: TppField
          FieldAlias = 'JOB'
          FieldName = 'JOB'
          FieldLength = 10
          DisplayWidth = 10
          Position = 5
        end
        object ppField7: TppField
          FieldAlias = 'MGR'
          FieldName = 'MGR'
          FieldLength = 10
          DataType = dtInteger
          DisplayWidth = 10
          Position = 6
        end
        object ppField8: TppField
          FieldAlias = 'HIREDATE'
          FieldName = 'HIREDATE'
          FieldLength = 10
          DataType = dtDateTime
          DisplayWidth = 10
          Position = 7
        end
        object ppField9: TppField
          FieldAlias = 'SAL'
          FieldName = 'SAL'
          FieldLength = 10
          DataType = dtDouble
          DisplayWidth = 10
          Position = 8
        end
        object ppField10: TppField
          FieldAlias = 'COMM'
          FieldName = 'COMM'
          FieldLength = 10
          DataType = dtDouble
          DisplayWidth = 10
          Position = 9
        end
        object ppField11: TppField
          FieldAlias = 'DEPTNO_1'
          FieldName = 'DEPTNO_1'
          FieldLength = 10
          DataType = dtInteger
          DisplayWidth = 10
          Position = 10
        end
      end
      object daSQL3: TdaSQL
        CollationType = ctASCII
        DatabaseName = 'seDatabase'
        DatabaseType = dtOracle
        DataPipelineName = 'plQuery'
        EditSQLAsText = True
        IsCaseSensitive = True
        LinkColor = clBlack
        MaxSQLFieldAliasLength = 0
        SQLText.Strings = (
          'SELECT DEPT.DEPTNO, DEPT.DNAME, '
          '       DEPT.LOC, EMP.EMPNO, '
          '       EMP.ENAME, EMP.JOB, '
          '       EMP.MGR, EMP.HIREDATE, '
          '       EMP.SAL, EMP.COMM, '
          '       EMP.DEPTNO'
          'FROM DEPT, EMP'
          'WHERE (EMP.DEPTNO = DEPT.DEPTNO)')
        SQLType = sqSQL1
        object daField1: TdaField
          Alias = 'DEPTNO'
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = 'DEPTNO'
          FieldLength = 10
          FieldName = 'DEPTNO'
          SQLFieldName = 'DEPTNO'
        end
        object daField2: TdaField
          Alias = 'DNAME'
          DisplayWidth = 10
          FieldAlias = 'DNAME'
          FieldLength = 10
          FieldName = 'DNAME'
          SQLFieldName = 'DNAME'
        end
        object daField3: TdaField
          Alias = 'LOC'
          DisplayWidth = 10
          FieldAlias = 'LOC'
          FieldLength = 10
          FieldName = 'LOC'
          SQLFieldName = 'LOC'
        end
        object daField4: TdaField
          Alias = 'EMPNO'
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = 'EMPNO'
          FieldLength = 10
          FieldName = 'EMPNO'
          SQLFieldName = 'EMPNO'
        end
        object daField5: TdaField
          Alias = 'ENAME'
          DisplayWidth = 10
          FieldAlias = 'ENAME'
          FieldLength = 10
          FieldName = 'ENAME'
          SQLFieldName = 'ENAME'
        end
        object daField6: TdaField
          Alias = 'JOB'
          DisplayWidth = 10
          FieldAlias = 'JOB'
          FieldLength = 10
          FieldName = 'JOB'
          SQLFieldName = 'JOB'
        end
        object daField7: TdaField
          Alias = 'MGR'
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = 'MGR'
          FieldLength = 10
          FieldName = 'MGR'
          SQLFieldName = 'MGR'
        end
        object daField8: TdaField
          Alias = 'HIREDATE'
          DataType = dtDateTime
          DisplayWidth = 10
          FieldAlias = 'HIREDATE'
          FieldLength = 10
          FieldName = 'HIREDATE'
          SQLFieldName = 'HIREDATE'
        end
        object daField9: TdaField
          Alias = 'SAL'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'SAL'
          FieldLength = 10
          FieldName = 'SAL'
          SQLFieldName = 'SAL'
        end
        object daField10: TdaField
          Alias = 'COMM'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'COMM'
          FieldLength = 10
          FieldName = 'COMM'
          SQLFieldName = 'COMM'
        end
        object daField11: TdaField
          Alias = 'DEPTNO_1'
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = 'DEPTNO_1'
          FieldLength = 10
          FieldName = 'DEPTNO_1'
          SQLFieldName = 'DEPTNO_1'
        end
      end
    end
  end
end