table locking - but why?

[so-photo]

Hi,

when I create the following:

Code: Select all

dbCon := TMSConnection.Create(NIL);
dbCon.DataBase := sDIC;
dbCon.LoginPrompt := FALSE;
dbCon.Password := 'abc2018#';
dbCon.Username := 'DDM-User';
dbCon.Server := msSQL_SRV;
dbCon.Name := 'DBmR' + IntToStr(DBmRNum);

and create a table also:

Code: Select all

dbPerso := TMSTable.Create(NIL);
Connection := dbCon;
dbPerso.Filtered := FALSE;
dbPerso.Name := 'PERSO' + IntToStr(DBmRNum);
dbPerso.TableName := 'PERSO';
dbPerso.KeyFields := 'PERS_ID';

and setting no other parameter, we have the problem that if i want to update the table with some values the system is waiting for something. Also any changes from SQL Server Mgm Studio are running endless, until i close the connection above. It looks like that the connection is blocking the whole table, but why ???

Using Delphi XE7 and the latest SDAC and MS SQL Server 2017

Thanks!

[azyk]

We cannot reproduce the issue. Please specify whether it is reproduced on our SDACDemo demo project. It is located in the folder "Demos\SDACDemo\" relative to the path where the SDAC demo projects were installed.

If on our demo the issue is not reproduced, please compose a complete test project to demonstrate it and send it to us. In the project, also include the SQL script to create a test database, tables and fill them with test data.