Jim, Since your Macro variable &FxTXHqColumn is enclosed within parentheses and is therefore part of an "expression", you have probably confused the parser into not substituting the macro variable soon enough.
Just for giggles, see what happens if you put a space between the parenthesis and the ampersand. I would also put CHAR(46) into parens, because that syntax could also stymie a parser. Or better yet, put it in a variable. SET VAR vDot = (CHAR(46)) UPDATE &FxTXHqTable SET + &FxTXHqColumn = (SRPL( &FxTXHqColumn, .vDot, NULL, 0)) + WHERE &FxTXHqColumn CONTAINS .vDot) If that doesn't help, let us know, and we'll escalate. Bill On Thu, Mar 27, 2014 at 4:29 PM, James Bentley <[email protected]>wrote: > I am trying to modify one of my stored procedure to be more generalized. > The following is a part of the code > SET VAR FxTXHqTable=(.FxTXHqTableName) > SET VAR FxTXHqColumn=(.FxTXHqColName) > -- Remove period, comma and double space > UPDATE &FxTXHqTable SET > &FxTXHqColumn=(SRPL(&FxTXHqColumn,CHAR(46),NULL,0)) WHERE &FxTXHqColumn > CONTAINS CHAR(46) > UPDATE &FxTXHqTable SET > &FxTXHqColumn=(SRPL(&FxTXHqColumn,CHAR(44),NULL,0)) WHERE &FxTXHqColumn > CONTAINS CHAR(44) > UPDATE &FxTXHqTable SET &FxTXHqColumn=(SRPL(&FxTXHqColumn,' ',CHAR(32),0)) > > The stored-procedure has two arguments FxTXHqTableName TEXT (18) AND > FxTXHqColName TEXT (18) > They represent a tablename and a column name. > The error message given is that left parenthesis can not be followed by > '&' > this part of the syntax "(SRPL(&FxTXHqColumn" seems to be the problem > it works if I substitute the actual table name for example > "MbrCurHMainAdrLine" which > is the value I am passing to the stored procedure. note the other parts of > the abatement with the "&" worked fine. > > The are some 50 lines of UPDATE commands in the procedure. > Does any one have any suggestions as to how I can fix this problem. > > setting up the complete line and into a variable the esecuting the > variable seems > to defeat the purpose of generalizing the stored procedure. > > Jim Bentley, > American Celiac Society > 1-504-737-3293 > > >
