Re: Using sql statement in FORMS 5
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Sat, 03 Jul 1999 17:14:45 GMT
Message-ID: <9yrf3.60868$eF3.14233_at_news.rdc1.nj.home.com>
Date: Sat, 03 Jul 1999 17:14:45 GMT
Message-ID: <9yrf3.60868$eF3.14233_at_news.rdc1.nj.home.com>
Try
sql_stat := 'SELECT lastname'||', '||lastname' full_name
||' FROM people ' ||' WHERE LASTNAME LIKE ''' ||:GLOBAL.NAME||'%''';
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 wozi wrote in message <30E510CDA7A25AC5.6AAA46DF726B4DDD.6B599ECD3AF63F3F_at_lp.airnews.net>...Received on Sat Jul 03 1999 - 19:14:45 CEST
>I am using forms5 and I am trying to construct a sql statement to be used
by
>CREATE_GROUP_FROM_QUERY.
>Example:
> group_id := create _group_from_query('List_Elements', sql_stat)
>
>this sql statement does not work. The problem for me is how to get
>'like Mary%' into a quote of its own.
>sql_stat := 'SELECT lastname'||', '||lastname'
> ||'FROM people '
> ||'WHERE LASTNAME LIKE '
> ||':GLOBAL.NAME%';
>
>thanks for your help
>
>