numeric value from dual field in Resident command

[Anonymous]

Hello,

in my script I create some tables with Dual fields. Later in the same script I read the tables with a Resident command and need only numeric values from Dual fields. Which syntax is correct?

For example

Load dualfield

Resident Table

The result is text value but it has to be a numeric value.

[jonathandienst · Accepted solution]

Hi

This will load the numeric value:

Load Num(dualfield) As numfield

Resident Table

Hope that helps

Jonathan

[Anonymous]

Thanks, it works finely.