Forms 4.5 (32 bit) bug??

From: Greg Belliveau <gbellive_at_ab.bluecross.ca>
Date: 1997/06/27
Message-ID: <01bc8311$1dcb59c0$b1e64aa7_at_csys098>#1/1


[Quoted] 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 Fri Jun 27 1997 - 00:00:00 CEST

Original text of this message