Re: Using quotes in DEFAULT_WHERE in Forms45

The problem is not where you think. Forms supports the 3 quotes without any problem.
I have tested the following code without problem : (in a PRE-SELECT trigger)
DECLARE
   New_Query VARCHAR2(2000);
BEGIN
    New_Query := 'PAYS LIKE ''A%''';
    SET_BLOCK_PROPERTY ('CINEMA_PAYS', DEFAULT_WHERE, New_Query); END; Are you sure that your column is a character column ? Is the blok_id variable of good type ?

You can also write anything like this :

DECLARE
   New_Query VARCHAR2(2000);
BEGIN     :global.produkt := 'A';
    New_Query := 'PRODUKT = :global.produkt';     SET_BLOCK_PROPERTY (BLOK_ID /* Must be initialized */, DEFAULT_WHERE, New_Query);
END; Frank <frank.tollenaar_at_homemail.com> wrote in article <337596D3.52E3BA4E_at_homemail.com>...
>
> Hi,
>
> I'm trying to build a form in which the DEFAULT_WHERE clause is to be
> filled
> by selecting values from a list.
> The problem I have is that Forms can't handle strings that end on 3
> quotes:
>
> 1>> DECLARE
> 2>> New_Query VARCHAR2(2000);
> 3>> BEGIN
> 4>>
> 5>> New_Query := 'WHERE PRODUKT = ''A''';
> 6>> SET_BLOCK_PROPERTY (BLOK_ID, DEFAULT_WHERE, New_Query);
> 7>> END;
>
> This returns a VALUE-ERROR in line 5.
>
> Does anybody have a suggestion ?
>
> Thanx in advance,
>
> Frank Tollenaar
>
>
Received on Thu May 15 1997 - 00:00:00 CEST