Hi,
can anyone tell me how to find out the variable type in VBA?
i need to know whether it is a number or string that is being returned by the dataprovider (column type)
What are you using for a dataprovider?. Using a universe will simply be a question of checking up the datatype in the properties of an object. In other cases look at the table definition in the database directly (or ask a DBA to do that for you). At report level you can distill the datatype from applying a couple of functions like TO_CHAR, FORMAT_NUMBER etc and watch what happens..... T. Blom
Information analyst
tbl@shimano-eu.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.