mydacdemoform.nfm

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

    PasswordLabel = 'Password'
    ServerLabel = 'Server'
    ConnectButton = 'Connect'
    CancelButton = 'Cancel'
    Left = 500
    Top = 10
  end
  object scCreate: TMyScript
    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'
      ');'
      
        '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 EMP_TRANACTION_SAFE ('
      '  EMPNO INT PRIMARY KEY AUTO_INCREMENT,'
      '  ENAME VARCHAR(10),'
      '  JOB VARCHAR(9),'
      '  MGR INT,'
      '  HIREDATE DATETIME,'
      '  SAL FLOAT,'
      '  COMM FLOAT,'
      '  DEPTNO INT REFERENCES DEPT'
      ') TYPE = INNODB;'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7369,'#39'SMITH'#39','#39'CLERK'#39',790' +
        '2,'#39'1980-12-17'#39',800,NULL,20);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7499,'#39'ALLEN'#39','#39'SALESMAN'#39',' +
        '7698,'#39'1981-2-20'#39',1600,300,30);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7521,'#39'WARD'#39','#39'SALESMAN'#39',7' +
        '698,'#39'1981-2-22'#39',1250,500,30);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7566,'#39'JONES'#39','#39'MANAGER'#39',7' +
        '839,'#39'1981-4-2'#39',2975,NULL,20);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7654,'#39'MARTIN'#39','#39'SALESMAN'#39 +
        ',7698,'#39'1981-9-28'#39',1250,1400,30);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7698,'#39'BLAKE'#39','#39'MANAGER'#39',7' +
        '839,'#39'1981-5-1'#39',2850,NULL,30);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7782,'#39'CLARK'#39','#39'MANAGER'#39',7' +
        '839,'#39'1981-6-9'#39',2450,NULL,10);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7788,'#39'SCOTT'#39','#39'ANALYST'#39',7' +
        '566,'#39'1987-7-13'#39',3000,NULL,20);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7839,'#39'KING'#39','#39'PRESIDENT'#39',' +
        'NULL,'#39'1981-11-17'#39',5000,NULL,10);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7844,'#39'TURNER'#39','#39'SALESMAN'#39 +
        ',7698,'#39'1981-9-8'#39',1500,0,30);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7876,'#39'ADAMS'#39','#39'CLERK'#39',778' +
        '8,'#39'1987-7-13'#39',1100,NULL,20);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7900,'#39'JAMES'#39','#39'CLERK'#39',769' +
        '8,'#39'1981-12-3'#39',950,NULL,30);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7902,'#39'FORD'#39','#39'ANALYST'#39',75' +
        '66,'#39'1981-12-3'#39',3000,NULL,20);'
      
        'INSERT INTO EMP_TRANACTION_SAFE VALUES (7934,'#39'MILLER'#39','#39'CLERK'#39',77' +
        '82,'#39'1982-1-23'#39',1300,NULL,10);'
      ''
      'CREATE TABLE MYDAC_Loaded ('
      '  Code INT,'
      '  Num INT,'
      '  Num1 FLOAT,'
      '  Str VARCHAR(50),'
      '  Dat DATE'
      ');'
      ''
      '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 MYDAC_Pictures ('
      '  UID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'
      '  Name VARCHAR(50),'
      '  Picture LONGBLOB'
      ');'
      ''
      'CREATE TABLE MYDAC_Text ('
      '  UID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'
      '  Name VARCHAR(50),'
      '  TextField TEXT'
      ');'
      ''
      'DELIMITER $'
      '/*!50001 '
      'CREATE PROCEDURE `test`.`sel_from_emp`() '
      'BEGIN '
      '  SELECT * FROM EMP; '
      'END '
      '*/;'
      '$'
      'DELIMITER ; ')
    OnError = OnScriptError
    Connection = MyConnection
    Left = 464
    Top = 41
  end
  object scDrop: TMyScript
    SQL.Strings = (
      'DROP TABLE IF EXISTS DEPT;'
      'DROP TABLE IF EXISTS EMP;'
      'DROP TABLE IF EXISTS MYDAC_Loaded;'
      'DROP TABLE IF EXISTS CRGRID_TEST;'
      'DROP TABLE IF EXISTS MYDAC_Pictures;'
      'DROP TABLE IF EXISTS MYDAC_Text;'
      'DROP TABLE IF EXISTS EMP_TRANACTION_SAFE;'
      '/*!50001'
      'DROP PROCEDURE IF EXISTS sel_from_emp'
      '*/;')
    OnError = OnScriptError
    Connection = MyConnection
    Left = 499
    Top = 41
  end
end