Thanks in advance!This message has been edited. Last edited by: CoolGuy,
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
June 30, 2015, 01:42 PM
eric.woerle
I'm not sure you can change the TYPE of &YEAR within dialogue manager. In my playing with it just now, I had to force quoutes around it. Why are you trying to force it to alpha anyways?
-SET &YEAR = '''&DATEYY.EVAL''';
-TYPE The data type of &YEAR is &YEAR.TYPE
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
2. Dialog Manager variables are typeless -- their content is always a character-string. The .TYPE operator simply indicates whether the string value "looks" like a number or not. -- By contrast, FOCUS (TABLE) variables are typed, and EDIT() can be used to convert between alpha and integer types.
June 30, 2015, 02:34 PM
CoolGuy
Thanks everyone!
Appreciate the help with understanding type conversion quirks in WF.
eric.woerle: I had to compare today's year part to a field that stores the year in an A4 format. I didn't design the table... Kind of annoying, but working around it.
Thanks again everyone!
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
June 30, 2015, 02:45 PM
eric.woerle
CoolGuy,
Sounds like your over complicating things then. Use the suffix .QUOTEDSTRING to wrap quotes around your year. It will automatically compare them as alpha's. No need for validating type. As Jack mentions, Variables don't actually have an associated data type.
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
June 30, 2015, 03:30 PM
CoolGuy
Good to know eric.woerle and j.gross! Thanks for the insights!
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.