Calculation in Query Builder?

Questions and answers regarding general SQL and backend databases

Calculation in Query Builder?

Postby joe26 » Tue Mar 13, 2018 1:54 am

I have yet to figure out how to reference a calculation in Query Builder.

I'd like to add a calculation that changes decimal feet to a readable string 123' 6-5/8".

The calc I have. Just no success in showing it through query builder, or must this be done
when a view is built?

Thanks!
--Joe.
joe26
 
Posts: 73
Joined: Wed Jun 19, 2013 10:30 pm

Re: Calculation in Query Builder?

Postby rgansevles » Fri Mar 23, 2018 11:54 am

Joe,

The QueryBuilder does not have support for calculations, these are calculated in the context of a record/foundset, the query builder only works at database level.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1861
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Calculation in Query Builder?

Postby joe26 » Tue Mar 27, 2018 12:11 am

Thanks!
joe26
 
Posts: 73
Joined: Wed Jun 19, 2013 10:30 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 6 guests

cron