Untitled Document
   
 
 
     Á¦¸ñ : ¿¬Â÷

 
µî·ÏÀÏ 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;