Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Newcomers DBPro Corner / BODMAS question

Author
Message
Geoff
12
Years of Service
User Offline
Joined: 10th Jul 2007
Location: Sheffield (U.K.)
Posted: 27th Apr 2014 19:11
I am attaching my code of a math calculation which includes:-
brackets, *, -, /, and the function INT.
The code does what I want it to do.
But I would like to know what precedence of operators is used by DB to get to the end result.


I have spent many hours on this without success.
Help, please. Geoff.
WickedX
10
Years of Service
User Offline
Joined: 8th Feb 2009
Location: A Mile High
Posted: 27th Apr 2014 21:59
WickedX
10
Years of Service
User Offline
Joined: 8th Feb 2009
Location: A Mile High
Posted: 27th Apr 2014 23:41
Well it does appear division has the highest precedence.
Geoff
12
Years of Service
User Offline
Joined: 10th Jul 2007
Location: Sheffield (U.K.)
Posted: 28th Apr 2014 09:43
Thank you, folks.
I've got it now.
Geoff

Login to post a reply

Server time is: 2020-01-19 15:41:35
Your offset time is: 2020-01-19 15:41:35