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: [email protected] [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" <[email protected]>
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" <[email protected]> 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: [email protected] [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" <[email protected]> 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: [email protected] [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
