公开(公告)号：JPH11143883A

公开(公告)日：1999-05-28

申请号：JP28663797

申请日：1997-10-20

Applicant: IBM

Inventor： HAMADA SEIJI ,  ROGEY ROBERT ,  OGURA TAKASHI

IPC: G06F3/14 ,  G06F3/048 ,  G06F12/00 ,  G06F17/30

Abstract: PROBLEM TO BE SOLVED: To efficiently produce a retrieval sentence that combines plural tables by identifying and showing the propriety of linkage of a field of a source table which is selected with a mouse cursor and a field of a target table. SOLUTION: When a user selects data items 501 in a list box 500 of a source table and drags a mouse cursor 515 to a list box 510 of a target table, a field of the target table which can not be linked to a data type of a field of the selected source table is identified and shown against a field that can be linked. That is, in the case of a shown diagram, because the data type of the field (DEPTNO) of the source table (DEPARTMENT) is a Character type, data items (PICTURE, etc., of BLOB type) of a data type which does not have any meaning even when it is linked to the target table (EMPLOYEE) are shown in a gray state.