Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!zaphod.mps.ohio-state.edu!van-bc!ubc-cs!kiwi!joplin!kho
From: kho@joplin.mpr.ca (Peter Kho)
Newsgroups: comp.databases
Subject: Ingres 4GL/FORMS (Help!!)
Message-ID: <2439@kiwi.mpr.ca>
Date: 17 Nov 90 01:53:33 GMT
Sender: news@eric.mpr.ca
Reply-To: kho@joplin.UUCP (Peter Kho)
Distribution: comp.databases
Organization: Microtel Pacific Research Ltd., Burnaby, B.C., Canada
Lines: 39


Hi there, database gurus:

I've a problem that someone out there might have solved or can point me
in the right direction to the solution.

H/W: HP-UX 7.0 on HP9000
S/W: Ingres 6.2

Problem:
Need to provide a user interface where the user can specify one or more
conditions to be apply to the SQL select statement.  That is the SQL
select will not be known until run-time.  This implies using dynamic SQL
to prepare and execute the SQL statement.  Another feature required is
that the user should able to search back and fro on the data set
retrieved by giving a pattern to match.  E.g. "%Smith%".

I've tried to implement the solution using Ingres 4GL but ran into
trouble as I cannot build the SQL dynamically.  I can get around this
problem by creative coding of the SQL statement.  Problem is this
approach is too slow!!!.

I've also tried to implement using Ingres ESQL/FORMS but ran into
trouble when I need to implement the search feature.  I cannot use the
LIKE predicate to do the search anymore either in procedures or
otherwise as, according to the manuals, the LIKE predicate syntax is as
follows:
	columnname LIKE 'string constant'

I'm stumped.  Can anyone help??  Please email me or post a reply.
Thanks.
---------------------------------------------------------------
Peter Kho
MPR Teltech Ltd
8999 Nelson Way
Burnaby, BC
CANADA V5A 4B5
Fax: 604.293.5787
Tel: 604.294.1471 Ext 5524