Data type money/currency cannot be retourned in DA command

[fvancrae (Frederic Vancraeyveldt)]

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

[fvancrae (Frederic Vancraeyveldt)]

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)

[EvgenyK (Evgeny Karpov)]

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

[RemObjectsSoftware (RemObjects)]

@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.