-
Re: Report Generator - VariableValue.ValueText vs. VariableValue.ValueCache
For text values there is no difference. For others, like dates, it is the variable value converted to text. This way regerdless the variable type, you can still retrive the value with ValueCache.
-
Re: Report Generator - VariableValue.ValueText vs. VariableValue.ValueCache
Hi Sally,
It definitely makes it easier to fetch values from a single column and also if u notice the Datatype For ValueText its nVARCHAR(MAX) and For Cache its nVARCHAR(60) so its will have positive impact on Performance as well.
Regards
Ravi T
-
Re: Report Generator - VariableValue.ValueText vs. VariableValue.ValueCache
Understood. Thanks to both of you!
-
Re: Report Generator - VariableValue.ValueText vs. VariableValue.ValueCache
Actually - there is a difference. As Ravi stated, ValueCache only stores a maximum of 64 characters vs. max for ValueText.
Depending of what version of EPDM you are using, you might find ValueText declared as ntext.
In any event, if the number of characters in ValueCache exceeds the limit, the next column IsLongText will be set to 1.
Regards,
Joy
-