VadimMest

But in the real life the client misses files and my version control system doesn’t work properly.

All Integer fields values don’t restored from xml

This is the link on test project

Maybe the problem is in the other parts but it exists. I insist 

When I’ve changed the version to  5.15.0 I’ve got the problem with kbmMemTable savetoxml + loadfromxml. If the Integer field has zero value in the source dataset when the target dataset’s field will contain the null value after the record was loaded from xml.  It was a tricky prob…[Read more]

Maybe the problem is in the other parts but it exists. I insist 🙂

When I’ve changed the version to  5.15.0 I’ve got the problem with kbmMemTable savetoxml + loadfromxml. If the Integer field has zero value in the source dataset when the target dataset’s field will contain the null value after the record was loaded from xml.  It was a tricky p…[Read more]

No, I am not right.

If I add this block the service freezes during sending files

The problem hides in another place.  I can see the same error inside the function CreateNewFileHandle.  AReferences.Items deleted in some parallel thread and this code show error

if AToken<0 then
begin
// Generate unique random token number.
// Its randomized to m…[Read more]

The problem seems in function TkbmMWFilePool.Access(AFilePath:string; const AMode:TkbmMWFileAccessMode; var AToken:integer; var AHandle:THandle; const ADenyWrite:boolean = true):TkbmMWFileReference;

the second call CreateNewFileHandle doesn’t contain ” lst:=FFileReferences.BeginWrite + FFileReferences.EndWrite”

// No token provided, add access…[Read more]

>Error reading kbmMWCustomService.PixelsPerInch: Property PixelsPerInch does not exists (SERVER)
It seems like dfm  file contains property PixelsPerInch but version Delphi what used to build server doesn’t know about this propertiy. The form or the datamodule was opened and was saved in other version Delphi or don’t prepared for your version

Try…[Read more]

Few interesting facts about performance

I run tests for 100 000 records. I know it’s a ridiculous amount of records, but my laptop very fast and I need to see how it affects my client’s workplaces.

The pair  TKbmMemtable + TVirtualQuery works very slowly, very.
The pairs of TKbmMemtable + TkbmMemSQL  and  TVirtualTable  + TVirtualQuery  work…[Read more]

I found two solutions:

1. TKbmMemSQL (only for creating a table)   +  TKbmMemtable + TVirtualQuery (from DevArt UNIDAC)  works properly.
2. Changing ‘Create table’ from SQL Statement to AddField + TVirtualTable  + TVirtualQuery also works properly and faster than the first solution

Thanks, I’ve understood:

I can use: One knmMemTable + Few KbmMemSQL with only modify SQL Statements

I have a table with documents rows in my application (TTable).  User changes these rows by using an interface (it is my code in application)  and my customers have a huge quantity of different external scripts (Fast Script Interpreter) that can c…[Read more]

procedure TForm4.Button1Click(Sender: TObject);
begin
FSQL.ExecSQL(‘create table t1 (id Integer, name char(50))’);
FSQL.ExecSQL(‘select * from t1’);

kbmMemTable1.LoadFromDataSet(FSQL, [mtcpoStructure, mtcpoProperties]);

kbmMemTable1.AppendRecord([1, ‘Name 1’]);
kbmMemTable1.AppendRecord([2, ‘Name 2’]);

FSQL.Tables.Clear;

FSQL.Tables.Add(‘t1’,…[Read more]

1. I’ve found only autogenerated kbmmemtable700d.chm in kbmMemTableDocumentation from  04.19.2018  that is zero usefull. The Kbmmemtable700Man.pdf from customer portal   also cantains zero information how it works

2.  Demo.dpr contains few SQL create table (table9) but no one example  how I can connect to this created table.

When I wrote “The…[Read more]