unidacdemoform.dfm

CrLab UniDAC 1.0 include sources

      '  Title VARCHAR(30),'
      '  Picture IMAGE'
      ');'
      ''
      'CREATE TABLE UniDAC_Text('
      '  ID INT PRIMARY KEY,'
      '  Title VARCHAR(30),'
      '  TextField TEXT'
      ');'
      ''
      'CREATE TABLE CRGRID_TEST ('
      '  Id INT PRIMARY KEY,'
      '  Name VARCHAR(10),'
      '  Country VARCHAR(30),'
      '  City VARCHAR(30),'
      '  Street VARCHAR(30),'
      '  BirthDate DATETIME,'
      '  Job VARCHAR(9),'
      '  Hiredate DATETIME,'
      '  Sal NUMERIC(7, 2),'
      '  Remarks TEXT'
      ');'
      ''
      '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, CONVERT(DATETIME, '#39'17-12-1980'#39', 10' +
        '5),800,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7499,'#39'ALLEN'#39','#39'SALESMAN'#39',7698,CONVERT(DATETIME, '#39'20-02-1981'#39', ' +
        '105),1600,300,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7521,'#39'WARD'#39','#39'SALESMAN'#39',7698,CONVERT(DATETIME, '#39'22-02-1981'#39', 1' +
        '05),1250,500,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7566,'#39'JONES'#39','#39'MANAGER'#39',7839,CONVERT(DATETIME, '#39'02-04-1981'#39', 1' +
        '05),2975,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7654,'#39'MARTIN'#39','#39'SALESMAN'#39',7698,CONVERT(DATETIME, '#39'28-09-1981'#39',' +
        ' 105),1250,1400,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7698,'#39'BLAKE'#39','#39'MANAGER'#39',7839,CONVERT(DATETIME, '#39'01-05-1981'#39', 1' +
        '05),2850,NULL,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7782,'#39'CLARK'#39','#39'MANAGER'#39',7839,CONVERT(DATETIME, '#39'09-06-1981'#39', 1' +
        '05),2450,NULL,10);'
      'INSERT INTO EMP VALUES'
      
        '  (7788,'#39'SCOTT'#39','#39'ANALYST'#39',7566,CONVERT(DATETIME, '#39'13-07-1987'#39', 1' +
        '05),3000,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7839,'#39'KING'#39','#39'PRESIDENT'#39',NULL,CONVERT(DATETIME, '#39'17-11-1981'#39', ' +
        '105),5000,NULL,10);'
      'INSERT INTO EMP VALUES'
      
        '  (7844,'#39'TURNER'#39','#39'SALESMAN'#39',7698,CONVERT(DATETIME, '#39'08-09-1981'#39',' +
        ' 105),1500,0,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7876,'#39'ADAMS'#39','#39'CLERK'#39',7788,CONVERT(DATETIME, '#39'13-07-1987'#39', 105' +
        '),1100,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7900,'#39'JAMES'#39','#39'CLERK'#39',7698,CONVERT(DATETIME, '#39'03-12-1981'#39', 105' +
        '),950,NULL,30);'
      'INSERT INTO EMP VALUES'
      
        '  (7902,'#39'FORD'#39','#39'ANALYST'#39',7566,CONVERT(DATETIME, '#39'03-12-1981'#39', 10' +
        '5),3000,NULL,20);'
      'INSERT INTO EMP VALUES'
      
        '  (7934,'#39'MILLER'#39','#39'CLERK'#39',7782,CONVERT(DATETIME, '#39'23-01-1982'#39', 10' +
        '5),1300,NULL,10);'
      ''
      
        'INSERT INTO CRGRID_TEST (Id, Name, Country, City, Street, BirthD' +
        'ate, Job, HireDate, Sal) VALUES'
      
        '  (5001, '#39'SMITH'#39', '#39'ENGLAND'#39', '#39'LONDON'#39', '#39'BOND st.'#39', CONVERT(DATET' +
        'IME, '#39'12-10-1963'#39', 105), '#39'CLERK'#39','
      '   CONVERT(DATETIME, '#39'17-12-1980'#39', 105), 800);'
      
        'INSERT INTO CRGRID_TEST (Id, Name, Country, City, Street, BirthD' +
        'ate, Job, HireDate, Sal) VALUES'
      
        '  (5002, '#39'ALLEN'#39', '#39'ENGLAND'#39', '#39'LONDON'#39', '#39'BAKER st.'#39', CONVERT(DATE' +
        'TIME, '#39'04-03-1961'#39', 105), '#39'SALESMAN'#39','
      '   CONVERT(DATETIME, '#39'20-02-1981'#39', 105), 1600);'
      
        'INSERT INTO CRGRID_TEST (Id, Name, Country, City, Street, BirthD' +
        'ate, Job, HireDate, Sal) VALUES'
      
        '  (5003, '#39'MARTIN'#39', '#39'FRANCE'#39', '#39'LION'#39', '#39'WEAVER st.'#39', CONVERT(DATET' +
        'IME, '#39'23-01-1957'#39', 105), '#39'MANAGER'#39','
      '   CONVERT(DATETIME, '#39'02-04-1981'#39', 105), 2900);'
      ''
      ''
      'GO'
      'CREATE PROCEDURE SEL_FROM_EMP'
      'AS'
      'BEGIN'
      '  SELECT * FROM Emp ORDER BY EmpNo;'
      'END;')
    Connection = UniConnection
    Left = 425
    Top = 166
  end
  object scDrop_InterBase: TUniScript
    SQL.Strings = (
      'DROP PROCEDURE SEL_FROM_EMP;'
      ''
      'COMMIT;'
      ''
      'DROP TABLE EMP;'
      ''
      'COMMIT;'
      ''
      'DROP TABLE DEPT;'
      ''
      'DROP TABLE UniDAC_BLOB;'
      ''
      'DROP TABLE UniDAC_Text;'
      ''
      'DROP TABLE CRGRID_TEST;'
      ''
      'COMMIT;')
    Connection = UniConnection
    Left = 393
    Top = 229
  end
  object scCreate_MySQL: TUniScript
    SQL.Strings = (
      'CREATE TABLE DEPT ('
      '  DEPTNO INT PRIMARY KEY AUTO_INCREMENT,'
      '  DNAME VARCHAR(14),'
      '  LOC VARCHAR(13)'
      ');'
      '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');'
      ''
      'CREATE TABLE EMP ('
      '  EMPNO INT PRIMARY KEY AUTO_INCREMENT,'
      '  ENAME VARCHAR(10),'
      '  JOB VARCHAR(9),'
      '  MGR INT,'
      '  HIREDATE DATETIME,'
      '  SAL FLOAT,'
      '  COMM FLOAT,'
      '  DEPTNO INT REFERENCES DEPT'
      ') ENGINE = InnoDB;'
      ''
      
        'INSERT INTO EMP VALUES (7369,'#39'SMITH'#39','#39'CLERK'#39',7902,'#39'1980-12-17'#39',8' +
        '00,NULL,20);'
      
        'INSERT INTO EMP VALUES (7499,'#39'ALLEN'#39','#39'SALESMAN'#39',7698,'#39'1981-2-20'#39 +
        ',1600,300,30);'
      
        'INSERT INTO EMP VALUES (7521,'#39'WARD'#39','#39'SALESMAN'#39',7698,'#39'1981-2-22'#39',' +
        '1250,500,30);'
      
        'INSERT INTO EMP VALUES (7566,'#39'JONES'#39','#39'MANAGER'#39',7839,'#39'1981-4-2'#39',2' +
        '975,NULL,20);'
      
        'INSERT INTO EMP VALUES (7654,'#39'MARTIN'#39','#39'SALESMAN'#39',7698,'#39'1981-9-28' +
        #39',1250,1400,30);'
      
        'INSERT INTO EMP VALUES (7698,'#39'BLAKE'#39','#39'MANAGER'#39',7839,'#39'1981-5-1'#39',2' +
        '850,NULL,30);'
      
        'INSERT INTO EMP VALUES (7782,'#39'CLARK'#39','#39'MANAGER'#39',7839,'#39'1981-6-9'#39',2' +
        '450,NULL,10);'
      
        'INSERT INTO EMP VALUES (7788,'#39'SCOTT'#39','#39'ANALYST'#39',7566,'#39'1987-7-13'#39',' +
        '3000,NULL,20);'
      
        'INSERT INTO EMP VALUES (7839,'#39'KING'#39','#39'PRESIDENT'#39',NULL,'#39'1981-11-17' +
        #39',5000,NULL,10);'
      
        'INSERT INTO EMP VALUES (7844,'#39'TURNER'#39','#39'SALESMAN'#39',7698,'#39'1981-9-8'#39 +
        ',1500,0,30);'
      
        'INSERT INTO EMP VALUES (7876,'#39'ADAMS'#39','#39'CLERK'#39',7788,'#39'1987-7-13'#39',11' +
        '00,NULL,20);'
      
        'INSERT INTO EMP VALUES (7900,'#39'JAMES'#39','#39'CLERK'#39',7698,'#39'1981-12-3'#39',95' +
        '0,NULL,30);'
      
        'INSERT INTO EMP VALUES (7902,'#39'FORD'#39','#39'ANALYST'#39',7566,'#39'1981-12-3'#39',3' +
        '000,NULL,20);'
      
        'INSERT INTO EMP VALUES (7934,'#39'MILLER'#39','#39'CLERK'#39',7782,'#39'1982-1-23'#39',1' +
        '300,NULL,10);'
      ''
      'CREATE TABLE CRGRID_TEST('
      '  Id int PRIMARY KEY AUTO_INCREMENT,'
      '  Name VARCHAR(10),'
      '  Country VARCHAR(30),'
      '  City VARCHAR(30),'
      '  Street VARCHAR(30),'
      '  BirthDate DATETIME,'
      '  Job VARCHAR(9),'
      '  Hiredate DATETIME,'
      '  Sal NUMERIC(7, 2),'
      '  Remarks TEXT'
      ');'
      
        'INSERT INTO CRGRID_TEST (Id, Name, Country, City, Street, BirthD' +
        'ate, Job, HireDate, Sal)'
      
        '    VALUES (5001, '#39'SMITH'#39', '#39'ENGLAND'#39', '#39'LONDON'#39', '#39'BOND st.'#39', '#39'196' +
        '3-11-12'#39', '#39'CLERK'#39','#39'1980-12-17'#39', 800);'
      
        'INSERT INTO CRGRID_TEST (Id, Name, Country, City, Street, BirthD' +
        'ate, Job, HireDate, Sal)'
      
        '    VALUES (5002, '#39'ALLEN'#39', '#39'ENGLAND'#39', '#39'LONDON'#39', '#39'BAKER st.'#39', '#39'19' +
        '61-03-04'#39', '#39'SALESMAN'#39','#39'1981-02-20'#39', 1600);'
      
        'INSERT INTO CRGRID_TEST (Id, Name, Country, City, Street, BirthD' +
        'ate, Job, HireDate, Sal)'
      
        '    VALUES(5003, '#39'MARTIN'#39', '#39'FRANCE'#39', '#39'LION'#39', '#39'WEAVER st.'#39', '#39'1957' +
        '-01-23'#39', '#39'MANAGER'#39','#39'1981-04-02'#39', 2900);'
      ''
      'CREATE TABLE UniDAC_BLOB ('
      '  UID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'
      '  Name VARCHAR(50),'
      '  Picture LONGBLOB'
      ');'
      ''
      'CREATE TABLE UniDAC_Text ('
      '  UID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'
      '  Name VARCHAR(50),'
      '  TextField TEXT'
      ');'
      ''
      'DELIMITER $'
      '/*!50001 '
      'CREATE PROCEDURE SEL_FROM_EMP() '
      'BEGIN '
      '  SELECT * FROM EMP; '
      'END '
      '*/;'
      '$'
      'DELIMITER ;')
    Connection = UniConnection
    Left = 455
    Top = 166
  end
end