Hi!
I need to combine 2 numbers from 2 different objects with a “/” in between to represent a month/year value.
I can easily do this in BO User Reporting mode using + “/” + . Is there some way to define an object by combining objects with character strings in Designer?
Thanks for your help.
-Beverly
Listserv Archives (BOB member since 2002-06-25)
If you’re on Oracle, try the double pipes ("||") instead of “+” in Designer.
George Baranowski
QuadraMed
Listserv Archives (BOB member since 2002-06-25)
In a message dated 00-03-23 13:49:05 EST, you write:
I can easily do this in BO User Reporting mode using + “/” +
. Is there some way to define an object by combining objects with character strings in Designer?
Most certainly there will be, but it depends on your database. For example, Oracle uses the “double bar” to concatenate, while other databases use the plus sign. So,
tab.col1 || tab.col2 works for Oracle
tab.col1 + tab.col2 works for many other databases like Sybase
You can, of course, add in the quotes and slash as well.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)