Help! Forms45 Pre-query trigger problem(B

From: Koichi Nakano(B <koichi.nakano_at_citicorp.com>
Date: Thu, 23 Apr 1998 17:25:31 +0900
Message-ID: <6hmuae$48g$1_at_maple.cgin.us-md.citicorp.com>

[Quoted] [Quoted] Could someone help me to solve this problem?

The problem is coming when we enter some value staring with some space before query in the form. Oracle Form creates in incorrect select statement as follows;

In forms 4.5

---

In pre query the field has value '1301'
Oracle Forms creates the query condition as

     where (RECV_EXT_INSTM_SRC_ID=:3)
     and   (RECV_EXT_INSTM_ID LIKE:4)    /* correct */
     and   (OFFIC_CDE=:5)
     order by recv_instm_cde,fund_cde


=========================================================

In pre query field has value ' 1301' /* starting with space */ Oracle Forms creates the query condition as

     where (RECV_EXT_INSTM_SRC_ID=:3)
     and   (RECV_EXT_INSTM_ID    :4)    /* Incorrect ( 'LIKE' is missing) */
     and   (OFFIC_CDE=:5)
     order by recv_instm_cde,fund_cde


=========================================================

We are using Developer/2000 R1.3.2 for Alpha OpenVMS and Forms is V4.5.7.2.1.

Is there any way to solve this problem?
I'm wondering this is Forms45 bug...

Thanks and regards,
Koichi Nakano
koichi.nakano_at_citicorp.com Received on Thu Apr 23 1998 - 10:25:31 CEST