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>


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>...

>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
>
>
Received on Sat Jul 03 1999 - 19:14:45 CEST

Original text of this message