Hello Everyone...
Another question for today i'm afraid....
Say I wanted to query a text layer for a particular string, i've been
having problems setting this up to accept wildcards...
I want to do a basic search for a string, but to get it to
automatically search as a wildcard...
I know that in Mapinfo you can add a "%" to the Query --> Select tool
to search a text string as a wildcard, but i can't repeat this in
MapBasic.
I've tried adding % on at the end and tried the like command, but i
just can't seem to sort it... Would anyone be kind enough to have a look
at this and suggest how to modify it to search for wilcards also....
Thanks :-)
'--------------------------
SUB os_textsearch
DIM quicktextsearch AS STRING
DIALOG
TITLE "Quick Text Search (OS TEXT)"
CONTROL STATICTEXT
TITLE "Enter String to Search"
CONTROL EDITTEXT
INTO quicktextsearch
CONTROL OKBUTTON
CONTROL CANCELBUTTON
SELECT *
FROM TEXT
WHERE TEXT.NAME = quicktextsearch
INTO quicktextresult
BROWSE *
FROM quicktextresult
END SUB os_textsearch
'-----------------------------
Thanks
Jonathan
**********************************************************************
CONFIDENTIALITY
The information contained in this message and any attachments
are intended solely for the use of the individual or entity to whom
they are addressed. It may contain privileged or confidential
information. If you are not the intended recipient you must not
copy, distribute or take any action in reliance on it. If you have
received this e-mail in error please notify the sender. Thank You
This e-mail message has been swept by MIMEsweeper for the
presence of known computer viruses.
**********************************************************************
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9783
