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" <boelsen@[EMAIL PROTECTED]
> schrieb im Newsbeitrag
news:fllq5f$u50$1@[EMAIL PROTECTED]
> Hello,
>
> inside a Paradox 8 re****t 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
>
>
|
