Using quotes in DEFAULT_WHERE in Forms45

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 Sun May 11 1997 - 00:00:00 CEST