TVirtualTable I have a problem with the Slovenian character set

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
zeljkoc
Posts: 7
Joined: Wed 11 Nov 2020 17:14

TVirtualTable I have a problem with the Slovenian character set

Post by zeljkoc » Sun 31 Jan 2021 10:59

Product: Virtual Data Access Components
Product Version: 11.3.2
OS Version: Linux
Platform: x64
Is registered user: True

OS Debian buster LXDE 64 bit
FPC 3.3.1
Lazarus 2.1.0

component: TVirtualTable

I have a problem with the Slovenian character set.

define field:

Name: JMjere
DataType; ftString
Size: 10

if I fill in the field with:
ŠŠŠŠŠŠŠŠŠŠ

deletes my last five
ŠŠŠŠŠ

zeljkoc
Posts: 7
Joined: Wed 11 Nov 2020 17:14

Re: TVirtualTable I have a problem with the Slovenian character set

Post by zeljkoc » Mon 01 Feb 2021 10:13

When i use ftWideString works properly

But I don't use TVirtualTable on its own but in combination with TSQLQuery.

VirtualTable1.Assign(SQLQuery1);
This way I have a problem.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualTable I have a problem with the Slovenian character set

Post by MaximG » Mon 01 Feb 2021 13:55

We will check the workflow of our product according to your description. For this, we need some time. We will inform you
about the results after the end of testing


MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualTable I have a problem with the Slovenian character set

Post by MaximG » Mon 08 Feb 2021 12:18

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

zeljkoc
Posts: 7
Joined: Wed 11 Nov 2020 17:14

Re: TVirtualTable I have a problem with the Slovenian character set

Post by zeljkoc » Fri 26 Feb 2021 14:53

Can you write, what are the plans to solve this problem.

zeljkoc
Posts: 7
Joined: Wed 11 Nov 2020 17:14

Re: TVirtualTable I have a problem with the Slovenian character set

Post by zeljkoc » Fri 05 Mar 2021 19:52

Available product version: 11.4.1

I still have the same problem

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualTable I have a problem with the Slovenian character set

Post by MaximG » Mon 08 Mar 2021 21:59

Currently, we are investigating the issue you described and hope we will manage to get the results shortly.

zeljkoc
Posts: 7
Joined: Wed 11 Nov 2020 17:14

Re: TVirtualTable I have a problem with the Slovenian character set

Post by zeljkoc » Sun 11 Apr 2021 12:15

Available product version: 11.4.3

I still have the same problem

zeljkoc
Posts: 7
Joined: Wed 11 Nov 2020 17:14

Re: TVirtualTable I have a problem with the Slovenian character set

Post by zeljkoc » Fri 23 Apr 2021 10:49

I found a solution to this problem.

The solution is to convert ftString to ftWideString.

I made this change and everything works, for me properly.

Code: Select all

procedure TVirtualTable.DefChanged(Sender: TObject);
var
  FieldDef: TFieldDef;
  i: integer;
begin
  if not FAvoidRefreshData then begin
    if Active then
      FFieldDefsByField := False;
    for i := 0 to TFieldDefs(Sender).Count - 1 do begin
      FieldDef := TFieldDefs(Sender)[i];
      if FieldDef.DataType = ftString then begin
        FAvoidRefreshData := True;
        FieldDef.DataType := ftWideString;
        FAvoidRefreshData := False;
      end;
      if FieldDef.DataType = ftUnknown then begin
        FAvoidRefreshData := True;
        FieldDef.DataType := ftWideString;
        FieldDef.Size := 20;
        FAvoidRefreshData := False;
      end;
      if FieldDef.DataType = ftGuid then begin
        FAvoidRefreshData := True;
        FieldDef.Size := 38;
        FAvoidRefreshData := False;
      end;
    end;

    if FAvoidReload = 0 then
      Reload;
  end;
end;

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualTable I have a problem with the Slovenian character set

Post by MaximG » Fri 23 Jul 2021 14:14

We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning our product usage.

Post Reply