Can somebody please explain what the differnece is between VariableValue.ValueText and VariableValue.ValueCache when writing .crp files for the report generator? Is ValueText the value retrieved from the latest version in the database while "ValueCache" is the value retrieved from whatever version you have in your local cache?
Thanks,
Sally
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.
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
Understood. Thanks to both of you!
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
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.