How to use specific mathematic symbols in fields?

#1

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

#2

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 (AT) online (DOT) de> schrieb im Newsbeitrag
news:fllq5f$u50$1 (AT) online (DOT) de...

Quote:

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

#3

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 (AT) online (DOT) de> schrieb im Newsbeitrag
news:fllq5f$u50$1 (AT) online (DOT) de...

Quote:

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

#4

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 (AT) online (DOT) de> schrieb im Newsbeitrag
news:fllq5f$u50$1 (AT) online (DOT) de...

Quote:

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

#5

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 (AT) online (DOT) de> schrieb im Newsbeitrag
news:fllq5f$u50$1 (AT) online (DOT) de...

Quote:

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

#6

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 (AT) online (DOT) de> schrieb im Newsbeitrag
news:fllq5f$u50$1 (AT) online (DOT) de...

Quote:

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

#7

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 (AT) online (DOT) de> schrieb im Newsbeitrag
news:fllq5f$u50$1 (AT) online (DOT) de...

Quote:

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

#8

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 (AT) online (DOT) de> schrieb im Newsbeitrag
news:fllq5f$u50$1 (AT) online (DOT) de...

Quote:

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

#9

....
and I forgot:
string([STREETS.PQ1], 1, 1) by:
substr([STREETS.PQ1], 1, 1)

Egbert

--
_______________________________
Babst, Institutionsberatung,
BabstSoft e.K.
Ludwigstr. 86
64546 Mörfelden-Walldorf
Tel: 06105 74974
Handelsregister:
Amtsgericht Darmstadt HRA 53360
www.BabstSoft.com
_______________________________

#10

....
and I forgot:
string([STREETS.PQ1], 1, 1) by:
substr([STREETS.PQ1], 1, 1)

Egbert

--
_______________________________
Babst, Institutionsberatung,
BabstSoft e.K.
Ludwigstr. 86
64546 Mörfelden-Walldorf
Tel: 06105 74974
Handelsregister:
Amtsgericht Darmstadt HRA 53360
www.BabstSoft.com
_______________________________