rounding of floats

[Sven]

Hi,

i have a very stupid behaviour of a TDataSet and a TOracleDataSet.

The following statement

select 3.1415926 from dual

creates
3 as a result. All my other DataSet and query are running normal. Only if i add new queries i get this.??????

The PLSQL-Developer creates the right output.

I have no more idea where i can turn something.

Any ideas?

Greetings
Sven

 

[Marco Kalter]

I tried this, and it seems like a result set formatting bug in the SQL Property Editor. If I link this dataset to a DBGrid I get the correct result, so your application should work just fine. Could you check if this is the problem in your situation as well?

We will fix the SQL Property Editor bug for the next patch release.

------------------
Marco Kalter
Allround Automations

 

[Sven]

Marco,

no,

i linked it to a twwdbgrid. Result is rounded. No idea why....

This makes absolutly no sense, because older DataSets works correctly, only new one.

??????

Greetings
Sven

 

[Marco Kalter]

I hate to ask, but can you send me a little demo project that shows this behavior?

 

[Sven]

Hmm, i will try, but i suppose i will have no luck.

Sven

 

[Sven]

Arggh,

my fault. I entered a wrong DisplayFormat

it should be 0.00 not 0,00 (like in germany, but not in delphi)

Thx
Sven

 

[Marco Kalter]

Scheisse

Still, I found a totally unrelated property editor bug in the process.

------------------
Marco Kalter
Allround Automations