Jim,
I did this for different type lookups, not all require the srpl. By keeping
part1 & part2 separate, it makes it easier for me to change situations.
But U R right, it could be done in less steps.
Bernie Lis
----- Original Message -----
From: "James Bentley" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Sunday, August 21, 2005 1:07 PM
Subject: [RBG7-L] - Re: Launch command question
Bernie,
curious why not just use:
set var cmnd = (.part1 + '"' + (SRPL(.cnm,' ','+',0))
+ '"''')
instead of three statements.
Jim Bentley
American Celiac Society
--- Bernard Lis <[EMAIL PROTECTED]> wrote:
As per Mike's comment about spaces between names, I
have updated my google
macro (using srpl) as follows:
Label start
set var vresp text=' '
set var part1 = 'LAUNCH
''http://www.google.com/search?q='
dialog 'Enter Customer No.' vresp=6 vkey 1 +
option message_font_size 12 |message_font_color
maroon |message_font_name
arial bold
if vkey = '[Esc]' then ; goto aldun ; endif
sel custname into cnm from customer where custno =
.vresp
if sqlcode <> 0 then
pause 2 using 'Customer Not Found' icon serious +
option message_font_size 12 |message_font_color
maroon
|message_font_name arial bold
goto start
endif
SET VAR vsrpl = (SRPL(.cnm,' ','+',0))
set var part2 = ('"' + .vsrpl + '"' + '''')
set var cmnd = (.part1 + .part2)
&cmnd
Label aldun
clear all var
return
----- Original Message -----
From: "Esbjörn Johansson" <[EMAIL PROTECTED]>
>
> MikeB wrote:
>
>>The string you pass to the launch command for
Google search. If the
>>string has spaces in it (such as customer Name
like "James Smythe"), In my
>>testing, if an _Exact_ match was required
(enclosing the search string in
>>double quotes) required the replacement of the
space between "James" and
>>"Smythe" with the %20 (URL hex encoding for space
char), so my launch
>>command might look like:
>>
>>Launch
'http://www.google.com/search?as_q="James%20Smythe";'
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
