Mathematical operations in TVirtualQuery return values of type memo

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Samuel
Posts: 29
Joined: Fri 11 Feb 2011 12:36
Location: Brazil

Mathematical operations in TVirtualQuery return values of type memo

Post by Samuel » Fri 17 Aug 2018 19:36

I need to execute sums / multiplications on a TVIrtualQuery connected to a TVirtualTable but the results are returning as fields of type Memo.

Maybe it's something related to the Windows code page (I'm in Brazil and here we use the "," as decimal separators and the "." as thousands separators).

The image below demonstrates this problem:

[img]https://1drv.ms/u/s!Al-1RWjYXpnaj_QmNijneNQEOu3IoA[/img]

In the link below is a program where I demonstrate this problem:

https://1drv.ms/u/s!Al-1RWjYXpnaj_QlEkE82Ibtsuh-7w

I'm using last version of Unidac and Delphi 10.2 update 3.

Samuel
Posts: 29
Joined: Fri 11 Feb 2011 12:36
Location: Brazil

Re: Mathematical operations in TVirtualQuery return values of type memo

Post by Samuel » Mon 20 Aug 2018 10:19

The "night build" (downloaded today) solves this problem.

Thank you.

Post Reply