|
|
Á¦¸ñ : ¿¬Â÷
|

|
|
µî·ÏÀÏ |
2020-02-12 10:57:27 |
|
ÆÄÀÏÅ©±â |
1 MB |
|
ÆÄÀÏÀ̸§ |
WCalcPay.bpl |
|
µî·ÏÀÚ |
°ü¸®ÀÚ |
|
Á¶È¸¼ö |
1330 |
|
|
|
|
1) YEARCHA1 »ý¼º
CREATE TABLE YEARCHA1 (
EMPNO CHAR(3) NOT NULL,
JIGUBYM VARCHAR(10) NOT NULL,
EMPNM VARCHAR(10),
DAYAMT NUMERIC(15,2),
JIGUBAMT NUMERIC(15,2),
YEARUSE NUMERIC(15,2),
TOTUSE NUMERIC(15,2),
K01 NUMERIC(15,2),
THISPRESENT NUMERIC(15,2),
THISABSENT NUMERIC(15,2),
YEARDD NUMERIC(15,2)
);
2) YEARCHA -> YEARCHA1·Î º¹»ç
insert into yearcha1(EMPNO,
JIGUBYM,
EMPNM,
DAYAMT,
JIGUBAMT,
YEARDD,
YEARUSE,
TOTUSE,
K01,
THISPRESENT)select
EMPNO,
JIGUBYM,
EMPNM,
DAYAMT,
JIGUBAMT,
YEARDD,
YEARUSE,
TOTUSE,
K01,
THISPRESENT from yearcha
3) YEARCHA Å×À̺í drop
ibexpert¿¡¼ YEARCHA Å×ÀÌºí¿¡ ¸¶¿ì½º ¿À¸¥ÂÊÀ» Ŭ¸¯ÇÏ¸é ¼¼ ¹øÂ° ¸Þ´º¿¡ drop table°¡ ÀÖÀ½
4) YEARCHA1 Å×ÀÌºí¿¡ À̸§À» º¯°æ
- ¾Æ·¡ µÎ °³ Äõ¸®¸¦ ¼öÇà ÈÄ Ä¿¹ÔÇØ ÁÖ¸é µÊ
UPDATE RDB$RELATIONS
SET RDB$RELATION_NAME='YEARCHA'
where RDB$RELATION_NAME='YEARCHA1';
UPDATE RDB$RELATION_FIELDS
SET RDB$RELATION_NAME='YEARCHA'
where RDB$RELATION_NAME='YEARCHA1'
and RDB$SYSTEM_FLAG=0;
|
|
|
|
|
|
|
 |
|