SQL table field type is MONEY, if there are any field in A data: 0.12344 use TQUERY. Edit, tracking will be select (*) from t where id=1 and A=the convert (MONEY, '0.12')

Not here to get to 0.12344, but 0.12, have not understand?

CodePudding user response:

MONEY type ms SQL server is your own types, it is recommended to use standard SQL data types, such as DOUBLE PRECISION

CodePudding user response:

reference 1/f, play big shoot early nuclear response:

MONEY type ms SQL server is your own types, it is recommended to use standard SQL data types, such as DOUBLE PRECISION

In is the field type is TcurrencyField DELPHIj

CodePudding user response:

Convert (money, '0.1234')

CodePudding user response:

TQUERY in the data type of the corresponding field if currency is, but when he was is using local WIN system currency format (default is to 2 decimal places),
1, you can modify the system in the currency set, is not recommended;
2. You can define your own in the system (set in the corresponding field in the TQUERY format), set up trouble;
3. The system started initialization time (for example DM data templates to create Settings: FormatSettings CurrencyDecimals:=2),

3 is the best way, I usually put the date format all a set up here,