KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

Formatting real values in Reply tab

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting
View previous topic :: View next topic  
Author Message
nvdvelden



Joined: 10 Mar 2004
Posts: 6

PostPosted: Tue Jul 13, 2004 1:06 am    Post subject: Formatting real values in Reply tab Reply with quote

Hi,

I am using calculations to determine wether a test is ok or not. The outputvalue is a real. How can i format this value. I now have a 14 digit output. I would like to decrease this to about 2.

Regards

Nico
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Tue Jul 13, 2004 11:57 am    Post subject: Reply with quote

14 digits???
What test method do you use? Version of HostMonitor?

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
nvdvelden



Joined: 10 Mar 2004
Posts: 6

PostPosted: Fri Jul 16, 2004 6:01 am    Post subject: Reply with quote

I use the result of a division made on the server and accessed by ACCESS
Back to top
View user's profile Send private message
nvdvelden



Joined: 10 Mar 2004
Posts: 6

PostPosted: Fri Jul 16, 2004 8:02 am    Post subject: Reply with quote

In addition to my previous answer: The version of HM is 4.42
Back to top
View user's profile Send private message
Marcus



Joined: 18 Nov 2002
Posts: 367

PostPosted: Fri Jul 16, 2004 9:02 am    Post subject: Reply with quote

Quote:
accessed by ACCESS

So why don't you let access round the number??
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Fri Jul 16, 2004 12:26 pm    Post subject: Reply with quote

Still don't get whole picture...

>What test method do you use?

Now I can assume you are using ODBC test method to get some field from some database. Am I right?

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
nvdvelden



Joined: 10 Mar 2004
Posts: 6

PostPosted: Mon Jul 19, 2004 12:51 am    Post subject: Reply with quote

Yes,

That's right.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Wed Jul 21, 2004 7:42 pm    Post subject: Reply with quote

I think you can modify your SQL query a little (use CAST function).
E.g. if you are using query like SELECT field1 FROM table1, change it to SELECT CAST(field1 AS MONEY) FROM table1

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
nvdvelden



Joined: 10 Mar 2004
Posts: 6

PostPosted: Thu Jul 22, 2004 2:10 am    Post subject: Reply with quote

I converted the output into integer. The accuracy is still enough.

Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index