data.nfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

object DM: TDM
  OldCreateOrder = False
  Left = 188
  Top = 108
  Height = 214
  Width = 278
  object Connection: TOraSession
    Options.DisconnectedMode = True
    Options.LocalFailover = True
    Pooling = True
    Left = 32
    Top = 32
  end
  object quDetail: TOraQuery
    Session = Connection
    SQL.Strings = (
      'select * from emp')
    MasterSource = dsMaster
    MasterFields = 'DEPTNO'
    DetailFields = 'DEPTNO'
    Debug = True
    FetchAll = True
    CachedUpdates = True
    Options.LocalMasterDetail = True
    Left = 104
    Top = 88
  end
  object quMaster: TOraQuery
    Session = Connection
    SQL.Strings = (
      'select * from dept'
      '')
    Debug = True
    FetchAll = True
    CachedUpdates = True
    Left = 104
    Top = 32
  end
  object dsDetail: TDataSource
    DataSet = quDetail
    Left = 136
    Top = 80
  end
  object dsMaster: TDataSource
    DataSet = quMaster
    Left = 136
    Top = 24
  end
  object scCreate: TOraScript
    SQL.Strings = (
      'CREATE TABLE DEPT ('
      '  DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,'
      '  DNAME VARCHAR2(14) ,'
      '  LOC VARCHAR2(13)'
      ');'
      ''
      'CREATE TABLE EMP ('
      '  EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,'
      '  ENAME VARCHAR2(10),'
      '  JOB VARCHAR2(9),'
      '  MGR NUMBER(4),'
      '  HIREDATE DATE,'
      '  SAL NUMBER(7,2),'
      '  COMM NUMBER(7,2),'
      '  DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT'
      ');'
      ''
      'INSERT INTO DEPT VALUES'
      '  (10,'#39'ACCOUNTING'#39','#39'NEW YORK'#39');'
      'INSERT INTO DEPT VALUES'
      '  (20,'#39'RESEARCH'#39','#39'DALLAS'#39');'
      'INSERT INTO DEPT VALUES'
      '  (30,'#39'SALES'#39','#39'CHICAGO'#39');'
      'INSERT INTO DEPT VALUES'
      '  (40,'#39'OPERATIONS'#39','#39'BOSTON'#39');'
      ''
      'INSERT INTO EMP VALUES'
      
        '  (7369,'#39'SMITH'#39','#39'CLERK'#39',7902,to_date('#39'17-12-1980'#39','#39'dd-mm-yyyy'#39'),' +
        '800,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7499,'#39'ALLEN'#39','#39'SALESMAN'#39',7698,to_date('#39'20-02-1981'#39','#39'dd-mm-yyyy' +
        #39'),1600,300,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7521,'#39'WARD'#39','#39'SALESMAN'#39',7698,to_date('#39'22-02-1981'#39','#39'dd-mm-yyyy'#39 +
        '),1250,500,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7566,'#39'JONES'#39','#39'MANAGER'#39',7839,to_date('#39'02-04-1981'#39','#39'dd-mm-yyyy'#39 +
        '),2975,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7654,'#39'MARTIN'#39','#39'SALESMAN'#39',7698,to_date('#39'28-09-1981'#39','#39'dd-mm-yyy' +
        'y'#39'),1250,1400,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7698,'#39'BLAKE'#39','#39'MANAGER'#39',7839,to_date('#39'01-05-1981'#39','#39'dd-mm-yyyy'#39 +
        '),2850,NULL,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7782,'#39'CLARK'#39','#39'MANAGER'#39',7839,to_date('#39'09-06-1981'#39','#39'dd-mm-yyyy'#39 +
        '),2450,NULL,10);'
      'INSERT INTO EMP VALUES'
      
        '  (7788,'#39'SCOTT'#39','#39'ANALYST'#39',7566,to_date('#39'13-07-87'#39','#39'dd-mm-yyyy'#39'),' +
        '3000,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7839,'#39'KING'#39','#39'PRESIDENT'#39',NULL,to_date('#39'17-11-1981'#39','#39'dd-mm-yyyy' +
        #39'),5000,NULL,10);'
      'INSERT INTO EMP VALUES'
      
        '  (7844,'#39'TURNER'#39','#39'SALESMAN'#39',7698,to_date('#39'08-09-1981'#39','#39'dd-mm-yyy' +
        'y'#39'),1500,0,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7876,'#39'ADAMS'#39','#39'CLERK'#39',7788,to_date('#39'13-07-87'#39','#39'dd-mm-yyyy'#39'),11' +
        '00,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7900,'#39'JAMES'#39','#39'CLERK'#39',7698,to_date('#39'03-12-1981'#39','#39'dd-mm-yyyy'#39'),' +
        '950,NULL,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7902,'#39'FORD'#39','#39'ANALYST'#39',7566,to_date('#39'03-12-1981'#39','#39'dd-mm-yyyy'#39')' +
        ',3000,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7934,'#39'MILLER'#39','#39'CLERK'#39',7782,to_date('#39'23-01-1982'#39','#39'dd-mm-yyyy'#39')' +
        ',1300,NULL,10);'
      ''
      'COMMIT;')
    Session = Connection
    Left = 200
    Top = 24
  end
  object scDrop: TOraScript
    SQL.Strings = (
      'DROP TABLE EMP;'
      'DROP TABLE DEPT;')
    Session = Connection
    Left = 200
    Top = 80
  end
end