Print Thread
rounding of floats
#1340 12/05/00 03:48 PM
Joined: Apr 2000
Posts: 37
Oyten,Germany
S
Sven Offline OP
Member
OP Offline
Member
S
Joined: Apr 2000
Posts: 37
Oyten,Germany
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


Greetings,
Sven
Re: rounding of floats
#1341 12/05/00 07:06 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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


Marco Kalter
Allround Automations
Re: rounding of floats
#1342 12/06/00 02:08 PM
Joined: Apr 2000
Posts: 37
Oyten,Germany
S
Sven Offline OP
Member
OP Offline
Member
S
Joined: Apr 2000
Posts: 37
Oyten,Germany
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


Greetings,
Sven
Re: rounding of floats
#1343 12/07/00 09:05 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
I hate to ask, but can you send me a little demo project that shows this behavior?


Marco Kalter
Allround Automations
Re: rounding of floats
#1344 12/07/00 09:19 PM
Joined: Apr 2000
Posts: 37
Oyten,Germany
S
Sven Offline OP
Member
OP Offline
Member
S
Joined: Apr 2000
Posts: 37
Oyten,Germany
Hmm, i will try, but i suppose i will have no luck.

Sven


Greetings,
Sven
Re: rounding of floats
#1345 12/14/00 02:28 PM
Joined: Apr 2000
Posts: 37
Oyten,Germany
S
Sven Offline OP
Member
OP Offline
Member
S
Joined: Apr 2000
Posts: 37
Oyten,Germany
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


Greetings,
Sven
Re: rounding of floats
#1346 12/14/00 06:31 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Scheisse [Linked Image]

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

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


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.032s Queries: 13 (0.007s) Memory: 2.5229 MB (Peak: 3.0431 MB) Data Comp: Off Server Time: 2024-05-19 21:16:49 UTC
Valid HTML 5 and Valid CSS