# Data type money/currency cannot be retourned in DA command
**URL:** https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220
**Category:** Data Abstract
**Tags:** net, delphi
**Created:** [September 22, 2025, 4:00pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220 "2025-09-22T16:00:06Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@fvancrae](https://talk.remobjects.com/u/fvancrae)
#### Post date: [September 22, 2025, 4:00pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/1 "2025-09-22T16:00:06Z")
We have a DA command in a .NET server that returns a parameter of type currency.
However this variant parameter cannot be read as a currency in delphi.
It appears to be a byte array.
How do you return an MSSQL DB type money via a DA command to a delphi client
---
### Author:  [@fvancrae](https://talk.remobjects.com/u/fvancrae)
#### Post date: [September 22, 2025, 4:03pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/2 "2025-09-22T16:03:42Z")
FYI: Another small inconvenience in the schema modeler is that when you change the select SQL statement above he asks to update the parameters and he changes the direction of all the output parameters (to input)
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [September 27, 2025, 12:11pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/3 "2025-09-27T12:11:22Z")
Hi,
> [@fvancrae](#):
>
> It appears to be a byte array.
**EDIT:**
This is as expected. .NET uses Decimal for Currency type so when it writes Variant value, it converts Decimal to Variant.
On Delphi side you can convert variant to Decimal with `VariantToDecimal` and later `DecimalToBCD` & `BCDToCurrency` or call `VariantToBCD` & `BCDToCurrency` methods
---
### Author:  [@RemObjectsSoftware](https://talk.remobjects.com/u/RemObjectsSoftware)
#### Post date: [September 27, 2025, 12:13pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/4 "2025-09-27T12:13:48Z")
> [@fvancrae](#):
>
> FYI: Another small inconvenience in the schema modeler is that when you change the select SQL statement above he asks to update the parameters and he changes the direction of all the output parameters (to input)
Logged as [bugs://D19589](https://www.remobjects.com/portal/bugs/?id=D19589).
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [October 6, 2025, 9:20am UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/5 "2025-10-06T09:20:29Z")
Hi,
> [@fvancrae](#):
>
> FYI: Another small inconvenience in the schema modeler is that when you change the select SQL statement above he asks to update the parameters and he changes the direction of all the output parameters (to input)
Can you give an example of such sql statement, pls?
---
### Author:  [@fvancrae](https://talk.remobjects.com/u/fvancrae)
#### Post date: [October 6, 2025, 12:01pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/6 "2025-10-06T12:01:35Z")
Yes, the SQL from thes screenshot had it
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [October 6, 2025, 1:18pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/7 "2025-10-06T13:18:55Z")
Hi,
why do you want to consume select request as a set of parameters and not as usual fields?
---
### Author:  [@fvancrae](https://talk.remobjects.com/u/fvancrae)
#### Post date: [October 13, 2025, 12:38pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/8 "2025-10-13T12:38:30Z")
I don’t understand your question.
In our code (historically) queries that return only a single record (and which don’t need updating) are typically implemented via commands.
What other approach do you suggest?
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [October 13, 2025, 2:08pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/9 "2025-10-13T14:08:10Z")
Hi,
Thx, for clarification.
by default, you can’t create Select statement in Commands so I’ve messed Tables and Command nodes.
Now I understand the issue but I don’t think that we can easily detect parameter’s direction but we can keep type/size/direction for known parameters.
btw, for tables (i.e. select sql) you can receive money type as currency, but for commands - all parameter values are passed as Variant from server to client so you have received money type as Variant (decimal is stored into variant as array of byte).
---
### Author:  [@RemObjectsSoftware](https://talk.remobjects.com/u/RemObjectsSoftware)
#### Post date: [October 27, 2025, 3:17pm UTC](https://talk.remobjects.com/t/data-type-money-currency-cannot-be-retourned-in-da-command/32220/10 "2025-10-27T15:17:07Z")
[bugs://D19589](https://www.remobjects.com/portal/bugs/?id=D19589) was closed as fixed.