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
