Kayza Instead of delete them , just forget them 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 Kayza Kleinman Sent: den 26 april 2005 20:56 To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Variable question 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: [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 >>>> >>> >>> >>> >>> >> >> > >
