colleagues
colleagues
I'm trying to make localSQL with FireDAC.
Evrithing is OK but
select account, sum(amount) mnt from NUMBERLIST
group by account
leads to "mnt" become string. When I remove "group by" it comes to be float again.
Any Ideas?
CAST() doesn't help.
I'm trying to make localSQL with FireDAC.
Evrithing is OK but
select account, sum(amount) mnt from NUMBERLIST
group by account
leads to "mnt" become string. When I remove "group by" it comes to be float again.
Any Ideas?
CAST() doesn't help.
IT doesn't change types of group by fields,
ReplyDeletebut changes sum() or total() to string.
I get error Expected Float actual WideString. and it not IDE bug as same happens in compiled application. So it could be FireDAC bug. maybe anyone knows some workaround?
ReplyDelete