정상적으로 사용중이던 db의 table이 drop시킨 후 다시 create를 하였더니
실행파일에서 다음과 같은 메세지를 뿌리며 error을 발생했습니다.
error message
project isgy.exe raised exception class EBDEngineerror with message
'Invalid field type Field : Field20' process stop......
bde 엔진에서 알지 못한다고 하는 메세지 같은데
지금까지 잘 사용하던 그리고 필드하나 바꾼것도 없는데 에러가 나요..
도와주세요...
테이블 파일 같이 보내요...
/* ============================================================ */
/* Table: ISISCDMP */
/* ============================================================ */
drop table ISISCDMP
go
create table ISISCDMP
(
BICD char(2) not null,
SWCD char(7) not null,
BUCD char(4) not null,
JIKWECD char(3) not null,
JOCD char(1) not null,
GMBI char(2) null,
JUBS char(4) null,
ISIL datetime null,
JIPSAKB char(1) null,
JJKB char(1) null,
JJGB char(1) null,
WGCD char(2) not null,
NAME char(18) null,
JUMIN char(14) null,
SYWI char(10) null,
YEKB char(1) null,
SEX char(1) null,
NAI smallint null,
HJIL datetime null,
BJIL datetime null,
TJIL datetime null,
GYKB char(1) null,
KBK integer null,
SGOISD integer null,
SILKBK integer null,
SYUL integer null,
SYDK smallint null,
KMYKDK char(2) not null,
ULBHDK char(5) not null,
ULBHBH char(8) null,
GSSD integer null,
JMSD integer null,
HJINRYUK char(1) null,
SSTUIP char(1) null,
BEUJA smallint null,
BUNEJASDJ smallint null,
BY_BUMO smallint null,
BY_BRO smallint null,
GYUNGRO smallint null,
JANGE smallint null,
Y_JNSU smallint null,
GTMIJY smallint null,
JEHYONG integer null,
GTJUCUK integer null,
ULCHAAK integer null,
BANK char(1) null,
GEJWA char(20) null,
YGJ char(20) null,
SYBANKCD char(1) null,
SYGEJA char(20) null,
SYYGJ char(20) null,
WEDIL char(10) null,
DEJI integer null,
DONGSAN integer null,
BUDONG integer null,
GUNPY integer null,
BANGSU integer null,
JUKB char(1) null,
HOJU char(14) null,
SEDEJU char(14) null,
BONJUK char(80) null,
UPNO1 char(7) null,
JUSO char(80) null,
UPNO2 char(7) null,
HJUSO char(80) null,
TELA char(14) null,
TELB char(14) null,
GUNBAL char(10) null,
GUNBUN char(15) null,
JUTUKGI char(4) null,
GEGUP char(4) null,
IPIL datetime null,
JUNIL datetime null,
MENJE char(20) null,
KEA char(3) null,
MUGEY char(3) null,
HELAK char(2) null,
SEE_J decimal(3,1) null,
SEE_U decimal(3,1) null,
SINANG char(14) null,
CHWIMI char(14) null,
TUKGI char(14) null,
SUSANG char(20) null,
SAJIN image null,
JUJSB char(7) null,
JUILSI char(14) null,
constraint PK_ISISCDMP primary key (BICD, SWCD)
)
go
/* ============================================================ */
/* Index: ISISCDMP_FK_ISKMYKCD_FK */
/* ============================================================ */
create index ISISCDMP_FK_ISKMYKCD_FK on ISISCDMP (KMYKDK)
go
/* ============================================================ */
/* Index: ISISCDMP_FK_ISULBHCD_FK */
/* ============================================================ */
create index ISISCDMP_FK_ISULBHCD_FK on ISISCDMP (ULBHDK)
go
/* ============================================================ */
/* Index: ISISCDMP_FK_HMBUBICD_FK */
/* ============================================================ */
create index ISISCDMP_FK_HMBUBICD_FK on ISISCDMP (BICD)
go
/* ============================================================ */
/* Index: ISISCDMP_FK_HMBUSECD_FK */
/* ============================================================ */
create index ISISCDMP_FK_HMBUSECD_FK on ISISCDMP (BUCD)
go
/* ============================================================ */
/* Index: ISISCDMP_FK_HMJIKWCD_FK */
/* ============================================================ */
create index ISISCDMP_FK_HMJIKWCD_FK on ISISCDMP (JIKWECD)
go
/* ============================================================ */
/* Index: ISKNMUCD_FK_ISISCDMP_FK */
/* ============================================================ */
create index ISKNMUCD_FK_ISISCDMP_FK on ISISCDMP (JOCD)
go
/* ============================================================ */
/* Index: HMJJWGCD_FK_ISISCDMP_FK */
/* ============================================================ */
create index HMJJWGCD_FK_ISISCDMP_FK on ISISCDMP (WGCD)
go
제가 보기에는요. 테이블에 문제가 생긴게 아니라
이전 테이블과 새로만든 사이에 차이가 있어서
DBComponent에서 인식을 하지 못하는 것 같습니다.
천천히 다시 한번 살펴 보면 금방 답이 나올 문제
갔습니다.
그럼 수고하셔요....