> SET VAR vExpression = '((' + .vDollarColName + '/.vSalesLessReturns)*100)'
>
> UPDATE ttblReportData +
> SET &vPctColName = &vExpression +
> WHERE &vDollarColName IS NOT NULL +
> AND &vPctColName IS NULL +
> AND StatementType <> 'BS'
>
> Does this work? It's very clever if it does!!
Yes, it works fine (as expected). It's the closest I can get to just
writing the command out the way I want it in the code -- and I guess it's
not too much more confusing than the actual command would be.
I would find it hard to live without R:Base's macro substitution feature.
--
Larry
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
