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?
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
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?
I'm not entirely clear how your question relates to DataTables. Could you clarify that for me?
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?
@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.
Are you looking for the number renderer which can be used to format numbers shown in the table?
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.