How to use specific mathematic symbols in fields?

Hello,

inside a Paradox 8 report I've created new calculated field, which shall
contain following formula:

0.8575 * sqrt((ansicode(string([STREETS.PQ1], 1, 1)) - ansicode("T"))^2) +
(value(string([STREETS.PQ1], 2, 2)) - value("06")) ^2 )

The story behind is: there exists a table (STREETS) with field "PQ1" (e.g.
for entries: T06, R10, ...). The field (type "A") has a length of 3
characters. Now I want to convert the text string into 2 values (see formula
above).

But Paradox doesn't accept the symbol ^ and neither "value". What can I use
instead?

Thanks in advance.

Frank

Frank,
In your formula:
0.8575 * sqrt((ansicode(string([STREETS.PQ1], 1, 1)) - ansicode("T"))^2) +
(value(string([STREETS.PQ1], 2, 2)) - value("06")) ^2 )

I would substitute ^2 by pow(2). "^" doesn't exist in OPAL IIRC.
And substitute "value" by the desired cast like smallInt, longInt, or
number, e.g. number (.....)
Haven't tried it, but guess this might be the cause.

Egbert
--
_______________________________
Babst, Institutionsberatung,
BabstSoft e.K.
Ludwigstr. 86
64546 Mörfelden-Walldorf
Tel: 06105 74974
Handelsregister:
Amtsgericht Darmstadt HRA 53360
www.BabstSoft.com
_______________________________
"Frank Boelsen" schrieb im Newsbeitrag

> Hello,
>
> inside a Paradox 8 report I've created new calculated field, which shall
> contain following formula:
>
> 0.8575 * sqrt((ansicode(string([STREETS.PQ1], 1, 1)) - ansicode("T"))^2) +
> (value(string([STREETS.PQ1], 2, 2)) - value("06")) ^2 )
>
> The story behind is: there exists a table (STREETS) with field "PQ1" (e.g.
> for entries: T06, R10, ...). The field (type "A") has a length of 3
> characters. Now I want to convert the text string into 2 values (see
> formula above).
>
> But Paradox doesn't accept the symbol ^ and neither "value". What can I
> use instead?
>
> Thanks in advance.
>
> Frank
>
>