[RBG7-L] - RE: Variable question

[Kayza Kleinman]

Help! I seem to have hit reply rather than compose - thus the wildly off 
topic message.  Is there any way to delete this???

Kayza Kleinman wrote:
Chaya, I'm not finding the e-mail with the NASD information.  Could 
you re-forward it?
Thanks!

Bill Downall wrote:
Gunnar,
In order to create a string with a literal single quote in it, you 
need to open the quote, put the quote mark there, with another quote 
mark right in front of it so that it is "escaped" as a literal, and 
then close the quote.  So a string of a single quotation mark is 
created by using four of them in a row, as Mike did it.

Bill
Gunnar Ekblad wrote:
Mike Just out of curiosity I never managed the '''' I never 
understood how many ' there should be therefore I stayed at
( (char(39)) )where I had a chance understanding what I was doing. But
can you explain the rule I am happy to be converted!

Gunnar Ekblad
-----Original Message-----
From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of MikeB
Sent: den 26 april 2005 20:03
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: Variable question
First:
SET VAR vParm TEXT = (CTXT(04/25/2005))
yields vParm = 0.0000798004987 as a text value.. hardly what you were
after.
if you were after the current date you would do:
SET VAR vParm TEXT = (CTXT(.#DATE))
if you were entering the date as a string literal, you would:
SET VAR vParm TEXT = '04/25/2005'
Then to make your string for the USING:
-- Note: You will have to Escape the Quotes...
set var vusing = ('Using' & '''' + .vParm + '''')  -- the quotes are 
all
single

this yields:
Using '04/25/2005'

----- Original Message ----- From: "Jan Johansen" 
<[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <rbg7-l@rbase.com>
Sent: Tuesday, April 26, 2005 12:22 PM
Subject: [RBG7-L] - RE: Variable question


Gunnar,
Not yet.
I've seen this done in some code somewhere where you build your query
statement and then execute somehow.
I think it is an &variable but I'm still looking. Heck I think I've

done.
Just can't remember how.
Jan

----- Original Message -----
From: "Gunnar Ekblad" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <rbg7-l@rbase.com>
Sent: Tuesday, April 26, 2005 10:13 AM
Subject: [RBG7-L] - RE: Variable question
Jan
Only one question did it work?
Gunnar Ekblad
-----Original Message-----
From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Jan
Johansen
Sent: den 26 april 2005 19:09
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: Variable question
Thanks Gunnar,
I realized that I needed the single quote just after posting.
'Course then I've been looking for the code number since then
Jan
----- Original Message -----
From: "Gunnar Ekblad" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <rbg7-l@rbase.com>
Sent: Tuesday, April 26, 2005 9:58 AM
Subject: [RBG7-L] - RE: Variable question
Jan
I am not sure but I think maybee what you need  is to enclose vparm

with
� the code for that is I believe 39
So something like
set vparm = ( (char(39)) + (CTXT((04/25/205)) + (char39)) )
Might do the trick
Gunnar Ekblad
Kontema IT AB
H�stholmsv�gen 32
S-131 30 NACKA
070 545 50 38
[EMAIL PROTECTED]
-----Original Message-----
From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Jan
Johansen
Sent: den 26 april 2005 18:38
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: Variable question
OK, now what am I missing.
I'm trying to build a parameter to pass.
SET VAR vParm TEXT = (CTXT(04/25/2005))
SET VAR vUsing TEXT = ('Using ' + .vParm))
This doesn't work.
PROPERTY RBASE_FORM_ACTION MyAction .vUsing
Do I need an &var?
Jan