The code below shows an error, rounding the result:
Code: Select all
!!CB!! 174
If SqlOraPLSQLPrepare( hSql, '
begin
:n2 := 0.000000899;
end;' )
If SqlOraPLSQLExecute( hSql )
Call SalMessageBox( SalNumberToStrX( n2, 10 ), '', 0)
The same code with SqlPrepareAndExecute operate normally, the result is correct 0.000000899:
Code: Select all
!!CB!! 174
If SqlPrepareAndExecute( hSql, 'select 0.000000899 from dual into :n2 ' )
If SqlFetchNext( hSql, n1 )
Call SalMessageBox( SalNumberToStrX( n2, 10 ), '', 0 )
Thanks
Erasmo