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