[solve] help oobase, number become zero after dot in DECIMAL

[john1123]

i have set the field type to decimal[DECIMAL]
but when i key in the data it still showing zero
example: 10.5 --> 10
can help me to solve this problem????

[Sliderule]

If you are defining the field type to DECIMAL, you can also set a value ( number ) for the maximum number of decimal places you want defined for the field, you must also define that.

If you want the stored data in the table to have an accurracy up to 15 decimal places, whether. for example. 0 or 5 or 8 or 11 or 13. define the field type as Number [ Numeric ] rather than a Decimal.

I hope this helps, please be sure to let me know.

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.

[john1123]

i have try to use number [NUMERIC] also
but i still get the same problem that after i type 10.5 and done the data key in it will goes to zero after the dot (10)

ps: i using open office 3.4, win xp

[Sliderule]

[john1123]

at tables, queries and forms also try

i really have not ideal wht to do

[Sliderule]

[john1123]

sorry my English is not good


ok, now my problem is my data need to key in as number and it only have 2 digit of decimal,
but every time i key in the data, it only show the number, and the decimal will become zero
like this example: 10.50, it will go to 10 only
even though i use number[NUMERIC], it will become 10.00
i cant get the 0.50 amount

i have try to set the language as English USA at tools->option->language

and i have also try this SQL that i read at this forum
code:
-- Add the NEW field before the old field to the table as a decimal with 2 decimal places default to zero
ALTER TABLE "FactDiaria" ADD COLUMN "CajaEmpUSD_02" DECIMAL(15,2) DEFAULT 0.00 NOT NULL BEFORE "CajaEmpUSD"

-- Populate the New field with the data from the old, and, 0 if NULL in the old
UPDATE "FactDiaria" SET "CajaEmpUSD_02 = COALESCE("CajaEmpUSD",0)

-- Remove the OLD field
ALTER TABLE "FactDiaria" DROP COLUMN "CajaUSD"

-- Change the name of the NEW field to the name of the OLD field ( just removed )
ALTER TABLE "FactDiaria" ALTER COLUMN "CajaUSD_02" RENAME TO "CajaUSD"


but at the end i still cant get my decimal digit

[Sliderule]

Follow these steps:

1. Open your OpenOffice Base File ( *.odb )
   
2. Click on the Tables icon on the left
   
3. Right click on table: "FactDiaria" Open
   
4. At the top of column "CajaUSD" right click and choose: Column Format...
   
5. On the Format Tab, at Options, Decimal Place, select 2
   
6. Click on the red X in top right corner
   
7. To save the formatting for this field: Either:
   
   1. Click on the Save icon on the toolbar
      
   2. Ctrl + S
      
   3. From the Menu: File -> Save

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.

[john1123]

T T
now is show 10.00
but my 0.50 still missing

is that my computer problem??
but i have try at my company's computer, it have a same problem

i'm using win xp sp2, open office v3.4
computer language : English- US
open office language: English-US

[Sliderule]

I am sending you a PM ( Private Message ).

Sliderule

[john1123]

[img]http://gq1.attach.mail.ymail.com/us.f1147.mail.yahoo.com/ya/securedownload?mid=2%5f0%5f0%5f4%5f27110%5fAIy3iGIAACi4T%2fEzPQnyR1GsgDc&pid=2.2&fid=Trash&inline=1&appid=YahooMailNeo&cred=tJZ8pWTbD5LoOojN_ZJBAh56SCgwf1jPrWv1o2petDlkFOQ6Cl7Ak.jqFIHJ_T.wJ3Ig5e0p9jsloJVRC9SKXwnOholU6OQCN.tjw6Bo77YNxCz3usOX_9ZY7LzfLI.a4Moj3a31IoFVmyn_0Ugy&ts=1341372653&partner=ymail&sig=eQqOwB5KcON.J2r.Ti7mEw--[/img]