Bill Hm! I almost understand! If I need one quote I need 4 quotes! 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 Bill Downall Sent: den 26 april 2005 20:21 To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Variable question 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 >> > > > >
