Re: Using quotes in DEFAULT_WHERE in Forms45

Frank (frank.tollenaar_at_homemail.com) wrote:
: 5>> New_Query := 'WHERE PRODUKT = ''A''';
: 6>> SET_BLOCK_PROPERTY (BLOK_ID, DEFAULT_WHERE, New_Query);
Well, I stuff it directly into the SET_BLOCK_PROPERTY, and there three quotes are handled correctly:

	SET_BLOCK_PROPERTY('MAIN_BLOCK', DEFAULT_WHERE,
		'id in (SELECT emp_id FROM employees WHERE id IN
		(SELECT account_id FROM accounts WHERE manager IN ' ||
		manager_string || ')
		AND account_mask LIKE ''' || tmp_mask || ''')');

The query here doesnt have to make sense right now, it's only to demonstrate that it works for me :-)

Hope it helps,
Walter Received on Sun May 11 1997 - 00:00:00 CEST