Using quotes in DEFAULT_WHERE in Forms45
From: Frank <frank.tollenaar_at_homemail.com>
Date: 1997/05/11
Message-ID: <337596D3.52E3BA4E_at_homemail.com>#1/1
Date: 1997/05/11
Message-ID: <337596D3.52E3BA4E_at_homemail.com>#1/1
Hi,
[Quoted] 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>> [Quoted] 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