build 943

[Mediv]

Hi Farshad.

In the build is 927 for the installation

Query Component -> Fields Editor -> DisplayFormat = 0.00, a value of zero in the grid

displayed as 0.00, after upgrading to build 943 had to remove the formatting so that the value of 1153.23 was displayed, as 1.153,

but the value of zero is now displayed as 0, and wanted to be like 0.00

How can I do this?

Thank you.

[Farshad Mohajeri]

Can you provide following info:

 

DecimalSeparator

ThousandsSeparator

DisplayFormat

Your Field data

Value displayed in the grid.

[Mediv]

Can you provide following info:

 

DecimalSeparator

ThousandsSeparator

DisplayFormat

Your Field data

Value displayed in the grid.

 

Settings on the computer - 12 pic

DisplayFormat empty - 11,13 pic

DisplayFormat not empty - 14,15 pic

 

 

If pointing DisplayFormat, it is rounding the data.

[Farshad Mohajeri]

What is the field type?

[Mediv]

What is the field type?

 

Field type Float

[Farshad Mohajeri]

I can't reproduce.

 

Finally what is your Delphi version and browser type ?

[Mediv]

I can't reproduce.

 

Finally what is your Delphi version and browser type ?

Chrome 18.0.1025.142 beta-m, delphi 2007

[Farshad Mohajeri]

In my PC it behaves like this:

 

DecimalSeparator = ,

ThousandSeparator= .

DisplayFormat = Empty , Value diplayed as 1.23 (expected behavior)

DisplayFormat = 0.00 , Value diplayed as 1,23

FieldType = TFloatField

 

Can you send a simple test?

[Mediv]

In my PC it behaves like this:

 

DecimalSeparator = ,

ThousandSeparator= .

DisplayFormat = Empty , Value diplayed as 1.23 (expected behavior)

DisplayFormat = 0.00 , Value diplayed as 1,23

FieldType = TFloatField

 

Can you send a simple test?

I'll try to do it on your example DBLookup, but only tomorrow.

[Farshad Mohajeri]

Make sure you have the latest build 0.88.1.943 installed.

 

You can use GridEditors demo.

[Mediv]

Make sure you have the latest build 0.88.1.943 installed.

 

You can use GridEditors demo.

 

I took your demo DBLookup.

I put DisplayFormat = 0.00 for the field and was rounding TaxRate data, try, I can send your project If you are usin needed.

[Farshad Mohajeri]

Interesting. Here it works as expected!

[Farshad Mohajeri]

Can anyone else reproduce this problem?

[Mediv]

DBLookup demo with the property set DisplayFormat = 0.00 for the field TaxRate,

look, if you will show everything is normal, then the problem with the settings.

DBLookup.zip

[Mediv]

I changed the settings on my computer and everything was fine display.

[Farshad Mohajeri]

My PC's local setting is same as yours. I'll test with build 943 in another PC to see the results.

[Farshad Mohajeri]

I can't reproduce in any of my PCs.

 

Please re-check your uniGUI version.

[Mediv]

I can't reproduce in any of my PCs.

 

Please re-check your uniGUI version.

build 943.

 

Well, I decided to have a problem changing the settings on my computer, the main thing that works as expected.

Thanks for your help.

[dionel1969]

Hello !!!

 

I need to know something, and I need a help from you.

 

I have a field "MontoAPrestar" of type TBCDField (Money in the DB), and all the time in the user interface appears an error when user type numbers in the form's field using comma.

 

OS: Windows XP

Delphi: 2009

Browser: Chrome

UNIGUI: 941

 

Is there something I'm missing? This error comes from UNIGUI, from Delphi, from Browser???

 

Note: I saw this entry in the "what's new" of .943 build

 

- 0001270: UniDBGrid: Float/number field ignores decimal/thousand separators.

 

It concern to my problem too or not?

 

[Farshad Mohajeri]

This a Delphi error. While editing comma should not be used because uniGUI doesn't support EditFormat yet.

[Mediv]

This a Delphi error. While editing comma should not be used because uniGUI doesn't support EditFormat yet.

Thanks, I'll keep in mind. This error only in delphi 2007 or xe2 will also?

In the near future we plan to compile the project under delphi xe2.

[Farshad Mohajeri]

Thanks, I'll keep in mind. This error only in delphi 2007 or xe2 will also?

In the near future we plan to compile the project under delphi xe2.

 

You can use Comma in display format with no problem. When entering float data in cell we need to use DOT as decimal separator and no comma.

 

It is same for all Delphi versions.

[dionel1969]

This a Delphi error. While editing comma should not be used because uniGUI doesn't support EditFormat yet.

.

[Farshad Mohajeri]

This a Delphi error. While editing comma should not be used because uniGUI doesn't support EditFormat yet.

 

So??

[delphici]

Query Run Time Field DisplayFormat

 

Unit uses add

 

Data.DB,

 

 

procedure Form1.UniButton1Click(Sender: TObject);

begin

 

with Query1 do

 begin

   Close;

   SQL.Clear;

   SQl.Add('Select * from Table');

   open;

 end;

 

  TFloatField(Query1.FieldByName('FieldName')).DisplayFormat :='###,###';

 

   if not Query1.IsEmpty then

   begin

    UniDBGrid1.DataSource := DataSource1;

   end

   else

   begin

    UniDBGrid1.DataSource := nil;

   end;

  

 

end;