Re: Help! Tricky(?) query in Forms 3.0.

In article <9TcRsc1w165w_at_vicuna.ocunix.on.ca> frampton_at_vicuna.ocunix.on.ca writes: ..
>surnames. The surname is in a "pleasing format", ie. 'Frampton' or
>'McDonald' as opposed to 'FRAMPTON' or 'MCDONALD'. Hey, I didn't design
>the table! :-)
>

Use the PRE-QUERY Trigger:

	if substr(nvl (:BLOCK.SURNAME,':'),1,1) <> ':'
	then
	   :BLOCK.SURNAME := '#=SURNAME and upper(SURNAME) like ('''
		|| :BLOCK.SURNAME || ''')';
	end if;

and it should go.

Be sure, that the query-length of this field is big enough to hold the entire string!

The #-sign tells Forms not to modify the rest of the string.

Hope this helps

Gio

Johannes Leitner c/o "gio"
KEBA, Gewerbepark, A-4041 Linz, Austria, Europe VOICE: 0043-732-7090-930 FAX: 0043-732-730910 gio_at_keba.co.at ...!uunet!mcsun!hp4at!keba!gio Received on Wed Sep 21 1994 - 08:12:58 CEST