Mathematical operations in TVirtualQuery return values of type memo
Posted: 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.
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.