Using sql statement in FORMS 5

From: wozi <wozi_at_dhc.net>
Date: Sat, 3 Jul 1999 10:16:16 -0700
Message-ID: <30E510CDA7A25AC5.6AAA46DF726B4DDD.6B599ECD3AF63F3F_at_lp.airnews.net>

[Quoted] [Quoted] I am using forms5 and I am trying to construct a sql statement to be used by CREATE_GROUP_FROM_QUERY.
Example:
[Quoted]  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:16:16 CEST