GISCafe
   >> Autodesk MapGuide Board
Thread views: 36978 View all threads**Threaded Mode

ebnesom
(Stranger )
06/07/06 06:14 AM
round decimal Report this article as Inappropriate to us !!!Login to Reply

I want to display an oracle sdo area field in the mapguide name, url, where tab - name column. However, I don't want all the decimals. Is there any way to use a function in the name column?
What I have tried is round ([area],0).
This didn't work.



balhelu
(Stranger )
10/11/06 08:00 AM
Re: round decimal new [re: ebnesom]Report this article as Inappropriate to us !!!Login to Reply

Hello
Try with TO_CHAR(Area ,'90').
hector



rlh7133
(Stranger )
11/03/06 06:49 AM
Re: round decimal new [re: balhelu]Report this article as Inappropriate to us !!!Login to Reply

Hi,

You might also try TRUNC(Area,2).

Ron



ebnesom
(Stranger )
11/20/06 06:41 AM
Re: round decimal new [re: rlh7133]Report this article as Inappropriate to us !!!Login to Reply

Thanks Ron,
The TRUNC did it!
Of course (???,2) leaves 2 decimals and 0 leaves none.
Brad




View all threads**Threaded Mode
Jump to

 

Trimble
CADalog.com - Countless CAD add-ons, plug-ins and more.



Internet Business Systems © 2016 Internet Business Systems, Inc.
595 Millich Dr., Suite 216, Campbell, CA 95008
+1 (408)-337-6870 — Contact Us, or visit our other sites:
AECCafe - Architectural Design and Engineering EDACafe - Electronic Design Automation TechJobsCafe - Technical Jobs and Resumes  MCADCafe - Mechanical Design and Engineering ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy Policy