HELP: CASE INSENSITIVE problem with Forms 4.5.6.3.3
From: <llevesqu_at_teleglobe.ca>
Date: 1996/05/14
Message-ID: <4na9tt$ipm_at_wagner.spc.videotron.ca>#1/1
Date: 1996/05/14
Message-ID: <4na9tt$ipm_at_wagner.spc.videotron.ca>#1/1
Hi there,
I'm facing a problem wirth a block based field when I try to test the case insensitive behavior in a Query. Even though the Case Insensitive Propertie of this item is set to TRUE, no records are retrieved at runtime when I deal with cases.
So, I tried to solve the bug by the side with a PRE-QUERY trigger by the following statements:
If instr(:BLOCK.field, '%') > 0 or Instr(:BLOCK.field, '_') > 0 Then
where_claus := ' UPPER(field) LIKE UPPER(:BLOCK.field) ';
Set_block_property('BLOCK', DEFAULT_WHERE, where_claus);
End if;
...and it don't even work this way.
Do you have a hint ?
Thanks in advance.
llevesqu_at_teleglobe.ca Received on Tue May 14 1996 - 00:00:00 CEST