Re: Forms 4.5 (32 bit) bug??
Date: 1997/06/29
Message-ID: <5p4sqt$bef_at_info.csufresno.edu>#1/1
In article <01bc8311$1dcb59c0$b1e64aa7_at_csys098>,
Greg Belliveau <gbellive_at_ab.bluecross.ca> wrote:
>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 ???
I have not seen this, but I have not used right-justified character columns with an enter_query. It does sound like a bug.
But you might try #='A' as your search string. The # sign can be thought of as the column name, as in
Section='A'
You can follow the # sign with any conditional phrase, other examples:
# IS NULL or # BETWEEN 'A' AND 'B'
Also try putting a colon in the column. When you press Execute Query, a query/where window will pop up and you can type in your entire where clause if you like.
Regards,
Steve Cosner
http://members.aol.com/stevec5088 Download QA, a dynamic data utility form-- Quick display and update access to any table. Received on Sun Jun 29 1997 - 00:00:00 CEST