Calculation of Square Roots in Paradox

[TokyoRick]

Is is possible to write PAL code for calculate square roots of derived variables. I can do simple arithmetic calculations but would like to take the sum of the records for a specific field and then determine the square root of that sum.

 

[Guest_imported]

You don't say what version. Something like :
var
sqResult number
tc tcursor
endvar

if not tc.open ("ORDER.DB&quot then
errorShow()
return
endif

sqResult = sqrt(tc.cSum("Total Invoice&quot)

tc.close()