📄 unidacdemoform.dfm
字号:
'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
object scCreate_PgSQL: TUniScript
SQL.Strings = (
'CREATE TABLE DEPT ('
' DEPTNO SERIAL NOT NULL,'
' DNAME VARCHAR(14),'
' LOC VARCHAR(13),'
' PRIMARY KEY (DEPTNO)'
');'
'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 SERIAL NOT NULL,'
' ENAME VARCHAR(10),'
' JOB VARCHAR(9),'
' MGR INTEGER,'
' HIREDATE TIMESTAMP,'
' SAL REAL,'
' COMM REAL,'
' DEPTNO INT REFERENCES DEPT,'
' PRIMARY KEY (EMPNO)'
');'
''
'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 SERIAL NOT NULL,'
' Name VARCHAR(10),'
' Country VARCHAR(30),'
' City VARCHAR(30),'
' Street VARCHAR(30),'
' BirthDate DATE,'
' Job VARCHAR(9),'
' Hiredate DATE,'
' Sal NUMERIC(7, 2),'
' Remarks TEXT,'
' PRIMARY KEY (Id)'
');'
'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 SERIAL NOT NULL,'
' Name VARCHAR(50),'
' Picture BYTEA,'
' PRIMARY KEY (UID)'
');'
''
'CREATE TABLE UniDAC_Text ('
' UID SERIAL NOT NULL,'
' Name VARCHAR(50),'
' TextField TEXT,'
' PRIMARY KEY (UID)'
');'
''
'CREATE FUNCTION SEL_FROM_EMP() RETURNS SETOF Emp AS $$'
' SELECT * FROM Emp ORDER BY EmpNo;'
'$$ LANGUAGE SQL;')
Connection = UniConnection
Left = 487
Top = 166
end
object scDrop_PgSQL: TUniScript
SQL.Strings = (
'DROP FUNCTION SEL_FROM_EMP();'
''
'DROP TABLE EMP;'
''
'DROP TABLE DEPT;'
''
'DROP TABLE UniDAC_BLOB;'
''
'DROP TABLE UniDAC_Text;'
''
'DROP TABLE CRGRID_TEST;')
Connection = UniConnection
Left = 425
Top = 229
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -