Re: Calculating square root in ISQL
In article <1994Jul27.172927.348@pyra.co.uk> graeme@pyramid.com (Graeme Sargent) writes:
>Bonnie Weller (weller@zorro.cecer.army.mil) wrote:
>
>: Hello
>
>: I have SE 5.01 ISQL 4.11. I do NOT have 4GL (which I understand can
>: do square roots.)
>
>: I need to compute the following into an sql statement.
>
>: _____________________
>: \\ | 2 2
>: \\| (x1-x2) + (y1-y2) < r1+r2
>
>: I am not sure how to do the square root part of the equation as isql does
>: not have this capability.
>
>I find that surprising. Square root has been in the engine since <=5.00.
>
>select sqrt(whatever) ... works on my OnLine 5.00 engine, I would expect
>it to work with SE also.
>
>If you believe isql is the problem, why not use dbaccess?
If SE does have support for sqrt() (since I have not worked with SE for
a while, I don't remember), this type of statement should also work with
isql because the statement is passed untouched to the database engine
(which is, in this case, 5.01).
Giao