Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Whats wrong with statement

Status
Not open for further replies.
scouter

scouter

IS-IT--Management
Aug 29, 2002
1
US
(Sqrt(Sqr(Lidgegevens.Xcoordinaat-Losplaatsgegevens.Xcoordinaat)+
Sqr(Lidgegevens.Ycoordinaat-Losplaatsgegevens.Ycoordinaat))) As Afstand

This is the sql code i put in a Delphi ADOquery,
but it keeps giving a function error on the SQRT,
Plz help me :(
 
Sort by date Sort by votes
Maybe it is not the SQRT() function at all.
MS SQL Server has a math function POWER(expression, y) to raise an expression to the y-th power; and SQUARE(expression) to square the expression.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
193
mmiah1982
mmiah1982
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
247
carp
carp
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
143
mikrom
mikrom
manbob
  • Locked
  • Question
need a help with sub query getting group ereor, please correct
Replies
2
Views
195
carp
carp
jchewsmith
  • Locked
  • Question
Update Query with a MAX(Date) subquery 1
Replies
1
Views
239
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top