Re: Forms 4.5: two problems.

From: RaviShankar <pc_at_TULBLR.UNISYS.COM>
Date: Fri, 29 Dec 1995 11:21:31 +0500
Message-Id: <9512291504.AA02608@alice.jcc.com>

>
> - the same two blocks are related each other by means of a field (the primary
> key in the master and the foreign key in the detail) having the same
> datatype (CHAR(8)). If i have a query which specifies a value of that field
> having less than 8 characters, Forms doesn't recognize the records matching
> that value.
>
> Thanks in advance,
> Rosita Bacchelli.
>
> ############################################################################
>

        The query does'nt throw up the matching records b'cos the CHAR fields in ORACLE 7.xx has blanks padded . ie . a value ABCDE in a char(8) field is treated as ABDCEbbb

        where b = a blank.

Change the datatype to varchar2(8) or use rtrim in the where clause..... Hope this helps

---

P.C. Ravi Shankar
TATA Unisys Ltd. Received on Fri Dec 29 1995 - 10:04:43 CST