Ms sql decimal precision

pdusp

Hello!
Please tell me how to set up for ms sql column decimal(12,3) three decimal part position no more in my grid.
I want to protect user to insert more decimal part.
Is it possible?
Thank you

Bindrid2

for microsoft sql server take a look at https://docs.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql?view=sql-server-2017

pdusp

Thank you!
In ms sql I declare decimal(10.2) and only two items can be fractional parts. User can not enter more decimal positions.

I care more about the user's limitation, he can not write too many decimal parts. Is the editor able to control the decimal number format?
In addition, in DE and other countries, the decimal separator is a comma and, for example, in the US is a dot. Can the editor use global national user settings from a web browser?
Piotr

allan

I'm not entirely clear how your question relates to DataTables. Could you clarify that for me?

Thanks,
Allan

pdusp

Dear Allan,
I give you example:

Ok format: 9999.99
Nok format 9999.999

User should use only two decimal part, when not then form is not valid. Is it possible?

tangerine

@Allan - the op is using the Editor.

@pdusp - I think you will need to provide your own custon formatter. First check the docs, depending on whether you have PHP or .NET.
You will need to decide what to do about rounding, where more than two decimal places are entered.

allan

Are you looking for the number renderer which can be used to format numbers shown in the table?

Allan