I do believe it still works this way. I seem to have hit that
inadvertently very recently.
Albert
On 3/21/2014 1:15 PM, Karen Tellef wrote:
Razzak: If I remember correctly, in the past you could define a
permanent view
that references a variable and by putting the variable in parenthesis
the view would
be defined using the variable reference, rather than the variable's
actual value.
I haven't tried that lately, but is that still a valid reason for
using parenthesis?
Such as: CREATE VIEW viewname AS SELECT.... WHERE colname = (.vDate)
Otherwise if the vDate was not in parenthesis at the time you create
the view, and
the variable had a variable, the view would have: WHERE colname =
01/01/2014
Karen
