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 >
