Hi all,

I've been struggling quite a bit inserting numbers into an Oracle table using PP8.0 and the ODBC driver 6.0.

Basically, I'm computing the square root of some data and inserting both the data and its square root in a table.

I'm many occasions - not all - the number inserted is not the actual value's square root, but the value of the previous data record.

For instance, I have the following numbers: 20.2, 9.1, 18.4. Therefore, I should insert 20.2, 4,4944..., 9.1, 3.0166..., 18.4, 4.2895

Once inserted in the table, I read: 20.2, 4.4944..., 9.1, 9.1, 18.4, 18.4. It replicated the values instead of inserting the square root value.

I found that formating the value prior to insert it does work.

my_value := format("%9.5", my_value);

The table contains proper values: 20.2, 4,49444, 9.1, 3.01662, 18.4, 4.28952

I thought this might be of interest to the community.

Pierre