Re: How to have a char type key for MASTER-DETAIL form using 4.5
Date: 1997/09/22
Message-ID: <01bcc729$e4381b00$8c8765c1_at_dpoweleit.horn-goerwitz.de>#1/1
Use VARCHAR2-Type then it works. In Varchar2-Fields the last not used space will be truncated. When you use CHAR-Type the contents of the field is used in whole field-length. The MASTER-DETAIL relation searches for excact matches. Perhaps your corresponding fields in the master- and the detail record are not excactly equal.
Chengsheng Yao <csyao_at_ee.rutgers.edu> schrieb im Beitrag
<604707$jpu_at_ee.rutgers.edu>...
> Hi,
> I am tring form 4.5 in dev200. when I generate master-detail
> form, if I have char type foreign key(primary) key, then the form
> can not run correctly. It looks like detail block did not get right
> keys to retrive. but if I use ingeter as key then it's fine.
>
> Anybody there can give me a ideal how to fix or go around this ?
> ( I have to have char type in the keys of the relations)
>
> Thank you in advance.
>
> Charlie
> .
>
>
Received on Mon Sep 22 1997 - 00:00:00 CEST