|
Home > Archive > Programming with dBASE > December 2006 > Applylocate for value with '
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Applylocate for value with '
|
|
| Jan Hoelterling 2006-12-06, 7:13 pm |
| Hi folks,
how can I use applylocate to find a value that contains ' ?
I need to find "Nature's Way" -> this results in ApplyLocate ("Name =
'Nature's Way'") which of course fails. I've tried to replace the single
quotes with double quotes, but then I get "variable not found Nature's Way
(huh???).
This must be something easy...
Jan
| |
| Ken Mayer [dBVIPS] 2006-12-06, 7:13 pm |
| Jan Hoelterling wrote:
> Hi folks,
>
> how can I use applylocate to find a value that contains ' ?
>
> I need to find "Nature's Way" -> this results in ApplyLocate ("Name =
> 'Nature's Way'") which of course fails. I've tried to replace the single
> quotes with double quotes, but then I get "variable not found Nature's Way
> (huh???).
>
> This must be something easy...
applylocate( "Name=[Nature's Way]" )
Always remember there are three sets of delimiters ... <g>
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Jan Hoelterling 2006-12-06, 7:13 pm |
|
"Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote in message
news:yizgi8XGHHA.1140@news-server...
> Always remember there are three sets of delimiters ... <g>
I had thought of that, but because it's an SQL expression, I did not think
using [ ] was valid. You're right, though, it works just fine. Thanks for
your help.
Jan
| |
| Ken Mayer [dBVIPS] 2006-12-07, 7:12 pm |
| Jan Hoelterling wrote:
> "Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote in message
> news:yizgi8XGHHA.1140@news-server...
>
>
>
> I had thought of that, but because it's an SQL expression, I did not think
> using [ ] was valid. You're right, though, it works just fine. Thanks for
> your help.
Sure -- I've been using that a lot with one project ...
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
|
|
|