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
16
Years of Service
User Offline
Joined: 10th Jul 2007
Location: Sheffield (U.K.)
Posted: 27th Apr 2014 19:11
Link
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.
Back to top
Profile PM
WickedX
15
Years of Service
User Offline
Joined: 8th Feb 2009
Location: A Mile High
Posted: 27th Apr 2014 21:59
Link
Back to top
Profile PM Email
WickedX
15
Years of Service
User Offline
Joined: 8th Feb 2009
Location: A Mile High
Posted: 27th Apr 2014 23:41
Link
Well it does appear division has the highest precedence.
Back to top
Profile PM Email
Geoff
16
Years of Service
User Offline
Joined: 10th Jul 2007
Location: Sheffield (U.K.)
Posted: 28th Apr 2014 09:43
Link
Thank you, folks.
I've got it now.
Geoff
Back to top
Profile PM
Back to top

Login to post a reply

Server time is: 2024-04-20 02:11:55
Your offset time is: 2024-04-20 02:11:55