Hi Richard,

> Is there no way to set DQSD to preform normal arithmetic
> functions?

You can use the VBSX function as a wrapper to force VB-style mathematic
operations. Here's an example:
  vbsx =cdbl(2156737.51 - 16123.85)

You can add an alias for this to localaliases.txt as so:
  m|vbsx =cdbl(%s)|Safe math|Safe math|Finance

Since you're calling it directly, and the formula isn't being simply
interpreted from the command-line, it is easy to raise errors by
submitting invalid values ("m 1/0"). So, be careful with that kind of
thing. ;)

You can use other math operators this way, too, like power (^) and
modulo (mod) and whole value division (\ - eliminates the remainder).
  m 10 ^ 8
  m 17 mod 4
  m 9 \ 2

And more:
http://www.w3schools.com/vbscript/vbscript_ref_functions.asp#math

I'll bet with a bit of hacking in calculate.js, it would be possible to
change the default behaviour for mathematic formulae to this processing
method. Personally, I could care less. The JS method has almost always
served my needs, and when it hasn't, Google fills in nicely.

Regards,

Shawn K. Hall
http://12PointDesign.com/



-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
To unsubscribe visit:
https://lists.sourceforge.net/lists/listinfo/dqsd-users
DQSD-Users@lists.sourceforge.net
http://sourceforge.net/mailarchive/forum.php?forum_id=8601

Reply via email to