Re: Looking up a field in an ISQL form... using partial string

Posted in 1995

Billy Wheeler — Wed, 25 Oct 1995 06:46:45 GMT — source: Informix-list mailing list archive (1991-1998)

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