Re: search function

Article View: alt.comp.databases.xbase.clipper

Article #20

Back to alt.comp.databases.xbase.clipper Previous Next

#20

From: Peter Strong
Date: Sun, 03 Oct 1999 00:00

24 lines
2419 bytes

I got a solution.
I used the wildcard, but the tricky part was to make it read in the
value from the form.
This is what ive got:

SELECT * FROM <Tables>
WHERE SEARCHWORD Like "*"&([Forms]![formname]![textkeyword])&"*"))

thanks everyone for their help

Adrian Boldan wrote:

> LeemingIT (ITManager@LeemingIT.demon.co.uk) wrote:
> : Standard wildcards, I beleive, so it would be
>
> :     select * where my_column like "*<text>*"
>
> Isn't the standard character the % (percent)? Like in:
> ... like "%adrian%"
>
> --
>          *** Learn Esperanto - the International Language! ***
> One language for all           |      Unu por chiuj,
> the second for everyone!       |     la dua por chiu!

Technical Details

Message-ID: <37F6D159.BFF4CB90@student.uq.edu.au>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<7so02k$nau$1@bunyip.cc.uq.edu.au> <37EF8D80.2FC8B2EC@prodigy.net> <37F00D1E.6127A629@student.uq.edu.au> <37F0260D.307A45AA@student.uq.edu.au> <37F0E2F2.D4D03BCF@prodigy.net> <938536621.14505.0.nnrp-03.c1ed7c49@news.demon.co.uk> <FIvzB5.737.0.bloor@torfree.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f469f,1aaba471388bd669
X-Google-Attributes: gidf469f,public
X-Google-Thread: 10b2b7,1aaba471388bd669
X-Google-Attributes: gid10b2b7,public
X-Google-Thread: ff0ac,1aaba471388bd669
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f6611,1aaba471388bd669
X-Google-Attributes: gidf6611,public
X-Google-Thread: fc5c9,1aaba471388bd669
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: 106b3c,1aaba471388bd669
X-Google-Attributes: gid106b3c,public
X-Google-Thread: 104de1,1aaba471388bd669
X-Google-Attributes: gid104de1,public
X-Google-Thread: ff4b7,1aaba471388bd669
X-Google-Attributes: gidff4b7,public
From: Peter Strong <s350455@student.uq.edu.au>
Subject: Re: search function
Date: 1999/10/03
Message-ID: <37F6D159.BFF4CB90@student.uq.edu.au>
X-Deja-AN: 532193867
Cache-Post-Path: miso.it.uq.edu.au!news@violin.it.uq.edu.au
Content-Transfer-Encoding: 7bit
References: <7so02k$nau$1@bunyip.cc.uq.edu.au> <37EF8D80.2FC8B2EC@prodigy.net> <37F00D1E.6127A629@student.uq.edu.au> <37F0260D.307A45AA@student.uq.edu.au> <37F0E2F2.D4D03BCF@prodigy.net> <938536621.14505.0.nnrp-03.c1ed7c49@news.demon.co.uk> <FIvzB5.737.0.bloor@torfree.net>
Content-Type: text/plain; charset=us-ascii
Organization: Department of Computer Science and Electrical Engineering, The University of Queensland
X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/)
Mime-Version: 1.0
Newsgroups: alt.comp.databases.xbase.clipper,bit.databases.mssql-l,comp.databases,comp.databases.adabas,comp.databases.btrieve,comp.databases.filemaker,comp.databases.ms-access,comp.databases.ms-sqlserver,comp.lang.basic.visual.database,microsoft.public.vb.d

Reply to Parent Message