dbTalk Databases Forums  

Determining data type of cell in cellset

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Determining data type of cell in cellset in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Terry Smith
 
Posts: n/a

Default Determining data type of cell in cellset - 07-26-2006 , 03:24 PM






I need to determine the data type of individual cells, specifically if they
are currencies or percentages. The Cell.Value property contains a Double and
the Cell.FormattedValue may have a currency formatted string if it's defined
correctly in AS; however, due to internationalization issues I obviously
should not be looking at the FormattedValue property to determine the cell's
data type.

This seems like it would be easy, but so far I can not see how to do this
using the available metadata brought back from a cellset.

Any suggestions?

Thanks,
Terry

______________________
Terry Smith
Senior Architect
Insight Ecosystems
http://www.insightecosystems.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.