JWPURPZ1@ulkyvm.louisville.edu (Wakeley Purple) wrote:
>In article <kcjDGLF5A.1GG@netcom.com>
>kcj@netcom.com (Kate Juliff) writes:
>
>>user to be able to enter a partial string. e.g. if the user input "DAV"
>>then all rows where the value in the field began with "DAV" would be
>>retrieved. Is there any way to do this?
>>
>If you are doing a CONSTRUCT <where_clause> ON <form_variable> then
>the user should enter DAV* and the <where_clause> will contain
><form_variable> matches "DAV*". Then you PREPARE <query_string> using it.
>
Well, yes - if you're using Informix-4GL. Kate's using Informix-SQL.
FWIW, I cast a vote that Kate moves onto 4GL... any comments?
--
Cheers,
Billy
-----------------------------------------------------------------------------
INCLUDE "Disclaimer.4gh" -- my opinions are
INCLUDE "FlamesToDevNull.4gh" -- flamers, eat my shorts!
INCLUDE "CaveatEmptor.4gh" -- take my advice at your own risk
INCLUDE "ThirtySomething.4gh" -- header file for this class
-- Written by : Billy Wheeler, Date: today
-- Copyright (c) 1995, The West Solutions Group