Re: Forms 4.5 (32 bit) bug??

I've had the same problem, I was developing a new front end for an existing database.
The primary and foreign key of the offending table where VARCHAR2(10), the data
was a right justified number padded with zeros to nine characters, leaving a
mysterious tenth character. I updated the keys and padding them with zeros to the
full ten characters and the problem went away. I assumed there was some sort of
control character in the field, though I did not investigate this theory.

Regards,
Andrew.
amk_at_ozemail.com.au

Greg Belliveau <gbellive_at_ab.bluecross.ca> wrote in article <01bc8311$1dcb59c0$b1e64aa7_at_csys098>...
> We are currently upgrading to Designer/Developer 1.3.2 (32 bit) and came
> across a weird situation.
>
> In Forms, when trying to query with a right justified VARCHAR column, we
> get an error. The error says that we are using an invalid relational
> operator. What's happening is that the '=' sign is not there for that
> column in the WHERE clause.
>
> ie: 2 columns - Group varchar2(10), Section varchar2(3) right justified
>
> Enter criteria: group: 'ERC023' , section: ' A' , we get the error
> because of the spaces in section
> Enter criteria: group: 'ERC023' , section: '%A' , works fine
>
> It seems that the spaces in Section overwrite the '=' sign, I know it
 seems
> bizarre but that's what's happening.
>
> Has anybody else come across this ?????
> If so, is there a solution ???
>
> Thanks in advance,
> Greg
> gbellive_at_ab.bluecross.ca
>
Received on Wed Jul 02 1997 - 00:00:00 CEST