Page 1 of 1

TVirtualTable I have a problem with the Slovenian character set

Posted: Sun 31 Jan 2021 10:59
by zeljkoc
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
ŠŠŠŠŠ

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

Posted: Mon 01 Feb 2021 10:13
by zeljkoc
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.

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

Posted: Mon 01 Feb 2021 13:55
by MaximG
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

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

Posted: Thu 04 Feb 2021 18:04
by zeljkoc

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

Posted: Mon 08 Feb 2021 12:18
by MaximG
Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

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

Posted: Fri 26 Feb 2021 14:53
by zeljkoc
Can you write, what are the plans to solve this problem.

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

Posted: Fri 05 Mar 2021 19:52
by zeljkoc
Available product version: 11.4.1

I still have the same problem

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

Posted: Mon 08 Mar 2021 21:59
by MaximG
Currently, we are investigating the issue you described and hope we will manage to get the results shortly.

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

Posted: Sun 11 Apr 2021 12:15
by zeljkoc
Available product version: 11.4.3

I still have the same problem

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

Posted: Fri 23 Apr 2021 10:49
by zeljkoc
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;

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

Posted: Fri 23 Jul 2021 14:14
by MaximG
We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning our product usage.